CITIZENS HOUSING & PLANNING
Snowflake Developer/Administrator
CITIZENS HOUSING & PLANNING, Boston, Massachusetts, us, 02298
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. 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. DUTIES AND RESPONSIBILITIES (NOT ALL INCLUSIVE): 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. PREFERRED QUALIFICATIONS: 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. Desired Skills/Experience: Experience implementing data masking, and aggregation to reduce privacy risks 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. COMMENTS: Please upload resume and cover letter. This position would be expected to follow a hybrid model of reporting to work that combines in-office workdays and work from home days, as needed. Salary placement is determined by years of experience and education directly related to the position and the Human Resources Division’s Recruiting Guidelines. QUALIFICATIONS: First consideration will be given to those applicants that apply within the first 14 days. Minimum Entrance 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. An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply. The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.
#J-18808-Ljbffr
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. 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. DUTIES AND RESPONSIBILITIES (NOT ALL INCLUSIVE): 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. PREFERRED QUALIFICATIONS: 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. Desired Skills/Experience: Experience implementing data masking, and aggregation to reduce privacy risks 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. COMMENTS: Please upload resume and cover letter. This position would be expected to follow a hybrid model of reporting to work that combines in-office workdays and work from home days, as needed. Salary placement is determined by years of experience and education directly related to the position and the Human Resources Division’s Recruiting Guidelines. QUALIFICATIONS: First consideration will be given to those applicants that apply within the first 14 days. Minimum Entrance 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. An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply. The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.
#J-18808-Ljbffr