Full-time jobs in Madison, WI

About the role

Baker Tilly Advisory Group, LP and Baker Tilly US, LLP, trading as Baker Tilly, are independent members of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 141 territories, with 43,000 professionals and a combined worldwide revenue of $5.2 billion. Visit bakertilly.com or join the conversation on LinkedIn, Facebook and Instagram. Please discuss the work location status with your Baker Tilly talent acquisition professional to understand the requirements for an opportunity you are exploring. Baker Tilly is an equal opportunity/affirmative action employer. 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 any other legally protected basis, in accordance with applicable federal, state or local law. Any unsolicited resumes submitted through our website or to Baker Tilly Advisory Group, LP, employee e-mail accounts are considered property of Baker Tilly Advisory Group, LP, and are not subject to payment of agency fees. In order to be an authorized recruitment agency ("search firm") for Baker Tilly Advisory Group, LP, there must be a formal written agreement in place and the agency must be invited, by Baker Tilly's Talent Attraction team, to submit candidates for review via our applicant tracking system. As a Senior Consultant – Associate Data Engineer you will design, build, and optimize modern data solutions for our mid‑market and enterprise clients. Working primarily inside the Microsoft stack (Azure, Synapse, and Microsoft Fabric), you will transform raw data into trusted, analytics‑ready assets that power dashboards, advanced analytics, and AI use cases. You’ll collaborate with solution architects, analysts, and client stakeholders while sharpening both your technical depth and consulting skills.

What you'll bring

• Education – Bachelor’s in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)
• Experience – 2–3 years delivering production data solutions
• 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).
• Actual compensation is influenced by a variety of relevant factors including but not limited to applicant’s skills, prior experience, qualifications, degrees, professional certifications, work arrangements and geographic location.
• Baker Tilly offers a comprehensive compensation and benefits package to eligible employees.
• 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
• preferably in a consulting or client ‑ facing role.

Locations