Data Engineer
Burtch Works · Chicago, IL
- On site
- Full-time
- $95,000 / year
- Chicago, IL
Job highlights
- Build scalable data pipelines and enterprise data platform.
- Integrate ERP, CRM, and operational systems.
- Develop semantic models for reporting and analytics.
- Collaborate with finance, operations, and business teams.
- Shape foundational data infrastructure in growing enterprise.
About the role
Data Engineer
About The Company
Our client is a rapidly growing, private equity-backed manufacturing organization serving the infrastructure, construction, and renewable energy industries through multiple business divisions. The organization is focused on building scalable operational and technology infrastructure to support long-term growth, acquisitions, and enterprise-wide operational visibility.
As part of this transformation, our client recently established a centralized Systems & Data Team responsible for modernizing ERP systems, improving reporting and analytics capabilities, and building a scalable enterprise data foundation across the organization.
Job Summary
We are seeking a hands-on Data Engineer to join a newly formed Systems & Data Team in Chicago. This individual will play a foundational role in helping build and scale a centralized enterprise data platform capable of supporting operational growth, acquisitions, and enterprise reporting across multiple business divisions.
The ideal candidate is a practical, solutions-oriented data professional with strong ETL and SQL expertise, experience supporting operational or ERP-connected environments, and the ability to work cross-functionally with finance, operations, and business stakeholders. This role will support the full lifecycle from data pipeline development through semantic modeling and business reporting enablement.
This is an excellent opportunity for an early-to-mid career data engineer who wants to help shape foundational data infrastructure within a growing enterprise environment while gaining exposure to enterprise systems, reporting strategy, and large-scale operational data initiatives.
Key Responsibilities
- Design, build, and maintain scalable ETL/data pipelines that integrate ERP, CRM, operational, and reporting systems into a centralized enterprise data platform.
- Partner with internal stakeholders and external consulting teams to support the implementation and ongoing evolution of the enterprise data warehouse and reporting environment.
- Participate in architecture discussions and platform evaluation efforts while supporting long-term operational ownership of the environment.
- Support integration and normalization of data across disparate ERP and operational systems spanning multiple business divisions and future acquisitions.
- Build and maintain semantic models and business-facing data structures that support operational, financial, and executive reporting requirements.
- Support self-service analytics and reporting capabilities through Power BI, including dashboard development and operational reporting enhancements.
- Collaborate with finance, operations, and ERP/business systems teams to translate reporting requirements into scalable and maintainable data solutions.
- Automate repetitive reporting and operational workflows using Python, Power Automate, or related technologies to reduce manual effort and improve data reliability.
- Monitor pipeline health, troubleshoot data issues, and proactively address failures, latency, and data inconsistencies before they impact the business.
- Support enterprise scalability initiatives tied to acquisitions, operational growth, and long-term modernization of reporting infrastructure.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related technical field.
- 1–4 years of experience in data engineering, ETL development, analytics engineering, or a related role.
- Experience working within ERP-connected or operational reporting environments.
- Experience supporting business intelligence or operational analytics initiatives.
- Strong SQL skills required.
- Experience with Python or similar scripting languages for automation and data transformation.
- Experience building and maintaining ETL/data pipelines.
- Experience with Power BI and business reporting tools.
- Familiarity with semantic modeling and data warehouse concepts.
- Strong communication and business translation skills.
- Ability to operate in evolving, fast-moving environments.
- Comfortable partnering with both technical and non-technical stakeholders.
- Hybrid work environment with expected in-office collaboration in Chicago.
Preferred Qualifications
- Experience supporting manufacturing, industrial, construction, or operational business environments.
- Experience working with ERP systems such as Acumatica or similar platforms.
- Familiarity with modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, or Azure-based ecosystems.
- Experience with Power Automate, SharePoint, or Microsoft 365 integrations.
- Exposure to medallion architecture or centralized enterprise data platform initiatives.
- Experience supporting M&A integration or enterprise scalability initiatives.
Benefits
- Competitive base salary
- 15–20% annual bonus eligibility
- Comprehensive health and wellness benefits package
- Hybrid work flexibility with collaborative in-office environment
- Opportunity to help shape and build foundational enterprise data infrastructure within a growing organization
- Exposure to enterprise modernization initiatives, executive visibility, and long-term growth opportunities
Key skills/competency
- Data Engineering
- ETL Development
- SQL
- Python
- Data Pipelines
- Data Modeling
- Business Intelligence
- Power BI
- ERP Systems
- Cloud Data Platforms
Skills & topics
- Data Engineer
- ETL
- SQL
- Python
- Data Pipelines
- Data Warehousing
- Business Intelligence
- Power BI
- ERP Systems
- Cloud Data Platforms
- Manufacturing
- Infrastructure
- Construction
- Renewable Energy
- Chicago
- Hybrid Work
How to get hired
- Tailor your resume: Highlight your 1-4 years of data engineering, ETL, and SQL experience, emphasizing ERP or operational reporting environments.
- Showcase relevant skills: Detail your proficiency in Python for automation and your experience with Power BI for business reporting.
- Address requirements directly: Clearly state your Bachelor's degree and your ability to work cross-functionally with diverse stakeholders.
- Prepare for hybrid work: Be ready to discuss your comfort with a hybrid model and collaborative in-office expectations in Chicago.
Technical preparation
Practice complex SQL queries for data manipulation.,Build and test ETL pipelines with Python.,Develop dashboards in Power BI.,Understand data warehouse and semantic modeling concepts.
Behavioral questions
Describe a time you collaborated with non-technical teams.,How do you handle data inconsistencies or pipeline failures?,Tell me about a complex data integration challenge.,How do you prioritize tasks in a fast-moving environment?
Frequently asked questions
- What is the work arrangement for the Data Engineer role at Burtch Works?
- The Data Engineer role at Burtch Works operates on a hybrid model, requiring in-office collaboration in Chicago. This offers a blend of flexibility and team interaction.
- What are the primary responsibilities of a Data Engineer at Burtch Works?
- As a Data Engineer at Burtch Works, you will design, build, and maintain ETL/data pipelines, integrate various systems, develop semantic models, and support business intelligence initiatives, all contributing to a centralized enterprise data platform.
- What technical skills are essential for the Data Engineer position at Burtch Works?
- Essential technical skills for the Data Engineer role include strong SQL, experience with Python for automation, ETL/data pipeline development, and familiarity with Power BI for business reporting. Experience with ERP systems and data warehouse concepts is also key.
- What kind of company culture can I expect as a Data Engineer at Burtch Works?
- Burtch Works is a growing, private equity-backed manufacturing organization focused on building scalable infrastructure. The culture supports innovation, collaboration, and offers opportunities for individuals to shape foundational data systems.
- What is the expected experience level for this Data Engineer role?
- This Data Engineer role is ideal for an early-to-mid career professional with 1-4 years of experience in data engineering, ETL development, or a related field.
- How does Burtch Works support professional growth for its Data Engineers?
- Data Engineers at Burtch Works gain exposure to enterprise systems, reporting strategy, and large-scale operational data initiatives. The role offers opportunities to help shape foundational data infrastructure and participate in modernization efforts.
- What are the benefits of working as a Data Engineer at Burtch Works?
- Burtch Works offers a competitive salary, 15-20% annual bonus eligibility, a comprehensive benefits package, and hybrid work flexibility, alongside the opportunity to make a significant impact on enterprise data infrastructure.
Similar roles
Open positions we recommend based on this role.