Data Engineer

Baker Tilly US

Senior Consultant – Associate Data Engineer designing and optimizing data solutions for clients using Microsoft technologies. Collaborating with teams to deliver analytics-ready assets and advanced insights.

Posted 5/28/2026full-timeFrisco • Florida, Texas, Wisconsin • 🇺🇸 United StatesJuniorMid-Level💰 $85,910 - $162,890 per yearWebsite

Tech Stack

Tools & technologies

AzureERPETLPythonSQLTerraform

About the role

Key responsibilities & impact

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, demo iterative deliverables, document technical designs, and translate 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.

Requirements

What you’ll need

Education – Bachelor’s in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)
Experience – 2–3 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
Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks preferred
Experience integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint) preferred

Benefits

Comp & perks

Comprehensive compensation and benefits package

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

T-SQLPythonETLELTdata transformationperformance tuningdata wranglingAzure Data FactoryDatabricksCI/CD

Soft Skills

collaborationcommunicationdocumentationrequirements gatheringclient-facingproblem-solvingtechnical designiterative deliverablestranslating complex conceptsresearch