Snowflake Developer

Title: Snowflake Developer, hybrid

Location: Boston MA 02108

Duration: 6 months + extensions

Candidates must be local to Boston,MA and confirm proof of residency.

Position Overview:

The Snowflake Data Engineer will be responsible for designing, building, and maintaining scalable, secure, and high-quality data solutions on the Snowflake cloud data platform to support statewide analytics, reporting, and data-sharing initiatives through our CIW. This role plays a critical part in enabling data-driven decision-making across agencies while ensuring compliance with state policies, data governance standards, and security requirements.

The standard work schedule is Monday through Friday, 9:00 AM 5:00 PM .

This position follows a hybrid work model , combining in-office and remote work based on operational needs. All hires must meet applicable onsite requirements and be available to report in person for key activities, including onboarding and offboarding (such as equipment pickup and return). Specific onsite expectations will be determined by the Line of Business based on business and operational needs.

Key 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.

Required 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.

Preferred Qualifications

• 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.