Associate Data Engineer

Baker Tilly Advisory Group

Madison (WI)

Presencial

USD 86.000 - 163.000

Jornada completa

Hace 3 días
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

Baker Tilly Advisory Group in Madison, WI is seeking an Associate Data Engineer to design, build, and optimize modern data solutions for mid-market and enterprise clients. You will work primarily within the Microsoft stack (Azure, Synapse, Fabric) to transform raw data into analytics-ready assets powering dashboards and AI use cases.

You will collaborate with solution architects, analysts, and stakeholders while sharpening technical depth and consulting skills.

Formación

  • Bachelor's in Computer Science, Information Systems, Engineering or related field (or equivalent experience).
  • 3–5 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.

Responsabilidades

  • Data Engineering: Develop scalable, well-documented ETL/ELT pipelines using SQL, Python, and an orchestration platform (e.g. ADF, Fabric, Airflow).
  • Modeling & Storage: Design relational and lakehouse models and prepare data for semantic layers and AI consumption.
  • Quality & Governance: Build automated data-quality checks, lineage, and observability metrics; contribute to CI/CD workflows.
  • Client Delivery: Gather requirements, demo iterative deliverables, document designs, and translate complex concepts to non-technical audiences.
  • Continuous Improvement: Research new capabilities and share findings with internal communities; design scalable data engineering solutions.

Conocimientos

T-SQL
Python
ETL/ELT pipelines
Azure Data Factory
Fabric Data Pipelines
Databricks
Delta Lake
Notebooks

Educación

Bachelor's in Computer Science / Information Systems / Engineering

Herramientas

Azure Data Factory
Fabric Data Pipelines

Descripción del empleo

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. Baker Tilly Advisory Group, LP and Baker Tilly US, LLP (Baker Tilly) provide professional services through an alternative practice structure in accordance with the AICPA Code of Professional Conduct and applicable laws, regulations and professional standards. Baker Tilly US, LLP is a licensed independent CPA firm that provides attest services to its clients. Baker Tilly Advisory Group, LP and its subsidiary entities provide tax and business advisory services to their clients. Baker Tilly Advisory Group, LP and its subsidiary entities are not licensed CPA firms.

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.

Job Description:

As an 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.

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

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Associate Data Engineer
Associate Data Engineer

Baker Tilly • EE. UU.

A distancia
USD 86.000 - 163.000
Associate Data Engineer
Associate Data Engineer

Baker Tilly • Chicago (IL)

Presencial
USD 86.000 - 163.000
Associate Data Engineer
Associate Data Engineer

Baker Tilly International • Madison (WI)

Presencial
USD 86.000 - 163.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • California

Presencial
USD 185.000 - 230.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • Santa Clara (CA)

Presencial
USD 185.000 - 230.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • Irvine (CA)

Presencial
USD 185.000 - 230.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • Portland (OR)

Presencial
USD 185.000 - 230.000
Sr Data Engineer
Sr Data Engineer

Baker Tilly Advisory Group, LP • San Jose (CA)

Presencial
USD 185.000 - 230.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • Santa Monica (CA)

Presencial
USD 185.000 - 230.000
Senior Data Engineer
Senior Data Engineer

Baker Tilly (US) • San Jose (CA)

Presencial
USD 185.000 - 230.000