Azure Data Engineer Job at Burtch Works, Chicago, IL

aWl2QnFRbW1XQW0yU25aK29UQzVLQkxqalE9PQ==
  • 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

Texas State University

Assistant Professor - Applied Mathematics Job at Texas State University

 ...mathematics courses at the undergraduate and graduate levels, and will show dedication to...  ...department through service to the department, college, or university or engage in service to...  ...research excellence in Applied Mathematics. Recent publications will be emphasized, but all... 

JCW

Conflicts Analyst Job at JCW

 ...Business Acceptance Unit (BAU) is to process requests from partners to accept new legal matters including, in particular, performing conflicts checks on each new matter (for both new and existing clients), and lateral hires.Role and ResponsibilitiesTaking responsibility... 

CDS (Club Demonstration Services)

Part Time Sr. Shift Supervisor in Costco Job at CDS (Club Demonstration Services)

Job Description We want you to help us shape the future of shopping experiences and deliver on our purpose of connecting people with the products and experiences that enrich their lives. Joining Advantage Solutions means joining a network of 65,000 teammates serving...

Residential Home Health and Hospice

Hospice LPN Job at Residential Home Health and Hospice

 ...Job Description At Residential Home Health and Hospice (Residential), were looking to add to our extraordinary care team. Grounded...  ...for you and your family We are looking for compassionate nurses with: LPN license in the state you work Graduate from an... 

Ledgent Technology

Sr Network Engineer Job at Ledgent Technology

 ...Our client, one of the nationwide top employers, has engaged our firm in their search for an Senior Network Engineer . The person in this role would be focuses on enterprise network design, implementation, and support across 400+ branch offices and datacenters with...