Lead Data Engineer

Own and execute end-to-end legacy-to-cloud data migration strategies including extraction, transformation, load, reconciliation, and cutover planning for large historical datasets.

Profile and reverse-engineer undocumented legacy SQL Server databases and develop source-to-target mappings to build operational and reporting databases on Azure SQL.

Lead and mentor data migration engineers, set coding/testing standards, optimize load and query performance, and report migration progress and risks to client stakeholders.

8-12 years of data engineering experience, with at least two full lifecycle legacy-to-cloud migration projects as the lead.

Expert-level T-SQL skills including complex views, stored procedures, CTEs, window functions, indexing, and query plan optimization.

Hands-on experience with SQL Server and Azure SQL Database (serverless or elastic tiers), Azure Data Factory and/or SSIS, along with scripting in Python or PowerShell.

Experience with data reconciliation/validation automation, data modeling for OLTP and reporting, cutover planning, and use of Git/CI-CD pipelines (GitHub Actions or Azure DevOps).

Experienced leader comfortable engaging directly with US client stakeholders and collaborating with architects, analysts, and SMEs to resolve data/business rules.

Proficient in handling large-scale, complex data migrations requiring in-depth legacy system analysis, performance tuning, and automated validation workflows.

Familiar with cloud-native Azure tools, infrastructure as code, and modern development practices supporting scalable, repeatable data migration processes.