Hello,
Job Title: Lead Data Engineer with SQL and ADF Exp*
Location: Columbus, OH (Onsite)
Duration: 12+ months
Visa Status: GC, USC, H4-EAD, L2-EAD and H1B Transfer
We are currently seeking a Lead Data Engineer with SQL and ADF development experience to join our team in Columbus, OH.
Lead Experience Must
12+ years of experience required.
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.
—
