Logo
Baker Tilly US

Associate Data Engineer

Baker Tilly US, Milwaukee, Wisconsin, United States, 53244

Save Job

Join to apply for the

Associate Data Engineer

role at

Baker Tilly US

Get AI-powered advice on this job and more exclusive features.

Overview Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U.S. and in many of the world’s leading financial centers – New York, London, San Francisco, Los Angeles, Chicago and Boston.

For more information, visit

bakertilly.com

or join the conversation on LinkedIn, Facebook and Instagram.

Equal Opportunity

– All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, gender identity, sexual orientation or other legally protected basis.

Job Description Associate Data Engineer

Key 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, 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.

Qualifications

Education – Bachelor’s in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)

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.

Seniority level Mid‑Senior level

Employment type Full‑time

Job function Information Technology

Industries Accounting

#J-18808-Ljbffr