Snowflake Developer/Administrator

$98,042 - $143,978/Yr

Exec Office of Housing and Livable Communities - Boston, MA

Full-time - Mid Level

Remote - Boston, MA

51-100 employees

About the position

The Snowflake Developer and Administrator at the Executive Office of Housing and Livable Communities (EOHLC) is responsible for leading the implementation and maintenance of the Snowflake data warehouse. This role is critical for designing, building, and supporting the agency's data management, reporting, and analytics efforts. The position requires collaboration with various stakeholders to ensure efficient data management and compliance with data security protocols.

Responsibilities

• 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.
• Collaborate with data engineering teams to design, build, and maintain efficient data pipelines for data ingestion, transformation, and integration within Snowflake.
• 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.
• Troubleshoot and resolve data-related issues, ensuring minimal downtime and high availability of data services.
• 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.
• Develop and maintain automated monitoring solutions for Snowflake environments to track usage, performance, and security.

Requirements

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

Nice-to-haves

• 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 with JIRA or other project management tools.
• Experience using Github.
• Experience working on projects in the affordable housing sector or other public benefit programs.

Benefits

• Comprehensive employee benefits package
• Hybrid work schedule options
• Equal Opportunity Employer policies