Associate Data Engineer

Baker Tilly Advisory Group, LP

Where
Madison, WI
Pay
$86K to $163K a year

Posted 9 days ago· Checked live at Baker Tilly Advisory Group, LP 3 days ago

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what Baker Tilly Advisory Group, LP asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Baker Tilly Advisory Group, LP's own hiring page 3 days ago.
What is the job?
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.
What does it pay?
$86K to $163K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

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.

Key Responsibilities

  • Data Engineering: Develop scalable, well‑documented ETL/ELT pipelines using SQL, Python, and an appropriate orchestration platform (e.g. Azure Data Factory, Fabric Data Pipelines, Apache Airflow); implement best‑practice patterns for performance, security, and cost control.
  • Modeling & Storage: Design relational and lakehouse models, create medallion-style data layers, and prepare and transform data for semantic layers and AI consumption.
  • Quality & Governance: Build automated data‑quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
  • Client Delivery: Gather requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non‑technical audiences.
  • Continuous Improvement: 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

  • Education – Bachelor’s in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
  • Experience – 3-5 years delivering production data solutions, preferably in a consulting or client‑facing role.

-Technical Skills

  • 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.
  • Experience using approved AI-assisted development tools responsibly preferred.
  • Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks preferred.
  • Experience in integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Oracle, Costpoint) preferred.

The pay rate range for this job position is $85,910 to $162,890. 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.

Similar open jobs

Data engineer jobs in Chicago (33)Jobs in Chicago (6815)