Associate Data Engineer
Analytics
Application Security
Automation
Automation Developer
Azure
Azure Data Engineer
Azure Data Factory
Azure Data Lake
Azure Data Platform
Azure DevOps
Azure Platform
Azure Synapse Analytics
Big Data
Bigdata
Business Analytics
Business Intelligence
CI/CD
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Infrastructure
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Cloud Technology
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Lake
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Databricks
Delta Lake
Design
DevOps
Devops Tools
DevSecOps
Digital Marketing
ETL
Facilities Management
Hr Technology
Informatica
Information Technology (IT)
Infrastructure As Code
Integration
Microsoft
Microsoft Azure
Microsoft Fabric
Microsoft Office
Microsoft Power Platform
Office Tools
Power BI
Power Platform
Programming Language
Programming Languages
Reporting and Analytics
Security Automation
Software Development
Spark
SQL
Visual Design
Job Description
The Associate Data Engineer role at Baker Tilly Advisory Group, LP focuses on designing, building, and optimizing modern data solutions for mid-market and enterprise clients. Work is primarily centered on the Microsoft data stack, transforming raw information into analytics-ready assets.
Responsibilities
- Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks, applying best-practice patterns for performance, security, and cost control.
- Design relational and lakehouse data models; create Fabric OneLake shortcuts, implement medallion-style layers, and build dimensional/semantic models to support Power BI.
- Build automated data-quality checks, establish lineage, and contribute observability metrics; support CI/CD workflows in Azure DevOps or GitHub.
- Collect requirements, demonstrate iterative deliverables, document technical designs, and communicate complex concepts to non-technical audiences.
- Research new platform capabilities, share insights within internal communities of practice, contribute to reusable accelerators, and collaborate with clients and internal stakeholders to deliver scalable data engineering solutions.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).
- 2 to 3 years delivering production data solutions, preferably in a consulting or client-facing context.
- Strong T-SQL skills for data transformation and performance tuning.
- Proficiency in Python for data wrangling, orchestration, or notebook-based development.
- Hands-on ETL/ELT experience using at least one Microsoft service: Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.
Technologies
- T-SQL, Python, Azure
- Azure Data Factory, Synapse Pipelines, Fabric Data Pipelines
- Databricks, Microsoft Fabric, Fabric OneLake
- Power BI, including Power BI DirectLake
- Azure DevOps, GitHub, CI/CD
- Fabric OneLake shortcuts, lakehouses, medallion-style layers
- Dimensional/semantic models, Delta Lake
- YAML pipelines, Terraform, Bicep
- Notebooks, Warehouse, OneLake
Role Details
- Location: Frisco, TX (onsite)
- Experience: Minimum 2 years
- Compensation: USD 85,910 to 162,890 per year
Similar Jobs
