Burtch Works
Overview
Join to apply for the
Azure Data Engineer
role at
Burtch Works Job Title:
Data Engineer – Azure & Fabric Location:
Chicago (Hybrid) – On-site cadence flexible; occasional travel to collaborate with partner teams and portfolio companies. Job Type:
Contract About The Company
A U.S.-based private equity firm focused on partnering with lower middle-market industrial growth businesses. The firm invests in high-performing companies that can benefit from operational, technology, and strategic resources to scale and thrive. Portfolio companies span essential industrial sectors, creating opportunities to apply shared data/technology solutions that drive measurable enterprise value. Job Summary
We are seeking a
hands-on Data Engineer
to design and build a modern data platform in
Microsoft Azure and Fabric . This role will focus on developing ETL pipelines, integrating key data sources (ERP, CRM, HRIS, subscription data), and building a scalable
Data Mart
to support analytics, reporting, and decision-making across the firm and its portfolio companies. The ideal candidate thrives in an individual contributor role, enjoys working in a multi-entity environment, and is passionate about building high-quality, reliable data solutions. Responsibilities
Design, build, and maintain ETL pipelines in Azure and Microsoft Fabric using a medallion architecture (bronze/silver/gold). Develop and optimize a centralized Data Mart to support business reporting, analytics, and self-service dashboards in Power BI. Integrate structured and unstructured data from ERP, CRM, HRIS, and subscription-based systems via APIs and connectors. Ensure data quality, lineage, and governance practices are followed to maintain trusted datasets. Automate workflows and monitor pipelines for reliability, scalability, and performance. Collaborate with analysts, business stakeholders, and portfolio companies to translate requirements into technical solutions. Document data models, processes, and pipelines to support long-term maintainability. Requirements (Must-Haves)
5+ years of experience as a Data Engineer with strong expertise in ETL, Azure services, and Microsoft Fabric. Experience building Data Marts or Data Warehouses with medallion/lakehouse patterns. Strong SQL and data modeling skills with a focus on structured and semi-structured data. Hands-on experience integrating APIs and third-party data sources. Familiarity with Power BI and enabling data for self-service analytics. Strong problem-solving and documentation skills with a detail-oriented mindset. Nice to Haves
Experience working with subscription data or harmonizing external datasets with internal sources. Exposure to data governance frameworks and best practices. Familiarity with modern approaches like dbt, orchestration tools (Airflow, ADF, Synapse Pipelines), or GenAI for data productivity. Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology, Consulting, and Engineering Industries: IT Services and IT Consulting, Venture Capital and Private Equity Principals, and Financial Services Referrals increase your chances of interviewing at Burtch Works by 2x Get notified about new Data Engineer jobs in
Chicago, IL .
#J-18808-Ljbffr
Join to apply for the
Azure Data Engineer
role at
Burtch Works Job Title:
Data Engineer – Azure & Fabric Location:
Chicago (Hybrid) – On-site cadence flexible; occasional travel to collaborate with partner teams and portfolio companies. Job Type:
Contract About The Company
A U.S.-based private equity firm focused on partnering with lower middle-market industrial growth businesses. The firm invests in high-performing companies that can benefit from operational, technology, and strategic resources to scale and thrive. Portfolio companies span essential industrial sectors, creating opportunities to apply shared data/technology solutions that drive measurable enterprise value. Job Summary
We are seeking a
hands-on Data Engineer
to design and build a modern data platform in
Microsoft Azure and Fabric . This role will focus on developing ETL pipelines, integrating key data sources (ERP, CRM, HRIS, subscription data), and building a scalable
Data Mart
to support analytics, reporting, and decision-making across the firm and its portfolio companies. The ideal candidate thrives in an individual contributor role, enjoys working in a multi-entity environment, and is passionate about building high-quality, reliable data solutions. Responsibilities
Design, build, and maintain ETL pipelines in Azure and Microsoft Fabric using a medallion architecture (bronze/silver/gold). Develop and optimize a centralized Data Mart to support business reporting, analytics, and self-service dashboards in Power BI. Integrate structured and unstructured data from ERP, CRM, HRIS, and subscription-based systems via APIs and connectors. Ensure data quality, lineage, and governance practices are followed to maintain trusted datasets. Automate workflows and monitor pipelines for reliability, scalability, and performance. Collaborate with analysts, business stakeholders, and portfolio companies to translate requirements into technical solutions. Document data models, processes, and pipelines to support long-term maintainability. Requirements (Must-Haves)
5+ years of experience as a Data Engineer with strong expertise in ETL, Azure services, and Microsoft Fabric. Experience building Data Marts or Data Warehouses with medallion/lakehouse patterns. Strong SQL and data modeling skills with a focus on structured and semi-structured data. Hands-on experience integrating APIs and third-party data sources. Familiarity with Power BI and enabling data for self-service analytics. Strong problem-solving and documentation skills with a detail-oriented mindset. Nice to Haves
Experience working with subscription data or harmonizing external datasets with internal sources. Exposure to data governance frameworks and best practices. Familiarity with modern approaches like dbt, orchestration tools (Airflow, ADF, Synapse Pipelines), or GenAI for data productivity. Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology, Consulting, and Engineering Industries: IT Services and IT Consulting, Venture Capital and Private Equity Principals, and Financial Services Referrals increase your chances of interviewing at Burtch Works by 2x Get notified about new Data Engineer jobs in
Chicago, IL .
#J-18808-Ljbffr