Associate Data Engineer

Baker Tilly Advisory Group, LP; Milwaukee (WI); On-site; USD 86,000 - 163,000; Full time

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

In this onsite role in Milwaukee, you will design, build, and optimize modern data solutions for mid-market and enterprise clients, with a primary focus on the Microsoft data stack. The work involves turning raw data into analytics-ready assets that support dashboards, advanced analytics, and AI use cases in a consulting and client-facing environment.

Responsibilities

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

Requirements

• Bachelor's in Computer Science, Information Systems, Engineering, or a related field (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.
• Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks is preferred.
• Experience integrating SaaS/ERP sources (examples include Dynamics 365, Workday, and Costpoint) is preferred.

Technology Focus

Work will center on T-SQL and Python alongside Microsoft data services such as Azure Data Factory, Azure Synapse, and Microsoft Fabric. You will also work with Fabric OneLake, Lakehouse concepts, Power BI modeling, Azure DevOps or GitHub for CI/CD, and relevant lakehouse tooling including Databricks and Delta Lake. Preferred/related areas include Terraform, Bicep, YAML pipelines, test automation frameworks, and integrations with platforms such as Dynamics 365, Workday, and Costpoint, including Power BI DirectLake and Fabric Warehouse.

Location and Compensation

This position is onsite in Milwaukee, WI. Compensation is USD 85,910 - 162,890 per year.

Minimum Experience

Minimum experience is 2 years.