Associate Data Engineer
Baker Tilly2 days ago
Remote, United States +3 moreMid Level / Senior
Base Salary
$86k - $163k/yr
Responsibilities
- Develop scalable and well-documented ETL/ELT pipelines using SQL, Python, and orchestration platforms.
- Implement data-engineering patterns for performance, security, and cost control.
- Design relational and lakehouse models and create medallion-style data layers.
- Prepare and transform data for semantic layers and AI consumption.
- Build automated data-quality checks, data lineage, and observability metrics.
- Contribute to CI/CD workflows using Azure DevOps or GitHub.
- Gather client requirements, demonstrate iterative deliverables, document technical designs, and translate complex concepts for non-technical audiences.
- Research new capabilities, share findings in communities of practice, and contribute to reusable accelerators.
- Collaborate with clients and internal stakeholders to design and implement scalable data-engineering solutions.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience.
- 3–5 years delivering production data solutions, preferably in consulting or client-facing environments.
- Strong T-SQL skills for data transformation and performance tuning.
- Python experience for data wrangling, orchestration, or notebook-based development.
- Hands-on ETL/ELT experience with at least one Microsoft service such as Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.
- Preferred experience with Microsoft Fabric, including OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, and 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 integrating SaaS/ERP sources such as Dynamics 365, Workday, Oracle, or Costpoint.
Benefits
- Baker Tilly offers a comprehensive compensation and benefits package to eligible employees.
- Work location requirements should be discussed with a Baker Tilly talent acquisition professional.
About Baker Tilly
Baker Tilly provides audit/assurance, tax, and advisory services—including analytics, governance risk and compliance, and government contracting—to companies, public sector entities, and nonprofits. Headquartered in Chicago and organized as a partnership, it operates coast to coast in the U.S. and is an independent member of Baker Tilly International, with U.S. attest services delivered by Baker Tilly US, LLP and tax and advisory by Baker Tilly Advisory Group, LP.