Senior Data Mart Lead - Modern Data Warehouse & Migration

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

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.