Associate Data Engineer

The Associate Data Engineer collaborates with cross-functional teams to design, build, and optimize data platforms for mid-market and enterprise clients. Focusing on the Microsoft stack, the role leverages Azure, Synapse, and Microsoft Fabric to convert raw data into analytics-ready assets for dashboards, advanced analytics, and AI use cases.

Location

Milwaukee, WI (onsite)

Compensation

USD 85,910 - 162,890 per year

Responsibilities

• Data engineering: Build scalable ETL/ELT pipelines using T-SQL, Python, Azure Data Factory or Fabric Data Pipelines, and Databricks; apply best practice patterns for performance, security, and cost control.
• Modeling and storage: Design relational and lakehouse models; implement Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
• Quality and governance: Create 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 audiences.
• Continuous improvement: Explore new capabilities, share findings in internal communities of practice, and contribute to reusable accelerators. Collaborate with clients and internal stakeholders to design scalable data engineering 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, or 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

• T-SQL
• Python
• Azure Data Factory
• Fabric Data Pipelines
• Databricks
• Fabric OneLake
• Power BI
• Azure DevOps
• GitHub
• Microsoft Fabric
• Azure Synapse
• Azure
• Notebooks
• Delta Lake
• Dynamics 365
• Workday
• Costpoint
• Terraform
• Bicep
• YAML pipelines
• Power BI DirectLake