DataJobs.io
← Back to all jobs

This position is no longer accepting applications

Closed on July 3, 2026.

This role is filled — get an email when new Data Processing roles open on DataJobs.io:

Baker Tilly Advisory Group, LP

Associate Data Engineer

Baker Tilly Advisory Group, LP
Milwaukee, WI $86k - $163k/yr Full time Posted 1mo ago
Analytics Automation Azure Data Factory Azure DevOps Azure Synapse Analytics Business Analytics Business Intelligence Cloud Data Data Analysis Data Engineer Data Governance Data Integration Data Lake Data Pipeline Data Platform Data Processing Data Warehouse Databricks DevOps ETL Integration Microsoft Azure Microsoft Fabric Power BI Yaml Pipelines
View similar jobs

Get alerted when similar jobs are posted — set up a New Data Processing jobs on DataJobs.io alert.

See other roles at Baker Tilly Advisory Group, LP.

Job Description

The Associate Data Engineer collaborates with cross-functional teams to design, build, and optimize data platforms for mid-market and enterprise clients. Focusing on the Microsoft stack, the role leverages Azure, Synapse, and Microsoft Fabric to convert raw data into analytics-ready assets for dashboards, advanced analytics, and AI use cases.

Location

Milwaukee, WI (onsite)

Compensation

USD 85,910 - 162,890 per year

Responsibilities

  • Data engineering: Build scalable ETL/ELT pipelines using T-SQL, Python, Azure Data Factory or Fabric Data Pipelines, and Databricks; apply best practice patterns for performance, security, and cost control.
  • Modeling and storage: Design relational and lakehouse models; implement Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
  • Quality and governance: Create automated data quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
  • Client delivery: Gather requirements, demonstrate iterative deliverables, document technical designs, and translate complex concepts for non-technical audiences.
  • Continuous improvement: Explore new capabilities, share findings in internal communities of practice, and contribute to reusable accelerators. Collaborate with clients and internal stakeholders to design scalable data engineering solutions.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Engineering, or 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 with at least one Microsoft service (Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines).
  • Project experience with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake) preferred.
  • Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies preferred.
  • Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks preferred.
  • Experience integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint) preferred.

Technologies

  • T-SQL
  • Python
  • Azure Data Factory
  • Fabric Data Pipelines
  • Databricks
  • Fabric OneLake
  • Power BI
  • Azure DevOps
  • GitHub
  • Microsoft Fabric
  • Azure Synapse
  • Azure
  • Notebooks
  • Delta Lake
  • Dynamics 365
  • Workday
  • Costpoint
  • Terraform
  • Bicep
  • YAML pipelines
  • Power BI DirectLake

Similar Jobs