Azure Data Engineer

OverviewJoin 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: ContractAbout 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 SummaryWe 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.ResponsibilitiesDesign, 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 tegrate 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 HavesExperience 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 levelMid-Senior levelEmployment typeContractJob functionInformation Technology, Consulting, and EngineeringIndustries: IT Services and IT Consulting, Venture Capital and Private Equity Principals, and Financial ServicesReferrals increase your chances of interviewing at Burtch Works by 2xGet notified about new Data Engineer jobs in Chicago, IL. #J-18808-Ljbffr

Created: 2025-09-17