Snowflake Developer/Administrator

State of Massachusetts - Boston, MA

Full-time - Mid Level

Remote - Boston, MA

Executive, Legislative, and Other General Government Support

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 agency's Snowflake data warehouse. This role involves collaborating with various stakeholders to ensure efficient data management, reporting, and analytics, while also overseeing data security and compliance. The position plays a critical role in optimizing data processes and ensuring high availability of data services.

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.
• Collaborate with the Security Team to support secure data handling and regulatory compliance requirements.
• 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.

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.
• SnowPro Advanced certification is a plus.
• Knowledge of data governance frameworks and tools.

Nice-to-haves

• 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 including health insurance, retirement plans, and paid time off.