Associate Data Engineer
Analytics
Azure
Azure Data Factory
Azure Databricks
Azure Synapse Analytics
Big Data
Business Analytics
Business Intelligence
CI/CD
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Governance
Data Integration
Data Lake
Data Pipeline
Data Platform
Data Warehouse
Databricks
DevOps
Erp Integration
ETL
Infrastructure As Code
Microsoft Azure
Power BI
Job Description
Associate Data Engineer role with Baker Tilly Advisory Group, LP in Tampa, FL (onsite), offering USD 85,910 - 162,890 per year.
Responsibilities
- Data Engineering: Develop scalable ETL/ELT pipelines using T-SQL, Python, Azure Data Factory or Fabric Data Pipelines, and Databricks; implement patterns for performance, security, and cost control.
- Modeling & Storage: Design relational and lakehouse data models; configure Fabric OneLake shortcuts, medallion style layers, and dimensional/semantic models for Power BI.
- Quality & Governance: Build automated data quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub.
- Client Delivery: Gather requirements, demonstrate iterative deliverables, document technical designs, and translate complex concepts for non-technical stakeholders.
- Continuous Improvement: Research new capabilities, share findings in internal communities of practice, and contribute reusable accelerators; collaborate with clients and internal teams to design scalable data solutions.
Requirements
- Bachelor's degree 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 (Azure Data Factory, 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.
- Technologies you will work with: T-SQL, Python, Azure Data Factory, Fabric Data Pipelines, Databricks, Microsoft Fabric, OneLake, Lakehouses, Power BI, Delta Lake, Azure DevOps, GitHub, YAML pipelines, Terraform, Bicep, Dynamics 365, Workday, Costpoint.