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

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

Description

 

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 performance tuning for relational databases.
• Practical knowledge of data warehousing concepts, including ETL pipelines, data modeling, and database optimization.
• Experience in defining business requirements and technical specifications for data integration and transformation solutions.
• Hands-on experience in designing and developing data models for analytical applications.
• Expertise in ETL tools and processes, including Informatica, Tableau Prep, Excel Power Query, and Excel-based data transformation.
• Experience working with BI tools such as Tableau, Microsoft Power BI, and SQL Server Reporting Services (SSRS).
• Strong understanding of data governance, data quality management, metadata management, and best practices for ensuring data accuracy and consistency.
• Experience with process automation for ETL workflows to enhance efficiency and reliability.
• Familiarity with cloud-based data platforms, specifically Snowflake, and best practices for cloud ETL and data lake architectures.
• Knowledge of Agile development methodologies, SDLC, and software design patterns relevant to ETL and data integration projects.
• Ability to perform data analysis, query design, data visualization, and statistical analysis to support decision-making.
• Experience with software testing methodologies, including test planning and execution for ETL processes.
• Strong problem-solving skills with the ability to troubleshoot and optimize ETL pipelines and data workflows.
• Excellent communication skills, with the ability to translate business needs into technical solutions and collaborate across departments.
• Given the population served, bilingual or multilingual fluency

Period of Service: 

4/30/2025 - 4/30/2026. Contracts are renewable, subject to the Department approval, performance and allocation of fund.

Additional Information:

• Benefits are unavailable with the exception of sick leave accruals.
• Contracts are renewable, subject to the Department approval, performance and allocation of funds.
• All employees will be paid on a biweekly basis and must have direct deposit.

DMH Mission Statement:

The Department of Mental Health assures and provides access to services and supports to meet the mental health needs of individuals of all ages, enabling them to live, work and participate in their communities. The Department establishes standards to ensure effective and culturally competent care to promote recovery. The Department sets policy, promotes self-determination, protects human rights and supports mental health training and research.

Pre-Hire Process:

A criminal background check will be completed on the recommended candidate as required by the regulations set forth by the Executive Office of Health and Human Services prior to the candidate being hired. For more information, please visit http://www.mass.gov/hhs/cori

Education, licensure and certifications will be verified in accordance with the Human Resources Division’s Hiring Guidelines.

Education and license/certification information provided by the selected candidate(s) is subject to the Massachusetts Public Records Law and may be published on the Commonwealth’s website.

If you require assistance with the application/interview process and would like to request an ADA accommodation, please click on the link and complete the ADA Reasonable Accommodation Request Form.

For questions regarding this requisition, please contact Executive Office of Health and Human Services Human Resources at 1-800- 510-4122 Ext. #4

 

Qualifications

 

First consideration will be given to those applicants that apply within the first 14 days.

 Please see Preferred Qualifications.

 

Salary placement is determined by a combination of factors, including the candidate’s years of directly related experience and education, and alignment with our internal compensation structure as set forth by the Human Resources Division’s Hiring Guidelines. For all bargaining unit positions (non-management), compensation is subject to the salary provisions outlined in the applicable collective bargaining agreement and will apply to placement within the appropriate salary range.

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

Title 101 CMR 23.00 (“Regulation”) requires certain agency staff to have received the COVID-19 vaccination and Influenza vaccination, or have taken required mitigation measures, to prevent viral infection and transmission in State Hospitals and State Congregate Care Facilities. The Regulation applies to this position. Successful candidates will be required to acknowledge and attest to your vaccination status for both COVID-19 and Influenza. 

 

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.  Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements.  We encourage individuals who believe they have the skills necessary to thrive to apply for this role.

 Official Title: Program Coordinators

Primary Location

: United States-Massachusetts-Boston-25 Staniford Street

Job

: Administrative Services

Agency

: Department of Mental Health

Schedule

: Full-time

Shift

: Day

Job Posting

: Apr 30, 2025, 4:22:46 PM

Number of Openings

: 1

Salary

: 60.00 - 104.00 HourlyIf you have Diversity, Affirmative Action or Equal Employment Opportunity questions or need a Reasonable Accommodation, please contact Diversity Officer / ADA Coordinator: William Herbert/William.L.Herbert3@mass.gov - 6173488473Bargaining Unit: NonConfidential: NoPotentially Eligible for a Hybrid Work Schedule: Yes