Associate Data Engineer
Baker Tilly•Madison, WI
•$85,910 - $162,890
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, and client stakeholders while developing your technical expertise and consulting skills.
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, such as Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.
Nice To Haves
- Experience delivering production data solutions 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.
Benefits
- Comprehensive compensation and benefits package for eligible employees.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
