Job Description
Data Migration Lead Data Warehouse & Reporting
Experience: - 12+ Years
Location: - Remote
What is in it for you?
We're looking for a Data Migration Lead with deep, hands-on experience in the data warehousing world to own end-to-end data migration efforts across our DW and Reporting ecosystem. The ideal candidate has spent significant years as a tech lead, managed complete SDLC cycles, and can independently run the show with a data-driven approach - while communicating clearly with both technical teams and business 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 proof-of-concepts (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
Educational Qualifications: -
Technical certification in multiple technologies is desirable.
Skills: -
Mandatory skills
Strong, well-rounded understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas, ETL/ELT design)
Significant years of experience working in data warehousing, including time spent in a tech lead role
Proven track record managing end-to-end SDLC for DW/reporting projects
Hands-on experience in ETL development and reporting
Strong familiarity with data migration projects and methodologies
Strong hands-on SQL skills (complex queries, performance tuning, data validation)
Experience building POCs for report and log analysis
Strong analytical thinking and problem-solving ability
Self-starter who can run projects independently with a data-driven mindset
Excellent stakeholder communication skills - able to translate technical details for non-technical audiences and manage expectations across teams
Good to have skills: -
Experience with cloud data platforms (Snowflake, Redshift, BigQuery, Azure Synapse, etc.)
Prior experience leading migration projects in a lead/ownership capacity.
Familiarity with BI/reporting tools (Power BI, Tableau, etc.)
...every step of the way enabling you to shape your future with confidence. Ernst & Young Capital Advisors, LLC (EYCA) offers investment banking services with access to a global network of EY mergers & acquisitions, debt capitalmarketsand equity capital markets...
...this role. The typical candidate is hired below midpoint of the range. Do you have the career opportunities as a(an) Medical Laboratory Scientist or Technician you want with your current employer? We have an exciting opportunity for you to join HCA HealthONE Swedish...
...responsible forthe following: Other duties may be assigned.# Plan pipe system layout, installation, or repair according to... ...radiators, exchangers,or tanks, using brackets, clamps,tools,or welding equipment.# Assemble and secure pipes, tubes, fittings, and...
...Position Overview We are seeking a reliable, professional Armed Security Officer to support safety and security operations within an... ...committed to providing high level security and exceptional customer service. This role involves performing duties that include access...
...Behavioral Sciences Department. A full load consists of 15 contact hours, and 10 office hours. Expectations for this position include teaching Psychology courses during daytime or evening hours on the Kilgore or Longview campus, teaching at off-campus dual credit sites, and/or...