Napa, CA, Pasadena, CA, Woodland Hills, CA, San Diego, CA, Bellingham, WA, Denver, CO, Walnut Creek, CA, El Segundo, CA, San Francisco, CA, Everett, WA, Phoenix, AZ, Healdsburg, CA, Tri-Cities, WA, Santa Rosa, CA, Albuquerque, NM, Salinas, CA, Kansas City, KS, Salt Lake City, UT, Spokane, WA, Orange County, CA, Eugene, OR, Tacoma, WA, Wenatchee, WA, Medford, OR, Dallas, TX, Yakima, WA, Stockton, CA, Silicon Valley, CA, Sacramento, CA, Portland, OR, Fresno, CA, Houston, TXNapa, CA, Pasadena, CA, Woodland Hills, CA, San Diego, CA, Bellingham, WA, Denver, CO, Walnut Creek, CA, El Segundo, CA, San Francisco, CA, Everett, WA, Phoenix, AZ, Healdsburg, CA, Tri-Cities, WA, Santa Rosa, CA, Albuquerque, NM, Salinas, CA, Kansas City, KS, Salt Lake City, UT, Spokane, WA, Orange County, CA, Eugene, OR, Tacoma, WA, Wenatchee, WA, Medford, OR, Dallas, TX, Yakima, WA, Stockton, CA, Silicon Valley, CA, Sacramento, CA, Portland, OR, Fresno, CA, Houston, TX

At Moss Adams, we champion authenticity. For us, that means fostering a culture of talented people who care—about you, about our clients, and about our communities. Here, you’ll work towards our mission of empowering others to embrace opportunity, growing as a leader along the way. Our firm’s size, middle-market clients, customized career paths, and supportive culture make this a reality. Join a values-driven firm where you’ll have fun while solving complex and interesting business challenges.

Introduction to the Team:
The Senior Data Engineer on the Data Platform Team is primarily responsible for the development, testing and maintenance of the firm's analytical data assets to support DW/BI applications, workflows, reporting, integrations and other solutions. This role collaborates with data scientists, report writers, product group customers, stakeholders and other IT resources to define business needs and build scalable data processing pipelines. This individual is expected to provide solution design leadership, as well as mentor junior engineers and team members. Expertise in SQL and Python, solid experience and understanding on Snowflake data cloud and Azure data assets, and a strong understanding of data integration, data warehousing and dimensional modeling are required. Experience with SQL Server 2019 is desired to support migration from on-prem SQL Server to Snowflake. Strong analytical skills as well as good customer service is preferred.

Individuals who thrive at Moss Adams exhibit the following success skills – Collaboration, Critical Thinking, Emotional Intelligence, Executive Presence, Growth Mindset, Intellectual Curiosity, and Results Focus.

Responsibilities:

In collaboration with the data analytics reporting team, manage and support Azure Machine Learning environmentDevelop ETL using data factory, SSIS toolsDesign, construct, and manage the data lake environment including: Data ingestion, staging, data quality monitoring, and business modelingDevelop, construct, test and maintain architectures (databases and large-scale processing systems)Design, develop and implement technical solutions in SQL environment (databases, SQL, data marts, integrations)Develop visual reports in Power BIMaintain and develop queries and stored procedures using T-SQLSupport data integrationsAnalyze data and identify gaps, data quality and integrity issuesWork in all aspects of development, design, reviews, troubleshooting and post-production issue resolutionFollow SDLC and create and maintain required documentation of newly developed and refactored applications

Qualifications:

Bachelor’s degree or equivalent experience required; emphasis in Computer Science, Computer Engineering or related field preferredMinimum of 3 years of related experience required; experience in a professional services environment preferredHighly skilled in SQL programming in T-SQL building stored procedures and jobsStrong functional understanding of Azure Machine LearningAbility to manage large volume data integration/ETL; experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agentExpertise in identifying and mapping data elements across multiple systemsKnowledge of Power BI report visualizations, Data Analysis Expressions (DAX), Power Query (M), and Power BI data modelingHands-on experience in writing DAX queries and custom calculationsStrong understanding of data integration, quality and validationStrong understanding of MDM, Data Warehouse/Data mart and relational database designExcellent written and verbal communication skills and able to interact with multiple IT teams and business partners both formally and informallyShould possess sound knowledge of SDLC using Azure DevOpsSelf-motivated with the ability to work both independently and in a team environmentEffective time management, ability to multi-task with changing priorities while continuing to provide exceptional client serviceAbility to travel as needed, approximately 5%

