Business Intelligence & Extract, Transform and Load (ETL) Data Analyst Lead - Contractor

The Department of Mental Health (DMH) is seeking a dynamic individual to serve in a contracted role as Business Intelligence & Extract, Transform and Load (ETL) Data Analyst Lead. 

This contract position reports to the Director of Data Management in the Data and Analytics Unit. This role supports the Data Director and the Department by providing technical expertise in extracting, transforming, and loading (ETL) data to build and maintain well-managed data solutions and pipelines.

The ETL Analyst Lead will collaborate with Information Technology teams and business units to design, develop, and optimize data integration processes, ensuring the availability and integrity of data across DMH systems. This position will also play a key role in managing data workflows, troubleshooting ETL processes, and ensuring adherence to data governance, security, and compliance policies.

 Duties and Responsibilities (these are a general summary and not all inclusive):

• Lead the planning, development, and execution of ETL processes to support the Data and Analytics Unit.
• Design, build, and maintain ETL pipelines that integrate data from multiple sources into centralized repositories.
• Ensure data quality, lineage, and metadata management by enforcing best practices in ETL development and execution.
• Monitor and troubleshoot ETL processes, identifying and resolving data integration issues to ensure reliability and efficiency.
• Collaborate with IT and business stakeholders to define data architecture, data storage solutions, and integration strategies.
• Optimize database queries and performance, ensuring efficient data extraction, transformation, and loading.
• Develop, document, and implement ETL standards and best practices for data management and governance.
• Work with data analysts and business units to understand data requirements and implement solutions that meet reporting and analytical needs.
• Create and execute SQL queries, stored procedures, and scripts to transform and validate data.
• Implement automation for recurring ETL processes, minimizing manual interventions.
• Ensure data security and compliance with applicable laws, regulations, and policies.
• Perform unit testing and validation on ETL processes and data transformations before deployment.
• Generate reports, dashboards, and data visualizations to provide insights into data processing and quality.
• Provide training and mentorship to team members on ETL best practices, data integration tools, and methodologies.
• Stay updated with industry trends and new technologies related to ETL, data engineering, and cloud-based data solutions.
• Perform other related duties as assigned to maintain high-quality data integration services

Preferred Qualifications:

• Proven track record of relevant technical experience in ETL development, including SQL Server, Informatica, Tableau Prep, Snowflake, and Excel Power Query.
• Strong SQL skills, including experience in writing and optimizing complex queries, stored procedures, and