Senior Data Engineer - Azure, Synapse & Power BI

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

Job summary

Baker Tilly Advisory Group, LP in Milwaukee seeks a Senior Consultant - Associate Data Engineer to design, build, and optimize modern data solutions for mid-market and enterprise clients. You will transform raw data into analytics-ready assets using Azure, Synapse, Fabric, and Power BI to power dashboards and AI use cases.

Work with solution architects, analysts, and client stakeholders to develop scalable ETL/ELT pipelines, relational and lakehouse models, and automated data quality and

Qualifications

• Education: Bachelor's in Computer Science, Information Systems, Engineering, or related field (or equivalent).
• Experience: 2-3 years delivering production data solutions, preferably in consulting or client-facing roles.
• Technical skills: strong T-SQL, Python, and hands-on ETL/ELT with Microsoft services (ADF, Synapse, Fabric).
• Familiarity with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake) is preferred.

Responsibilities

• Data Engineering: Develop scalable ETL/ELT pipelines using T-SQL, Python, ADF/Fabric Pipelines, and Databricks.
• Modeling & Storage: Design relational and lakehouse models and Power BI-ready data structures.
• Quality & Governance: Build automated data quality checks, lineage, and observability metrics.
• Client Delivery: Gather requirements, demo deliverables, and translate complex concepts to non-technical stakeholders.
• Continuous Improvement: Research new capabilities and contribute to reusable accelerators.

Skills

T-SQL

Python

ETL/ELT

Databricks

Power BI

Education

Bachelor's in Computer Science or related field

Tools

Azure Data Factory

Synapse

Fabric Data Pipelines

Fabric OneLake

Job description

Baker Tilly Advisory Group, LP in Milwaukee seeks a Senior Consultant - Associate Data Engineer to design, build, and optimize modern data solutions for mid-market and enterprise clients. You will transform raw data into analytics-ready assets using Azure, Synapse, Fabric, and Power BI to power dashboards and AI use cases.

Work with solution architects, analysts, and client stakeholders to develop scalable ETL/ELT pipelines, relational and lakehouse models, and automated data quality and