Senior Snowflake Developer-DPH
Listed on 2026-07-26
-
IT/Tech
Data Engineering, Data Warehousing, Data Analyst, Information Security & Data Protection
Senior Snowflake Developer
The Executive Office of Housing and Livable Communities ("EOHLC" or "Eligible Entity") was established as a Secretariat in 2023 by the Healey-Driscoll Administration to create more homes and lower housing costs for Massachusetts residents. EOHLC's mission is to advance innovative solutions to provide safe, accessible, affordable, and environmentally sustainable housing for all residents and to support the growth of vibrant, livable communities throughout the Commonwealth.
EOHLC offers programs to help prevent homelessness and to help people afford housing. It also offers housing programs and financial assistance for municipalities, local housing authorities, non-profit organizations, and developers.
EOHLC
- Information Technology Division is seeking an experienced Senior Snowflake Developer to design, develop, and support the agency's cloud-based data warehouse environment. This role is responsible for building scalable data solutions that support reporting, analytics, and data-driven decision-making for EOHLC's Public Housing and Rental Assistance Divisions, enabling program teams to effectively manage, analyze, and leverage critical housing and assistance data. The Developer will report to EOHLC Director of Information Technology Development.
of Duties
Responsibilities:
- Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control.
- Ensure data integrity, quality, and security across all data warehousing activities.
- Develop and maintain data pipelines to integrate data from various internal and external sources.
- Develop and maintain data pipelines using tools for data transformation, testing, and deployment. Ensure data pipelines are scalable, reliable, and efficient.
- Write Python code to automate data processing, transformation, and loading tasks, including data ingestion, data quality control, and data visualization.
- Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs.
- Develop and maintain data visualizations and reports using Snowflake's built-in visualization tools or third-party tools like Tableau.
- Ensure data quality, integrity, and security by developing data validation rules, data cleansing processes, and data access controls.
- Optimize snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
- Develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments.
- Participate in code reviews and provide feedback to ensure high-quality code and adherence to coding standards.
- Work closely with the agency's data team and the overall state technology team to ensure alignment on data strategy and technology standards.
- Communicate complex data findings to non-technical stakeholders in a clear and concise manner
- Provide technical guidance and mentorship to junior analysts and other team members
Qualifications:
- 8+ years of experience in Snowflake data warehouse development and management, data engineering field.
- Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts.
- Proficiency with SQL, including snowflake's SQL dialect and complex query writing for performance optimization.
- Experience with Snowflake features, including cloning, time travel, data sharing, and micro-partitioning.
- Strong understanding of Snowflake's architecture, including virtual warehouses, storage, and compute separation.
- Expertise in Snowflake Role-Based Access Control (RBAC), data masking, and encryption.
- Proficiency with data integration tools and ETL/ELT processes.
- Experience in Python or similar scripting languages for automation and data processing.
- Knowledge of data security and compliance standards as they relate to Snowflake.
- Experience with cloud platforms like AWS, Azure and services such as AWS Glue, DMS, S3, Appflow etc.
- Knowledge of data governance frameworks and tools.
- Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
- Strong analytical, problem-solving, and…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).