Data Migration Lead: End-to-End DW & Reporting Architect

TalentOla; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

TalentOla is seeking a Data Migration Lead with hands-on data warehousing expertise to own end-to-end migration efforts across our DW and Reporting ecosystem. You will drive design, development, and testing, and mentor junior engineers while coordinating with BI and business stakeholders.

The ideal candidate has years in a tech lead role, a data-driven mindset, and proven SDLC management for DW/reporting projects, ETL/ELT development, SQL optimization, and rigorous data validation.

Qualifications

• Strong understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas)
• Extensive experience as a tech lead in data warehousing projects
• Proven track record managing end-to-end SDLC for DW/reporting
• Hands-on ETL development and reporting experience
• Strong SQL skills, performance tuning, data validation
• Ability to communicate complex technical details to non-technical stakeholders

Responsibilities

• Lead data migration initiatives across DW and reporting platforms, owning design, development, and testing phases end-to-end
• Manage the complete SDLC for migration projects — requirements, planning, execution, testing, and delivery
• Write and optimize complex SQL queries for data extraction, transformation, validation, and reconciliation
• Build POCs for report analysis and log analysis to validate migration approaches and troubleshoot issues
• Define migration strategy, data mapping, and validation frameworks to ensure data accuracy and integrity
• Drive data-driven decision-making across the project lifecycle
• Identify risks and data quality issues early, and drive resolution independently
• Create and maintain documentation: migration plans, test cases, mapping sheets, and runbooks
• Mentor junior team members and guide the team as a technical lead
• Partner with business stakeholders, BI teams, and engineering to gather requirements and communicate migration progress, risks, and timelines

Skills

Data warehousing

ETL/ELT design

SQL development

SDLC management

Technical leadership

Stakeholder communication

Problem solving

Job description

TalentOla is seeking a Data Migration Lead with hands-on data warehousing expertise to own end-to-end migration efforts across our DW and Reporting ecosystem. You will drive design, development, and testing, and mentor junior engineers while coordinating with BI and business stakeholders.

The ideal candidate has years in a tech lead role, a data-driven mindset, and proven SDLC management for DW/reporting projects, ETL/ELT development, SQL optimization, and rigorous data validation.