> Markdown version of [/jobs/ext/2998889-data-migration-lead-data-warehouse-reporting](https://www.wearedevelopers.com/jobs/ext/2998889-data-migration-lead-data-warehouse-reporting). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Migration Lead Data Warehouse & Reporting

- **Company:** PEOPLES & PEOPLES CONSULTING, LLC
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** BigQuery, Data Validation, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Mining, Data Warehousing, Database Queries, Dimensional Modeling, Log Analysis, Performance Tuning, Systems Development Life Cycle, Power BI, Cloud Services, Migration Manager, Standard Sql, Tableau (Software), Freeform SQL, Snowflake, Tools for Reporting, Azure Synapse Analytics, Amazon Redshift
- **Published:** September 19, 2026
- **Apply:** https://www.dice.com/job-detail/b22f85a2-31a8-4956-9d2c-31b0ea4ecd83

## About the Role

* Engineering Degree BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

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.).

## Description

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


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)