Data Mart Technical Lead

My3tech; South Dakota; On-site; USD 120,000 - 180,000; Full time

Job summary

My3tech seeks a Data Mart Technical Lead to drive the design, development, and implementation of a modern Data Mart as part of a state Medicaid modernization initiative. You will provide technical leadership for legacy data migration, data integration, transformation, and reconciliation to meet reporting and operational needs.

The role requires 10+ years in data engineering or data warehousing with hands-on ETL/ELT, data modeling, and data migration expertise, plus strong SQL skills.

Qualifications

• 10+ years in data engineering or data warehousing with leadership experience.
• Strong SQL expertise including complex queries and performance tuning.
• Hands-on ETL/ELT development, dimensional modeling, and Data Mart architecture.
• Experience migrating legacy data to modern data platforms.
• Ability to lead technical discussions and drive deliverables to completion.

Responsibilities

• Lead the technical design and development of the Data Mart, including data architecture, data models, ETL/ELT processes, and integration.
• Analyze legacy systems, source data structures, business rules, and existing data flows.
• Define source-to-target mappings, transformation logic, and data migration strategies.
• Lead data profiling, cleansing, validation, reconciliation, and conversion activities.
• Design and optimize complex SQL queries, stored procedures, and data pipelines.
• Establish data quality controls, error handling, monitoring, and performance optimization.
• Collaborate with state IT, business analysts, Medicaid subject matter experts, and development teams.
• Review technical designs, code, and deliverables produced by developers.
• Lead root-cause analysis and resolution of data discrepancies and production issues.
• Own technical documentation, deployment readiness, and knowledge transfer.

Skills

SQL

Data modeling

ETL/ELT development

Data warehousing

Technical leadership

Data migration

Data quality

Collaboration

Tools

SQL Server

SSIS

Azure Data Factory

Databricks

Spark

Job description

We are seeking an experienced Data Mart Technical Lead to drive the design, development, and implementation of a modern Data Mart as part of a state Medicaid modernization initiative. The resource will provide technical leadership for legacy data migration, data integration, transformation, and reconciliation while ensuring the new solution meets business, reporting, and operational requirements.

Scope of Services / Responsibilities

• Lead the technical design and development of the Data Mart, including data architecture, data models, ETL/ELT processes, and integration.
• Analyze legacy systems, source data structures, business rules, and existing data flows.
• Define source-to-target mappings, transformation logic, and data migration strategies.
• Lead data profiling, cleansing, validation, reconciliation, and conversion activities.
• Design and optimize complex SQL queries, stored procedures, and data pipelines.
• Establish data quality controls, error handling, monitoring, and performance optimization.
• Collaborate with state IT, business analysts, Medicaid subject matter experts, and development teams.
• Review technical designs, code, and deliverables produced by developers.
• Lead root-cause analysis and resolution of data discrepancies and production issues.
• Own technical documentation, deployment readiness, and knowledge transfer.
• 10+ Years: Experience in data engineering, data warehousing, or enterprise data integration, including technical leadership experience.
• Strong SQL expertise, including complex queries, stored procedures, and query optimization.
• Hands-on experience with ETL/ELT development, dimensional modeling, and Data Mart architecture.
• Demonstrated experience migrating legacy data into modern data platforms.
• Experience with data validation, reconciliation, and large-volume data processing.
• Ability to independently lead technical discussions and drive deliverables to completion.

Preferred Qualifications

• Experience with Medicaid, MMIS, state government systems, provider enrollment, claims, eligibility, or healthcare data.
• Experience with SQL Server, SSIS, Azure Data Factory, Databricks, Spark, or equivalent technologies is beneficial, depending on the project's technology stack.