SQL Migration Data Engineer at Auxo Solutions focusing on Azure SQL/Fabric Lakehouse migrations and building data pipelines. Collaborating on technical designs and data governance for modernization initiatives.
Responsibilities
Collaborate with the delivery team on a Server 2012 to Azure SQL/Fabric Lakehouse migration, including assessment, planning, and execution.
Develop and optimize ETL/ELT processes to migrate legacy SQL 2012 databases to modern cloud data platforms, minimizing data loss and downtime.
Design and build data pipelines using Azure Data Factory, Databricks, and Microsoft Fabric Lakehouse to transform monolithic databases into distributed Lakehouse architectures.
Develop APIs and data services on top of Microsoft Fabric Lakehouse to expose migrated data for downstream applications and stakeholders.
Collaborate with infrastructure and application teams to assess legacy SQL 2012 environments, identify technical debt, and plan phased migration approaches.
Develop infrastructure and automation required for optimal extraction, transformation, and loading of data from SQL Server 2012 and other legacy sources using SQL, dbt, Python, and Fabric technologies.
Define and document cloud solution architectures, migration roadmaps, and technical designs for data modernization initiatives.
Generate and document unit tests, performance benchmarks, and migration validation scripts.
Establish data quality frameworks and governance practices for migrated data assets in Lakehouse environments.
Requirements
Bachelor's Degree in Computer Science or related field.
Azure Cloud Certifications strongly preferred.
At least 3 years of Data Engineering experience, with 1+ years specifically in SQL Server migrations to cloud platforms.
Hands-on experience with SQL Server 2012 architecture, T-SQL optimization, and migration patterns (compatibility issues, index strategies, etc.).
Proficiency in Azure Data Factory, Synapse Analytics, Azure SQL, Data Lake Storage, and Microsoft Fabric (especially Lakehouse), including data modeling, partitioning, and optimization for analytical workloads.
Demonstrated experience building APIs or data services on top of Lakehouse/Delta Lake architectures.
Proficiency with dbt for transformation logic and data lineage documentation.
Strong command of Python, SQL, T-SQL, and scripting for automation and data validation.
Experience with Azure Infrastructure-as-Code (Bicep, ARM templates, Terraform).
Experience building CI/CD pipelines for data infrastructure.
Knowledge of data governance, metadata management, and data quality frameworks.
Ability to work independently in Agile environments with minimal supervision on external client projects.
Benefits
Medical, Dental, and Vision Insurance.
Life, Short Term Disability, and Long Term Disability Insurance.
AWS Data Engineer designing and maintaining scalable cloud - based data platforms within Banking and Financial Services at EXL. Collaborating across teams to enable data - driven decision - making through cloud technologies.
Senior Data Engineer designing and scaling advanced data platforms for 5G and future 6G innovations at Nokia. Building robust data pipelines while collaborating with Data Scientists and Engineers in a hybrid setting.
Senior Data Engineering Consultant at Gradion transforming data infrastructure for global clients. Modernizing legacy systems and operationalizing AI/ML solutions with cloud and AI consultants.
EU Commercial Data Engineer developing scalable data solutions for Genmab’s commercial teams. Collaborating with cross - functional teams to enhance business insights and decision making through reliable data.
Principal Data Engineer designing and developing innovative data analytical solutions for the gaming industry. Leading and mentoring while engaging with clients to fulfill their data engineering needs.
Specialist, Data Engineering at CoverMyMeds enhancing and expanding data platforms for commercial data products. Collaborating with multiple teams to design scalable data solutions from various sources.
Team Lead in Data Engineering at Avanquest mentoring data engineering team and ensuring efficient data management across platforms. Collaborating with departments to align solutions and optimize workflows.
Data Architect at RSM leading AI - driven data migration initiatives within Salesforce ecosystem. Implementing data governance and optimizing performance across complex datasets.
Senior Data Engineer at Capgemini designing and optimizing scalable data architectures on Databricks and GCP. Collaborating across teams to transform business needs into reliable technical solutions.