Associate Data Engineer
Analytics
Automation Developer
Azure
Azure Analytics
Azure Data Engineer
Azure Data Factory
Azure Data Lake
Azure Data Platform
Azure Synapse Analytics
Business Analytics
Business Intelligence
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Engineer
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Design
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft Azure
Microsoft Office
Microsoft Power Platform
Office Tools
Power BI
Power Platform
Programming Languages
Reporting and Analytics
Software Development
SQL
Visual Design
Job Description
Design, build, and improve client-ready data platforms using the Microsoft data stack in a consulting-focused, client-facing environment.
Responsibilities
- Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks
- Apply best-practice patterns for performance, security, and cost control
- Design relational and lakehouse models, including Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI
- Create 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 technical concepts for non-technical audiences
- Research new platform capabilities and share findings through internal communities of practice
- Contribute to reusable accelerators and collaborate with clients and internal stakeholders on scalable 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 for data transformation and performance tuning
- Python for data wrangling, orchestration, or notebook-based development
- Hands-on ETL/ELT experience with at least one Microsoft service: ADF, Synapse Pipelines, or Fabric Data Pipelines
- Project experience with Microsoft Fabric preferred: OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake
- Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies preferred
- Exposure to DevOps and test automation frameworks preferred (YAML pipelines, Terraform/Bicep, test automation frameworks)
- Experience integrating SaaS/ERP sources preferred (e.g., Dynamics 365, Workday, Costpoint)
Skills & Technologies
- T-SQL, Python
- Azure Data Factory, Azure Synapse, Microsoft Fabric, Fabric Data Pipelines
- Microsoft Azure, Databricks
- Fabric OneLake, OneLake, Lakehouse, medallion-style layers
- Power BI, Power BI DirectLake, dimensional/semantic models
- ETL/ELT, Delta Lake
- Azure DevOps, GitHub, CI/CD
- Terraform, Bicep, YAML pipelines, test automation frameworks
- Dynamics 365, Workday, Costpoint
Location & Compensation
- Location: Milwaukee, WI (onsite)
- Salary: USD 85,910 - 162,890 per year
Similar Jobs
