Senior Snowflake Developer

JOB TITLE:

Senior Snowflake Developer

JOB LOCATION:

Boston MA WAGE RANGE*: $80-$85 JOB NUMBER:
Client-26-1076-OCDDE-IT

JOB DESCRIPTION:

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. Description 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 Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits;

dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.