The Department of Mental Health (DMH) needs to extract, transform, and load (ETL) data to build and maintain well-managed data solutions and pipelines, ensuring the availability and integrity of data across DMH systems.
Requirements
- 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).
Responsibilities
- 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.
Other
- Contracts are renewable, subject to the Department approval, performance and allocation of fund.
- Benefits are unavailable with the exception of sick leave accruals.
- All employees will be paid on a biweekly basis and must have direct deposit.
- Bilingual or multilingual fluency
- An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
