Job Summary:
Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage. The Associate Data Engineer will design, build, and optimize modern data solutions, transforming raw data into analytics-ready assets and collaborating with various stakeholders.
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. Collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions.
Qualifications:
Required:
• 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).
Preferred:
• Project experience with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake)
• Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies
• Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks
• Experience integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint)
Company:
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. Founded in 1931, the company is headquartered in Chicago, IL, US, , with a team of 10001+ employees. The company is currently Late Stage.