Azure Data Engineer Job at Burtch Works, Chicago, IL

ZVRnazdTWWZZOGtrNWtaM3g4NjJDOWJiWFE9PQ==
  • Burtch Works
  • Chicago, IL

Job Description

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 Burtch Works

Job Tags

Contract work, Flexible hours,

Similar Jobs

Penn Creative

Senior Graphic Designer Job at Penn Creative

 ...sophisticated clients. But were not just looking for a graphic designer. Were seeking a leader who can create exceptional design...  ...Requirements ~8+ years of graphic design experience in an AGENCY setting (excluding internships/ student work/freelance). ~ A formal education... 

UPMC - Pittsburgh Medical Center

Grill - Cold Cook Job at UPMC - Pittsburgh Medical Center

 ...supplies away from food production areas. Adhere to departmental safe food handling procedures at all times. Work permit required if under 18 years old. Licensure, Certifications, and Clearances: ~ Act 34 UPMC is an Equal Opportunity Employer/Disability... 

Magellan Financial & Insurance Services, Inc.

Graphic Designer Job at Magellan Financial & Insurance Services, Inc.

 ...success. Role Overview: We are seeking a talented Graphic Designer to join our dynamic creative team. In this role, you will craft...  ...final products. Assemble and trim video segments to set the desired sequence and create the right flow. Add music, dialogues... 

Stryten Energy

Distribution Center Worker Job at Stryten Energy

 ...Overview Stryten Energy is looking for great additions to the Salina team! Distribution Center Workers fill Order Processors, Rotates, Warehouse, Plaque Room, and Dock Coordinator positions in our distribution center departments. Distribution center workers must work... 

PIRTEK Medina Valley

Field Mechanic - Hydraulic Hose Technician Job at PIRTEK Medina Valley

 ...Job Description Job Description Job Description PIRTEK is hiring for a Hose Assembly & Installation Technician to service, assemble, and install hydraulic and industrial hoses for a diverse customer base in varying environmental conditions. This is a messy...