Associate Data Engineer

An Associate Data Engineer role at Baker Tilly Advisory Group, LP is based onsite in Milwaukee, WI, focusing on designing, building, and optimizing data solutions for mid-market and enterprise clients. You will work with Azure, Synapse, and Microsoft Fabric to transform raw data into analytics-ready assets that power dashboards, advanced analytics, and AI use cases. The position offers a competitive salary range of USD 85,910 to 162,890 per year and opportunities to collaborate with solution architects, analysts, and client stakeholders.

Responsibilities

• Develop scalable, well-documented 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.
• Design relational and lakehouse models; implement Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
• Build automated data-quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
• Gather requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non-technical audiences.
• Research new capabilities, share findings in internal communities of practice, and contribute to reusable accelerators; collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions.

Requirements

• Bachelor's degree 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 with at least one Microsoft service (ADF, Synapse Pipelines, 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