Remote Data Mart Lead - Data Architecture & Migration

My3tech

United States

Remote

USD 140,000 - 190,000

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Job summary

My3tech is seeking an experienced Data Mart Technical Lead to drive the design, development, and implementation of a modern Data Mart as part of a 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.

The role requires leading the technical design and development of the Data Mart, data models, ETL/ELT

Qualifications

10+ years in data engineering, data warehousing, or enterprise data integration.
Strong SQL expertise with complex queries and tuning.
Experience migrating legacy data to modern data platforms.

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 SMEs, 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.