Remote Data Mart Lead - ETL & Data Architecture

My3tech; South Dakota; Remote; USD 140,000 - 190,000; Full time

Job summary

My3tech in the United States is 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.

Qualifications

• 10+ years in data engineering, data warehousing, or enterprise data integration with technical leadership.
• Strong SQL expertise with complex queries, stored procedures, and optimization.
• Hands-on ETL/ELT development, dimensional modeling, and Data Mart architecture.
• Experience migrating legacy data to modern data platforms.
• Experience with data validation, reconciliation, and large-volume processing.
• Ability to independently lead technical discussions and drive deliverables.

Responsibilities

• Lead technical design and development of the Data Mart, including data architecture and ETL/ELT processes.
• 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 SQL queries, stored procedures, and data pipelines.
• Establish data quality controls, error handling, monitoring, and performance optimization.
• Collaborate with state IT, business analysts, Medicaid SMEs, and development teams.
• Review designs, code, and deliverables from developers.
• Lead root-cause analysis and resolution of data discrepancies and production issues.
• Own technical documentation, deployment readiness, and knowledge transfer.

Skills

SQL

ETL/ELT

Data warehousing

Data modeling

Data migration

Leadership

Communication

Tools

SQL Server

SSIS

Azure Data Factory

Databricks

Spark

Job description

My3tech in the United States is 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.