Associate Data Engineer
Posted 4hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Associate Data Engineer building Azure, Synapse, and Microsoft Fabric data solutions for Baker Tilly’s mid-market and enterprise clients. Developing pipelines, lakehouse models, governance, and analytics-ready assets.
Responsibilities:
- 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:
- 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:
- Comprehensive compensation and benefits package to eligible employees




















