Onsite Data Engineer – Microsoft Data Stack & Lakehouse

Baker Tilly Advisory Group, LP

Milwaukee (WI)

On-site

USD 86,000 - 163,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Baker Tilly Advisory Group, LP is seeking an onsite Data Engineer in Milwaukee to design, build, and optimize data solutions centered on the Microsoft data stack. You will transform raw data into analytics-ready assets supporting dashboards, advanced analytics, and AI use cases in a client-facing environment.

The role emphasizes T-SQL, Python, and Azure services, along with collaboration across client teams to deliver scalable data engineering solutions.

Qualifications

  • Bachelor's degree or equivalent experience.
  • 2-3 years delivering production data solutions, preferably in a consulting or client-facing role.
  • Strong T-SQL for data transformation and performance tuning.
  • Python for data wrangling, orchestration, or notebook-based development.
  • Hands-on ETL/ELT using at least one Microsoft service (ADF, Synapse Pipelines, or Fabric Data Pipelines).
  • Project experience with Microsoft Fabric including OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, and Power BI DirectLake is preferred.
  • Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies is preferred.

Responsibilities

  • Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks.
  • Design relational and lakehouse models with Fabric OneLake shortcuts, medallion-style layers, and Power BI DirectLake.
  • Build automated data-quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
  • Gather requirements, demo deliverables, document technical designs, and translate complex concepts for non-technical audiences.
  • Research new capabilities, share findings, and collaborate with clients and internal stakeholders to deliver scalable data engineering solutions.

Skills

T-SQL
Python
Azure Data Factory
Fabric Data Pipelines
Databricks
Power BI
CI/CD
GitHub
Azure DevOps
Lakehouse concepts

Education

Bachelor's degree in CS/IS/Engineering or related field

Tools

Azure Data Factory
Azure Synapse
Fabric Data Pipelines
Databricks
Terraform/Bicep
YAML pipelines

Job description

Baker Tilly Advisory Group, LP is seeking an onsite Data Engineer in Milwaukee to design, build, and optimize data solutions centered on the Microsoft data stack. You will transform raw data into analytics-ready assets supporting dashboards, advanced analytics, and AI use cases in a client-facing environment.

The role emphasizes T-SQL, Python, and Azure services, along with collaboration across client teams to deliver scalable data engineering solutions.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Data Engineer
Associate Data Engineer

Baker Tilly Advisory Group, LP • Milwaukee (WI)

On-site
USD 86,000 - 163,000
Associate Data Engineer — Azure Data, AI & Cloud
Associate Data Engineer — Azure Data, AI & Cloud

Baker Tilly International • Madison (WI)

On-site
USD 86,000 - 163,000
Associate Data Engineer: Azure Data & AI Pipelines
Associate Data Engineer: Azure Data & AI Pipelines

Baker Tilly Advisory Group • Madison (WI)

On-site
USD 86,000 - 163,000
Databricks Admin & Data Engineer Lead
Databricks Admin & Data Engineer Lead

Accenture PLC • Milwaukee (WI)

On-site
USD 70,000 - 84,000
Medical, dental, vision
401(k) plan
Paid time off
Associate Data Engineer
Associate Data Engineer

Baker Tilly International • Madison (WI)

On-site
USD 86,000 - 163,000
Associate Data Engineer
Associate Data Engineer

Baker Tilly Advisory Group • Madison (WI)

On-site
USD 86,000 - 163,000
Data & Analytics Engineer — Cloud, AI & Lakehouse
Data & Analytics Engineer — Cloud, AI & Lakehouse

eNGINE • Pennsylvania

On-site
USD 90,000 - 140,000
Senior Data Engineer - Azure & Fabric
Senior Data Engineer - Azure & Fabric

Baker Tilly • Chicago (IL)

On-site
USD 86,000 - 163,000
Onsite Data Engineer - US (H-1B Sponsor)
Onsite Data Engineer - US (H-1B Sponsor)

Microsoft Corp. • United States

On-site
USD 121,000 - 163,000
Senior Data Engineer – Lakehouse & AI Platform
Senior Data Engineer – Lakehouse & AI Platform

Baker Tilly (US) • California

On-site
USD 185,000 - 230,000