Snowflake Developer and Administrator

Commonwealth of Massachusetts•Boston, MA

8d•Hybrid

About The Position

Executive Office of Housing and Livable Communities (EOHLC) is seeking a Data Warehouse Analyst III/ Snowflake Developer and Administrator in the Information Technology Unit! AGENCY MISSION: The Executive Office of Housing and Livable Communities (EOHLC) is charged with creating more homes in Massachusetts and lowering housing costs for residents. Formerly known as the Department of Housing and Community Development (DHCD), EOHLC works with municipalities, local housing authorities, non-profit organizations, and development partners to provide affordable housing options, financial assistance, and other support to Massachusetts communities. OVERVIEW OF ROLE: The Snowflake Developer and Administrator leads the implementation and maintenance of our new Snowflake data warehouse and plays a critical role in designing, building, and supporting the components of the agency’s data warehouse. This position involves working with various stakeholders to ensure accurate and efficient data management, reporting, and analytics. Collaborate closely with the technology group, the agency data team, agency program staff and external organizations that assist in delivery of EOHLC programs. The Snowflake Developer and Administrator will report to Director of IT Development - EOHLC.

Requirements

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 application development and support, or (B) any equivalent combination of the required experience and the substitutions below.
Substitutions: I. An Associate’s degree in a related field may substitute for one (1) year of the required experience. II. A Bachelor’s degree or higher in a related field may substitute for two (2) years of the required experience. III. A Master’s degree or higher in a related field may substitute for the required experience

Nice To Haves

7+ years of experience in Data warehouse management, data engineering, database administration.
Minimum of 5 years of hands-on experience with Snowflake as a Developer and administrator.
Proficiency with SQL 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.
Familiarity with 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, or GCP.
SnowPro Advanced certification is a plus.
Knowledge of data governance frameworks and tools.
Experience implementing data masking, and aggregation to reduce privacy risks
Relevant IT/Analytic certifications (e.g., SnowPro, AWS, Tableau, Azure, etc.).
Experience integrating data from Salesforce solutions.
Experience with Operational Data Stores
Familiarity JIRA or other project management tools.
Experience using Github.
Experience working on projects in the affordable housing sector or other public benefit programs.

Responsibilities

Data Warehouse Management: · Oversee Snowflake data warehouse setup, configuration, maintenance, and optimization.
Implement and manage Role-Based Access Control (RBAC) policies to secure sensitive data and manage permissions.
Monitor and manage Snowflake storage and compute costs, implementing optimization strategies as needed.
Set up and manage data sharing, private links, and secure data exchange within Snowflake.
Support data warehouse backup, recovery, and disaster recovery planning.
Collaboration and Communication : · Collaborate with data engineering teams to design, build, and maintain efficient data pipelines for data ingestion, transformation, and integration within Snowflake.
Performance Optimization: · Work on data integration with various source systems, optimizing data flow and performance.
Develop and enforce standards for data transformation, quality, and governance.
Tune and optimize complex SQL queries and Snowflake database structures for performance.
Utilize Snowflake’s clustering, materialized views, and caching to enhance query performance.
Ensuring Data Services : · Troubleshoot and resolve data-related issues, ensuring minimal downtime and high availability of data services.
Data Security & Compliance: · Implement data security protocols, ensuring compliance with organizational policies and data privacy regulations.
Perform regular audits and assessments of Snowflake security configurations and user access.
Collaborate with the Security Team to support secure data handling and regulatory compliance requirements.
Monitoring & Performance: · Develop and maintain automated monitoring solutions for Snowflake environments to track usage, performance, and security.
Set up alerts, notifications, and dashboards to monitor Snowflake resources, usage, and issues.
Automate routine administrative tasks and data load processes to improve operational efficiency.