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 focuses on designing, building, and optimizing modern data solutions for mid-market and enterprise clients. Work is primarily centered on the Microsoft data ecosystem, transforming raw data into analytics-ready assets using Azure, Synapse, and Microsoft Fabric.
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 models, including creation of Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
- Build automated data-quality checks, lineage, and observability metrics, and contribute to CI/CD workflows using Azure DevOps or GitHub.
- Collect and refine requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non-technical audiences.
- Research new capabilities, share learnings within internal 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 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 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, such as Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.
Technology Stack
- T-SQL, Python
- Azure, Azure Data Factory, Synapse Pipelines
- Microsoft Fabric, Fabric Data Pipelines
- Databricks, Delta Lake
- Fabric OneLake, Fabric OneLake shortcuts, lakehouses
- Medallion-style layers, dimensional/semantic models, Power BI
- Power BI DirectLake
- Azure DevOps, GitHub, CI/CD, CI/CD workflows
- YAML pipelines, Notebooks, Warehouse
- Terraform, Bicep
Role Details
- Title: Associate Data Engineer
- Location: Frisco, TX (onsite)
- Salary Range: USD 85,910 to 162,890 per year
- Experience Level: 2+ years