Lead Data Engineer (ADF+SQL)

New Albany, OH - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

We are currently seeking a SQL ADF developer to join our team in Columbus OH.

Job Duties

Design develop and maintain robust ETL pipelines using Azure Data Factory (ADF) for data integration.
Write and optimize complex SQL queries for data extraction transformation and loading across large datasets.
Implement data workflows and orchestrations in ADF ensuring scalability and reliability.
Collaborate with data architects and analysts to deliver high-quality data solutions aligned with business needs.
Monitor and troubleshoot ADF pipelines resolving failures and optimizing performance.
Ensure data security compliance and governance standards are met within the Azure environment.
Perform performance tuning for SQL queries and ADF activities to meet SLA requirements.
Document ETL processes pipeline configurations and data flow diagrams for transparency and maintainability.
Continuously explore and implement best practices for Azure-based data engineering solutions.

Mandatory Skills

Strong proficiency in SQL including advanced query optimization and stored procedures.
Hands-on experience with Azure Data Factory (ADF) for building and managing data pipelines.
Exposure to Azure ecosystem components such as Data Lake Synapse and related services.
Solid understanding of ETL concepts and data integration best practices.
Ability to troubleshoot and optimize ADF workflows for performance and reliability.
Familiarity with version control systems (Git) and CI/CD pipelines for data solutions.
Knowledge of data governance security and compliance within cloud environments.
Strong analytical and problem-solving skills with attention to detail.
Experience with Microsoft Fabric (Lakehouse OneLake) is a strong plus.

Required Experience:

We are currently seeking a SQL ADF developer to join our team in Columbus OH.Job DutiesDesign develop and maintain robust ETL pipelines using Azure Data Factory (ADF) for data integration.Write and optimize complex SQL queries for data extraction transformation and loading across large datasets.Imp...