Senior Data Engineer: Azure Analytics & AI

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

Job summary

Baker Tilly Advisory Group, LP in Madison, WI, is seeking a Senior Consultant - Associate Data Engineer to design, build, and optimize modern data solutions for mid-market and enterprise clients.

You'll work primarily in the Microsoft stack (Azure, Synapse, Fabric), transforming raw data into analytics-ready assets for dashboards, AI use cases, and advanced analytics, while collaborating with architects, analysts, and client stakeholders.

Qualifications

• Bachelor's degree in CS, IS, engineering, or related field.
• 2-3 years delivering production data solutions in a consulting setting.
• Strong hands-on experience with Microsoft data services (ADF, Synapse, Fabric).

Responsibilities

• Develop scalable ETL/ELT pipelines with T-SQL and Python.
• Design relational and lakehouse models for Power BI.
• Implement quality checks, lineage, and observability.
• Collaborate with solution architects and clients to deliver data solutions.
• Contribute to reusable accelerators and CI/CD practices.

Skills

T-SQL

Python

ETL/ELT

Azure Data Factory

Databricks

Fabric Data Pipelines

Education

Bachelor's in Computer Science or related field

Tools

Databricks

Delta Lake

Fabric OneLake

Power BI

Job description

Baker Tilly Advisory Group, LP in Madison, WI, is seeking a Senior Consultant - Associate Data Engineer to design, build, and optimize modern data solutions for mid-market and enterprise clients.

You'll work primarily in the Microsoft stack (Azure, Synapse, Fabric), transforming raw data into analytics-ready assets for dashboards, AI use cases, and advanced analytics, while collaborating with architects, analysts, and client stakeholders.