Associate Data Engineer

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 worlds 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 43000 professionals and a combined worldwide revenue of $5.2 billion. join the conversation onLinkedInFacebookandInstagram.

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 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 Tillys 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 midmarket and enterprise clients. Working primarily inside the Microsoft stack (Azure Synapse and Microsoft Fabric) you will transform raw data into trusted analyticsready assets that power dashboards advanced analytics and AI use cases. Youll collaborate with solution architects analysts and client stakeholders while sharpening both your technical depth and consulting skills.

Key Responsibilities:

• Data Engineering: Develop scalable welldocumented ETL/ELT pipelines using TSQL Python Azure Data Factory/Fabric Data Pipelines and Databricks; implement bestpractice patterns for performance security and cost control.

• Modeling & Storage: Design relational and lakehouse models; create Fabric OneLake shortcuts medallionstyle layers and dimensional/semantic models for Power BI.

• Quality & Governance: Build automated dataquality 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 nontechnical 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 Bachelors in Computer Science Information Systems Engineering or related field (or equivalent experience)

- Experience 23 years delivering production data solutions preferably in a consulting or clientfacing role.

- Technical Skills:

**Strong TSQL for data transformation and performance tuning.

**Python for data wrangling orchestration or notebookbased development.

**Handson 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

- Exposure to DevOps (YAML pipelines Terraform/Bicep) and test automation frameworks preferred

- Experience integrating SaaS/ERP sources (e.g. Dynamics 365 Workday Costpoint) preferred

The pay rate range for this job position is $85910 to $162890. Actual compensation is influenced by a variety of relevant factors including but not limited to applicants skills prior experience qualifications degrees professional certifications work arrangements and geographic location. Baker Tilly offers a comprehensive compensation and benefits package to eligible employees.