Moss Adams - Tacoma, WA

posted about 2 months ago

Full-time - Mid Level
Tacoma, 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 in SQL and Python, along with a solid understanding of Snowflake data cloud and Azure data assets, will be vital in this role. Additionally, you will provide solution design leadership and mentor junior engineers and team members, ensuring the growth and development of the team. In this role, you will manage and support the Azure Machine Learning environment in collaboration with the data analytics and reporting team. You will develop ETL processes using data factory and SSIS tools, design and manage the data lake environment, and ensure data quality monitoring and business modeling. Your responsibilities will also include developing, constructing, testing, and maintaining architectures such as databases and large-scale processing systems. You will design, develop, and implement technical solutions in SQL environments, create visual reports in Power BI, and maintain queries and stored procedures using T-SQL. Analyzing data to identify gaps and data quality issues will be part of your daily tasks, along with following the Software Development Life Cycle (SDLC) and maintaining documentation for newly developed and refactored applications. Individuals who thrive at Moss Adams exhibit success skills such as collaboration, critical thinking, emotional intelligence, executive presence, growth mindset, intellectual curiosity, and results focus. This position offers an opportunity to grow as a leader while solving complex and interesting business challenges in a values-driven firm.

Responsibilities

  • Manage and support Azure Machine Learning environment in collaboration with the data analytics & reporting team
  • Develop ETL 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 (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 BI
  • Maintain and develop queries and stored procedures using T-SQL
  • Support data integrations
  • Analyze data and 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 and able to interact with multiple IT teams and business partners both formally and informally
  • Should possess 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

  • Strong analytical skills
  • Good customer service skills

Benefits

  • Annual discretionary bonus eligibility
  • Customized career paths
  • Supportive culture
  • Opportunity for professional growth and development
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service