About usWe are a technology solution development and management consulting practice. Our focus is on real-world problems and real-world solutions. We build engaging custom software, integrate commercial solutions, and automate IT. The key to our success is our people; people who value clear communication, pragmatism, and commitment to deliver complete solutions.Our consultants come from all backgrounds, ranging from the self-taught to academics with advanced degrees. One thing all of our consultants have in common is a desire to learn and collaborate with their team. We encourage and invest in the growth of our employees. We need you to help us grow; let us help you grow too!About the jobYou are a Senior Data Architect with a background in customer facing Business Intelligence who thrives when introducing and integrating different platforms and data schemas to produce actionable information by line of business.You will help to develop our clients' data strategies, supporting the design of the data architecture through needs analysis, data mining, persistence modeling, and a wide variety of information sharing channels. You are an effective communicator, who enjoys collaborating with team-mates to create new solutions.Our projects are very diverse, ranging from AI image recognition to retail mobile/web applications, vehicle information and communication systems, healthcare, and more! As a Senior Data Solution Architect, this position will also provide opportunities to serve as a data consultant across our engagement teams www.iTrellis.comA day in the life as an iTrellis consultant is never the same. There are a lot of opportunities to try new things across our engagement teams, as well as internal initiatives, e.g. giving presentations at coding schools and contributing to our Program Management development project Portfolio++.Responsibilities include

• Ability to meet with business leaders, interpret business needs, and imagine data architecture and line of business information delivery strategies.
• Develop and maintain scalable data pipelines and builds out new API integrations to support continuing increases in data volume and complexity.
• Ability to translate design document elements into application code and actively participation in code and design reviews.
• Collaborate with peers to design scalable and flexible solutions that will grow with business demands.
• Outstanding skills presenting to both technical and executive audiences, whether impromptu on a whiteboard or using presentations and demos
• Support the BI environment for the enterprise by enabling new features, evangelizing best practices, resolving customer issues and, working with vendors and partners when additional support is needed.
• Provide technical guidance on how to resolve customer-specific technical challenges.
• Support other team members develop their expertise.
• Support developing and documenting standards and practices.

Your skills include the following

• Hands-on experience working with modern ETL, BI tools & technology.
• Hands-on delivery experience in leading cloud data platforms: Snowflake, Azure Synapse.
• Extensive recent experience with SQL and SQL analytics: SQL Server, SSIS, SSRS, SSAS
• Hands-on experience implementing ETL pipelines using packaged tools: Attunity, Azure Data Factory
• Familiarity and experience with common BI and data exploration tools - Power BI, DAX
• Software development experience with C/C++ a definite plus.
• Scripting experience with Python, Ruby, Perl, Bash a definite plus.
• Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Strong organizational skills.
• Excellent written and oral communication skills.

The benefitsiTrellis provides an inspiring environment to improve your career and thrive. Our strong benefits package includes the following:

• A very low deductible Medical, Dental, Vision, and Life Insurance of which the company will pay 100% of the premiums for you, and 50% for any eligible dependents. For those that elect to pursue healthcare coverage elsewhere we offer a monthly stipend to help offset your costs.

• We presently support your contributions to a 401(k) Plan with 100% Company matching for the first 3% of your contributions, and match an additional 50% for any elections you make up to 5% of your annualized salary; All Company Contributions vest immediately

• We offer flexible scheduling arrangements and 120 hours of Paid Time Off, in addition to 8 Paid Holidays.

• Training and education resources relevant to your discipline will be made available to help guide the Unique Career Development opportunities available to you. This includes licenses to Pluralsight and a stipend going towards continuous education, conferences, and meetups.

iTrellis is an equal opportunity employer and does not discriminate against any applicants or employees on the base of race, color, religion, sex, sexual orientation, national origin, age, disability or genetics or any other legally protected class. **At this time, we do NOT offer Visa sponsorship**