Apply on Employer Site

Alpha FMC · 2 hours ago

Sr. Data Engineer - SQL Migrations

NYC Metro Area

Full-time

Hybrid

Senior Level

6+ years exp

Alpha FMC is seeking a Senior Data Engineer to lead enterprise-scale SQL Server migrations to Azure SQL/Fabric Lakehouse. The role involves designing migration strategies, optimizing ETL processes, and developing data pipelines to support modern analytics and applications.

Asset ManagementFinancial ServicesManagement ConsultingWealth Management

Comp. & Benefits

No H1B

U.S. Citizen Only

Responsibilities

Architect and lead enterprise-scale SQL Server 2012 to Azure SQL/Fabric Lakehouse migration initiatives, serving as technical lead for complex transformation projects

Design comprehensive migration strategies including phased approaches, cutover plans, rollback procedures, and zero-downtime deployment patterns

Own the design and optimization of complex ETL/ELT processes that transform legacy relational schemas into modern lakehouse data models (medallion architecture, etc.)

Architect and develop Lakehouse-native data pipelines using Azure Data Factory, Databricks, and Microsoft Fabric to support API-first data consumption patterns

Design and own APIs and composable data services built on Fabric Lakehouse that enable modern analytics and operational applications

Architect data governance frameworks, data quality systems, and metadata management practices for migrated and modernized data environments

Lead technical assessments of legacy SQL Server 2012 environments; identify optimization, refactoring, and modernization opportunities

Qualification

SQL Server 2012Azure Data FactoryLakehouse architectureETL/ELT processesAPI developmentData governancePythonData Engineering experienceAzure Cloud CertificationsT-SQL optimization

Required

Bachelor's Degree in Computer Science or related field; Azure Cloud Certifications strongly preferred

At least 6 years of Data Engineering experience, with 2+ years specifically architecting and leading SQL Server migrations to cloud platforms

Deep expertise in SQL Server 2012 architecture, performance tuning, schema design, and complex migration scenarios (dependency analysis, ETL refactoring, compatibility resolution)

Proven experience architecting Lakehouse solutions and migrating normalized SQL schemas into lakehouse data models

Strong proficiency in Azure Data Factory, Synapse Analytics, Azure SQL, Data Lake Storage, and Microsoft Fabric (Lakehouse, Warehouses, Pipelines)

Demonstrated expertise designing and building APIs/data services on top of Lakehouse/Delta Lake, including real-time and batch patterns

Advanced SQL and T-SQL optimization skills; proficiency in Python for data transformation and automation