Data Mart Lead - Modern Data Warehousing & ETL Architect

My3tech; Pierre (SD); On-site; USD 120,000 - 180,000; Full time

Job summary

My3tech is seeking an experienced Data Mart Technical Lead to drive design, development, and implementation of a modern Data Mart as part of a state Medicaid modernization initiative. The role provides technical leadership for migration, data integration, transformation, and reconciliation to ensure reporting and operations meet requirements.

You will lead data modeling, ETL processes, performance optimization, and collaboration with state IT, business analysts, and SMEs.

Qualifications

• 10+ years in data engineering, warehousing, or enterprise data integration with leadership.
• Strong SQL expertise including complex queries and optimization.
• Hands-on ETL/ELT development, dimensional modeling, and Data Mart architecture.

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.
• Own technical documentation, deployment readiness, and knowledge transfer.
• Demonstrate ability to independently lead technical discussions and drive deliverables to completion.

Job description

My3tech is seeking an experienced Data Mart Technical Lead to drive design, development, and implementation of a modern Data Mart as part of a state Medicaid modernization initiative. The role provides technical leadership for migration, data integration, transformation, and reconciliation to ensure reporting and operations meet requirements.

You will lead data modeling, ETL processes, performance optimization, and collaboration with state IT, business analysts, and SMEs.