Associate Data Engineer
Baker Tilly US
full-time
Posted on:
Location Type: Office
Location: Frisco • Texas, Wisconsin • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
AzureERPETLPythonSQLTerraform
About the role
- Design, build, and optimize modern data solutions for clients
- Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks
- Build automated data-quality checks, lineage, and observability metrics
- Gather requirements, demo iterative deliverables, document technical designs
- Research new capabilities, share findings in internal communities of practice
Requirements
- 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
- Health insurance
- Professional development
- Flexible work arrangements
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
T-SQLPythonETLELTAzure Data FactoryDatabricksData transformationPerformance tuningData wranglingTest automation
Soft skills
CommunicationDocumentationRequirement gatheringCollaborationProblem-solving