Snowflake Data Engineer

The Executive Office of Technology Services and Security (EOTSS), through its Office of Data Innovation and Analytics, is hiring a Snowflake Data Engineer to maintain and expand the Commonwealth Information Warehouse. The role builds and maintains secure Snowflake data solutions and pipelines that support statewide analytics, reporting, data sharing, and data-driven decision-making.

Responsibilities

• Design, develop, and optimize data pipelines and data models within Snowflake to support analytics, dashboards, and operational reporting
• Ingest and transform data from diverse sources, including transactional systems, legacy platforms, third-party vendors, and other state agencies
• Implement and manage ELT processes using tools such as IICS, Snowflake SQL, Snowpipe, and cloud-native orchestration frameworks
• Ensure data quality, reliability, and performance through monitoring, testing, and optimization of queries and pipelines
• Apply state data governance, privacy, and security standards, including role-based access control and data classification
• Collaborate with analysts, data scientists, and business stakeholders to translate policy and program needs into technical data solutions
• Support cross-agency data sharing initiatives while maintaining appropriate controls and auditability
• Contribute to platform standards, documentation, and best practices for enterprise data engineering

Preferred

• Experience working in state or local government environments
• Familiarity with data mesh or federated data architectures
• Experience supporting BI tools (e.g., Tableau, Power BI, Looker)
• Knowledge of CI/CD practices for data engineering
• local government experience
• Data mesh architectures
• Federated data architectures
• Tableau
• Power BI
• Looker
• CI/CD practices
• Data engineering

Benefits

• Hybrid work model combining in-office and remote work based on operational needs; specific onsite expectations determined by the Line of Business based on business and operational needs.

Company

• Massachusetts state technology and innovation agency
• Boston, Massachusetts, US
• https://massanf.taleo.net/careersection/ex/jobsearch.ftl
• 201-500 employees

Qualifications

• Experience designing and developing data solutions using Snowflake
• Strong SQL skills and experience with data modeling for analytics and reporting
• Experience building data pipelines using modern ETL/ELT tools and cloud platforms (e.g., AWS, Azure, or GCP)
• Understanding of data governance, security, and compliance principles, preferably in the public sector
• Ability to collaborate across technical and non-technical teams in a complex organizational environment
• Applicants must have (A) at least three (3) years of full-time or equivalent part-time professional or practical experience in the field of information technology data analytics, or (B) any equivalent combination of the required experience and the substitutions below
• An Associate's degree in a related field may substitute for one (1) year of the required experience
• A Bachelor's degree or higher in a related field may substitute for two (2) years of the required experience
• A Master's degree or higher in a related field may substitute for the required experience
• Experience working in state or local government environments
• Familiarity with data mesh or federated data architectures
• Experience supporting BI tools (e.g., Tableau, Power BI, Looker)
• Knowledge of CI/CD practices for data engineering
• Applicants must have (A) at least three (3) years of full-time or equivalent part-time professional or practical experience in the field of information technology data analytics, or (B) any equivalent combination of the required experience and the substitutions below.
• An Associate’s degree in a related field may substitute for one (1) year of the required experience.
• A Bachelor’s degree or higher in a related field may substitute for two (2) years of the required experience.

Required skills

• AWS, Azure, Data Governance, Data Modeling, Data Pipeline Engineering, Data Security and Compliance, ETL/ELT, Google Cloud Platform (GCP), Power BI, SQL, Snowflake, Tableau

Preferred skills

• Experience working in state or local government environments, Familiarity with data mesh or federated data architectures, Knowledge of CI/CD practices for data engineering

Experience

• 3+ years