Senior Data Engineer - Snowflake

$106,000 - $152,000/Yr

Moss Adams - Yakima, WA

Full-time - Mid Level

Yakima, WA

Professional, Scientific, and Technical Services

About the position

At Moss Adams, we champion authenticity, fostering a culture of talented individuals who care about each other, our clients, and our communities. As a Senior Data Engineer on the Data Platform Team, you will play a crucial role in the development, testing, and maintenance of the firm's analytical data assets. This position supports various applications, workflows, reporting, integrations, and other solutions essential for our operations. You will collaborate closely with data scientists, report writers, product group customers, stakeholders, and other IT resources to define business needs and build scalable data processing pipelines. Your expertise will not only guide the technical direction of projects but also mentor junior engineers and team members, ensuring a collaborative and growth-oriented environment. In this role, you will be expected to provide solution design leadership, leveraging your strong background in SQL and Python, as well as your solid experience with Snowflake data cloud and Azure data assets. A deep understanding of data integration, data warehousing, and dimensional modeling is essential. Additionally, experience with SQL Server 2019 is desired to facilitate the migration from on-prem SQL Server to Snowflake. Strong analytical skills and a commitment to excellent customer service are preferred traits for candidates who thrive in our dynamic environment. At Moss Adams, we value collaboration, critical thinking, emotional intelligence, executive presence, growth mindset, intellectual curiosity, and results focus, all of which contribute to our mission of empowering others to embrace opportunity and grow as leaders.

Responsibilities

• Manage and support Azure Machine Learning environment in collaboration with the data analytics & reporting team.
• Develop ETL processes using data factory and SSIS tools.
• Design, construct, and manage the data lake environment, including data ingestion, staging, data quality monitoring, and business modeling.
• Develop, construct, test, and maintain architectures, including databases and large-scale processing systems.
• Design, develop, and implement technical solutions in SQL environment, including databases, SQL, data marts, and integrations.
• Develop visual reports in Power BI.
• Maintain and develop queries and stored procedures using T-SQL.
• Support data integrations and analyze data to identify gaps, data quality, and integrity issues.
• Work in all aspects of development, design, reviews, troubleshooting, and post-production issue resolution.
• Follow SDLC and create and maintain required documentation of newly developed and refactored applications.

Requirements

• Bachelor's degree or equivalent experience required; emphasis in Computer Science, Computer Engineering or related field preferred.
• Minimum of 3 years of related experience required; experience in a professional services environment preferred.
• Highly skilled in SQL programming in T-SQL, building stored procedures and jobs.
• Strong functional understanding of Azure Machine Learning.
• Ability to manage large volume data integration/ETL; experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agent.
• Expertise in identifying and mapping data elements across multiple systems.
• Knowledge of Power BI report visualizations, Data Analysis Expressions (DAX), Power Query (M), and Power BI data modeling.
• Hands-on experience in writing DAX queries and custom calculations.
• Strong understanding of data integration, quality, and validation.
• Strong understanding of MDM, Data Warehouse/Data mart, and relational database design.
• Excellent written and verbal communication skills, able to interact with multiple IT teams and business partners both formally and informally.
• Sound knowledge of SDLC using Azure DevOps.
• Self-motivated with the ability to work both independently and in a team environment.
• Effective time management, ability to multi-task with changing priorities while continuing to provide exceptional client service.

Nice-to-haves

• Experience with SQL Server 2019 to support migration from on-prem SQL Server to Snowflake.
• Strong analytical skills and good customer service orientation.

Benefits

• Annual discretionary bonus eligibility.
• Customized career paths and supportive culture.
• Opportunities for professional development and growth.