Lead Data Engineer
Core
Lead a BI/DWH modernization initiative by analyzing legacy Microsoft data flows and designing migration to a modern cloud data platform.
Role type
Senior Lead Data Engineer (BI/DWH Modernization)
Builds
Modernized cloud-based data platforms replacing legacy SQL Server/SSIS environments
Domain
Data Engineering / Business Intelligence / Cloud Data Platforms
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL Server & T-SQL, SSIS, ETL flow analysis, Cloud data platform migration, Data modeling (Kimball, Data Vault, star schema), CI/CD, Git, Technical documentation, Team leadership
Preferred skills
dbt, SSAS, SSRS, Power BI, Purview, Unity Catalog, DataHub
Technologies
SQL Server, SSIS, Microsoft Fabric, Azure Synapse, Databricks, Snowflake
Responsibilities
Analyze legacy SQL Server and SSIS-based data warehouse flows and dependencies; Define modernization strategies for cloud-based data platforms; Collaborate with architects and business experts to align technical design with business needs; Document technical solutions, data flows, and design decisions; Support and guide junior data engineers in daily work and technical decisions.
Seniority
Senior, hands-on IC with leadership responsibilities
