Associate Data Engineer

Baker Tilly US

. Design, build, and optimize modern data solutions for mid-market and enterprise clients .

Posted 10/27/2026full-timeRemote • United StatesJuniorMid-Level💰 $85,910 - $162,890 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing data solutions, with a strong focus on ETL/ELT processes using T-SQL and Python. Proficient in utilizing Microsoft Fabric and Azure Data Factory for scalable data management and analytics.

Highest-signal resume keywords

T-SQL Data TransformationPython Data WranglingETL/ELT with Azure Data FactoryMicrosoft Fabric Project ExperienceDevOps Exposure

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

T-SQLPythonETLELTAzure Data FactoryDatabricksData ModelingCI/CD WorkflowsData Quality ChecksPerformance Tuning

Soft Skills

CollaborationCommunicationRequirement GatheringDocumentationProblem-Solving

Tools & Technologies

Azure DevOpsGitHubPower BIDelta LakeTerraformBicep

Industry Keywords

Data SolutionsClient-Facing RoleSaaS IntegrationERP SourcesConsulting

Tech Stack

Tools & technologies

AzureERPETLPythonSQLTerraform

About the role

Key responsibilities & impact

Design, build, and optimize modern data solutions for mid-market and enterprise clients
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, and document technical designs
Translate complex concepts to non-technical audiences
Research new capabilities, share findings in internal communities of practice, and contribute to reusable accelerators
Collaborate with solution architects, analysts, client stakeholders, clients, and internal stakeholders

Requirements

What you’ll need

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

Benefits

Comp & perks

Comprehensive compensation and benefits package to eligible employees