Description

Design and maintain enterprise-scale data pipelines and modernize legacy application data systems for state agencies.

This role is remote.

Responsibilities

• Design, build, and maintain enterprise-scale data pipelines using Azure Data Factory (ADF).
• Develop and optimize Azure SQL-based data warehouses, data marts, and complex transformation logic.
• Architect and implement Power BI semantic models with DAX, Power Query (M), and dimensional modeling best practices.
• Lead legacy system analysis, data profiling, cleansing, and migration strategies for operational and case management systems.
• Mentor developers and analysts, overseeing resource planning and ensuring data quality and integrity.

Required Skills

• 8+ years of progressive experience in Data Warehouse/Data Mart environments with cloud-based solutions.
• Advanced expertise with Azure Data Factory (ADF) and Azure SQL Server.
• Proven ability to deliver enterprise-grade Power BI semantic models, including advanced DAX and Power Query transformations.
• Proficient in SQL with experience in data modeling methodologies (e.g., Kimball, Inmon).
• Demonstrated experience in legacy data migration, including strategy definition, mapping, cleansing, and execution.
• Strong understanding of data governance, security, and compliance principles.

Preferred Skills

• Experience implementing CI/CD pipelines and infrastructure-as-code in a data engineering context.
• Exposure to DevOps practices for data operations and delivery.

Key Skills

Education

Any Graduate