DataJobs.io
← Back to all jobs
Baker Tilly Advisory Group, LP

Associate Data Engineer

Baker Tilly Advisory Group, LP
Milwaukee, WI $86k - $163k/yr Full time Posted 1d ago
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
Apply Now

Job Description

In this onsite role in Milwaukee, you will design, build, and optimize modern data solutions for mid-market and enterprise clients, with a primary focus on the Microsoft data stack. The work involves turning raw data into analytics-ready assets that support dashboards, advanced analytics, and AI use cases in a consulting and client-facing environment.

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 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 in Azure DevOps or GitHub.
  • Gather requirements, demo iterative deliverables, document technical designs, and translate complex concepts for non-technical audiences.
  • Research new capabilities, share findings 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 in Computer Science, Information Systems, Engineering, or a 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 using at least one Microsoft service (ADF, Synapse Pipelines, or Fabric Data Pipelines).
  • Project experience with Microsoft Fabric including OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, and Power BI DirectLake is preferred.
  • Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies is preferred.
  • Exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks is preferred.
  • Experience integrating SaaS/ERP sources (examples include Dynamics 365, Workday, and Costpoint) is preferred.

Technology Focus

Work will center on T-SQL and Python alongside Microsoft data services such as Azure Data Factory, Azure Synapse, and Microsoft Fabric. You will also work with Fabric OneLake, Lakehouse concepts, Power BI modeling, Azure DevOps or GitHub for CI/CD, and relevant lakehouse tooling including Databricks and Delta Lake. Preferred/related areas include Terraform, Bicep, YAML pipelines, test automation frameworks, and integrations with platforms such as Dynamics 365, Workday, and Costpoint, including Power BI DirectLake and Fabric Warehouse.

Location and Compensation

This position is onsite in Milwaukee, WI. Compensation is USD 85,910 - 162,890 per year.

Minimum Experience

Minimum experience is 2 years.

Similar Jobs