Moss Adams is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law.

Moss Adams complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact careers@mossadams.com.

Some local/state regulations require employers to disclose the pay range in job postings. While this is the typical range of pay for the position, actual pay may vary based on internal equity, knowledge, experience, skillset, and geographic location among other factors. It’s uncommon for an individual to be hired at the top end of the pay range. This position may be eligible for an annual discretionary bonus. For more information about our benefit offerings and other total rewards, visit our careers page.

#LI-AC1

At Moss Adams, we champion authenticity. For us, that means fostering a culture of talented people who care—about you, about our clients, and about our communities. Here, you’ll work towards our mission of empowering others to embrace opportunity, growing as a leader along the way. Our firm’s size, middle-market clients, customized career paths, and supportive culture make this a reality. Join a values-driven firm where you’ll have fun while solving complex and interesting business challenges.

Introduction to the Team:
The Senior Data Engineer on the Data Platform Team is primarily responsible for the development, testing and maintenance of the firm's analytical data assets to support DW/BI applications, workflows, reporting, integrations and other solutions. This role collaborates with data scientists, report writers, product group customers, stakeholders and other IT resources to define business needs and build scalable data processing pipelines. This individual is expected to provide solution design leadership, as well as mentor junior engineers and team members. Expertise in SQL and Python, solid experience and understanding on Snowflake data cloud and Azure data assets, and a strong understanding of data integration, data warehousing and dimensional modeling are required. Experience with SQL Server 2019 is desired to support migration from on-prem SQL Server to Snowflake. Strong analytical skills as well as good customer service is preferred.

Individuals who thrive at Moss Adams exhibit the following success skills – Collaboration, Critical Thinking, Emotional Intelligence, Executive Presence, Growth Mindset, Intellectual Curiosity, and Results Focus.

Responsibilities:

In collaboration with the data analytics reporting team, manage and support Azure Machine Learning environmentDevelop ETL using data factory, SSIS toolsDesign, construct, and manage the data lake environment including: Data ingestion, staging, data quality monitoring, and business modelingDevelop, construct, test and maintain architectures (databases and large-scale processing systems)Design, develop and implement technical solutions in SQL environment (databases, SQL, data marts, integrations)Develop visual reports in Power BIMaintain and develop queries and stored procedures using T-SQLSupport data integrationsAnalyze data and identify gaps, data quality and integrity issuesWork in all aspects of development, design, reviews, troubleshooting and post-production issue resolutionFollow SDLC and create and maintain required documentation of newly developed and refactored applications

Qualifications:

Bachelor’s degree or equivalent experience required; emphasis in Computer Science, Computer Engineering or related field preferredMinimum of 3 years of related experience required; experience in a professional services environment preferredHighly skilled in SQL programming in T-SQL building stored procedures and jobsStrong functional understanding of Azure Machine LearningAbility to manage large volume data integration/ETL; experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agentExpertise in identifying and mapping data elements across multiple systemsKnowledge of Power BI report visualizations, Data Analysis Expressions (DAX), Power Query (M), and Power BI data modelingHands-on experience in writing DAX queries and custom calculationsStrong understanding of data integration, quality and validationStrong understanding of MDM, Data Warehouse/Data mart and relational database designExcellent written and verbal communication skills and able to interact with multiple IT teams and business partners both formally and informallyShould possess sound knowledge of SDLC using Azure DevOpsSelf-motivated with the ability to work both independently and in a team environmentEffective time management, ability to multi-task with changing priorities while continuing to provide exceptional client serviceAbility to travel as needed, approximately 5%

Moss Adams is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law.

Moss Adams complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact careers@mossadams.com.

Some local/state regulations require employers to disclose the pay range in job postings. While this is the typical range of pay for the position, actual pay may vary based on internal equity, knowledge, experience, skillset, and geographic location among other factors. It’s uncommon for an individual to be hired at the top end of the pay range. This position may be eligible for an annual discretionary bonus. For more information about our benefit offerings and other total rewards, visit our careers page.

#LI-AC1