Associate Data Engineer

Baker Tilly•Madison, WI

15h

About The Position

As a Senior Consultant – Associate Data Engineer, you will design, build, and optimize modern data solutions for mid-market and enterprise clients. Working primarily within the Microsoft stack—including Azure, Synapse, and Microsoft Fabric—you will transform raw data into trusted, analytics-ready assets that support dashboards, advanced analytics, and AI use cases. You will collaborate with solution architects, analysts, clients, and internal stakeholders while developing technical and consulting skills. The role also involves contributing to scalable data engineering solutions, reusable accelerators, and continuous improvement.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience.
2–3 years delivering production data solutions.
Strong T-SQL skills for data transformation and performance tuning.
Python skills for data wrangling, orchestration, or notebook-based development.
Hands-on ETL/ELT experience with at least one Microsoft service: Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.

Nice To Haves

Production data solution experience in a consulting or client-facing role.
Project experience with Microsoft Fabric, including OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, or Power BI DirectLake.
Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies.
Exposure to DevOps, including YAML pipelines and Terraform/Bicep, and test automation frameworks.
Experience integrating SaaS/ERP sources such as Dynamics 365, Workday, or Costpoint.

Responsibilities

Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks; implement best-practice patterns for performance, security, and cost control.
Design relational and lakehouse models; create 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, demonstrate iterative deliverables, document technical designs, and explain 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.