Lead Data Engineer
Core
Lead the early-phase modernization of a legacy Microsoft data warehouse and BI environment to a modern cloud-based data platform.
Role type
Lead Data Engineer (Data Warehouse Modernization)
Builds
Modernized cloud data platforms (Microsoft Fabric, Azure Synapse, Databricks, Snowflake) replacing legacy SQL Server/SSIS systems
Domain
Data Engineering / Cloud Data Platforms
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL Server, T-SQL, SSIS, ETL flow analysis, data modeling (Kimball, Data Vault, star schema), cloud platform migration, CI/CD, Git, technical documentation, team leadership
Preferred skills
dbt, SSAS, SSRS, Power BI, Purview, Unity Catalog, DataHub, domain experience (retail, supply chain, finance, HR)
Technologies
Microsoft Fabric, Azure Synapse, Databricks, Snowflake, SQL Server, SSIS, Git, CI/CD
Responsibilities
Analyze legacy SQL Server and SSIS-based data warehouse flows; contribute to discovery and analysis work; help modernize existing data flows toward cloud platforms; work with data modeling; document technical solutions and design decisions; collaborate with architects and business experts; support and guide junior data engineers
Seniority
Senior, hands-on IC with leadership responsibilities