Data Engineer II — Azure Data Factory & Lakehouse

CDW

United States

Remote

USD 86,000 - 119,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

CDW is seeking a Software Engineer II, Data to design and support enterprise data ingestion, transformation, modeling, and integration solutions. You will translate business requirements into scalable data pipelines and models to enable analytics, reporting, and downstream applications.

The role focuses on building ingestion/transformation solutions with Microsoft Fabric and ADF, working with Azure services, and ensuring data quality across complex data architectures.

Qualifications

  • Bachelor's degree in CS/IS/Engineering or equivalent with 3 years IT experience, or 7 total IT years.
  • Experience building enterprise data pipelines, data warehouses, Lakehouse, or analytics platforms.
  • Strong SQL and relational DB development; ability to troubleshoot data issues.
  • Excellent analytical, problem-solving, and cross-functional communication.
  • Experience with Agile, DevOps, CI/CD, and Git/GitHub.
  • Experience with Microsoft Fabric, ADF, Azure Data Lake/Storage, Azure SQL/SQL Server.
  • Knowledge of data warehousing, dimensional modeling, data ingestion patterns, validation.
  • Familiarity with Python and/or PySpark; Delta Lake/Lakehouse concepts is a plus.
  • REST APIs/JSON-based integrations; event-driven patterns and Azure Service Bus are a plus.
  • Data migration and legacy modernization, Azure Key Vault security, enterprise data governance is a plus.

Responsibilities

  • Build ingestion and transformation solutions using Microsoft Fabric and ADF.
  • Implement pipelines for batch, incremental, API, file, DB, and event-based integration.
  • Develop reusable ingestion/transformation patterns and curated data structures.
  • Work with SQL, CSV, JSON, Parquet and other formats; verify data quality.
  • Model data: conceptual, logical, physical; dimensional/curated models.
  • Develop complex SQL queries, views, transformations, and data-processing logic.
  • Troubleshoot queries, pipelines, data-processing issues; tune performance.
  • Perform data quality, reconciliation, and source-to-target checks.
  • Use GitHub for source control; follow EDAS CI/CD and code-review standards.
  • Utilize Azure DevOps/ADO for delivery; maintain documentation and patterns.
  • Monitor production pipelines; resolve failures and long-running jobs.
  • Collaborate in peer code/design reviews; improve reusable patterns.

Skills

SQL & relational DB
Analytical skills
Cross-functional collaboration
Agile / DevOps
Python / PySpark
ETL/ELT patterns
Dimensional/Data modeling
Data quality & validation
Git / GitHub
Azure Data Platform

Education

Bachelor's degree in CS/IS/Engineering

Tools

Azure Data Factory
Azure Data Lake/Storage
Azure SQL/SQL Server
Microsoft Fabric
Azure DevOps
GitHub

Job description

CDW is seeking a Software Engineer II, Data to design and support enterprise data ingestion, transformation, modeling, and integration solutions. You will translate business requirements into scalable data pipelines and models to enable analytics, reporting, and downstream applications.

The role focuses on building ingestion/transformation solutions with Microsoft Fabric and ADF, working with Azure services, and ensuring data quality across complex data architectures.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer II - Azure Data Pipelines & Analytics
Senior Data Engineer II - Azure Data Pipelines & Analytics

CDW • Illinois City (IL)

On-site
USD 120,000 - 170,000
Data Engineer: Lakehouse & CDP on Azure Fabric
Data Engineer: Lakehouse & CDP on Azure Fabric

Tata Consultancy Services Limited • San Jose (CA)

Hybrid
USD 80,000 - 115,000
Discretionary Annual Incentive
Comprehensive Medical Coverage (Dental
Vision
+4
Data Engineer - Azure Data Platform & Pipelines
Data Engineer - Azure Data Platform & Pipelines

DLA Piper LLP • Short Hills (NJ)

Hybrid
USD 101,000 - 160,000
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data

CDW • Chicago (IL)

On-site
USD 120,000 - 160,000
Azure Data Engineer — Fabric & Lakehouse Architect
Azure Data Engineer — Fabric & Lakehouse Architect

Trinity Health Group • Los Angeles (CA)

Hybrid
USD 120,000 - 170,000
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data

CDW • Illinois City (IL)

On-site
USD 120,000 - 170,000
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data
https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data

CDW • Northbrook (IL)

On-site
USD 120,000 - 160,000
Senior Data Engineer: Azure Data Factory & Data Platform
Senior Data Engineer: Azure Data Factory & Data Platform

Joint Commission • Kentucky

On-site
USD 107,000 - 143,000
Comprehensive benefits package
Azure Data Engineer
Azure Data Engineer

9nexus • United States

Remote
USD 110,000 - 160,000
Senior Data Engineer — Azure Fabric, Delta Lake & Pipelines
Senior Data Engineer — Azure Fabric, Delta Lake & Pipelines

Datavail Infotech • United States

On-site
USD 130,000 - 170,000