Zekelman Industries ยท 1 day ago
Business Intelligence Intern
Chicago, IL - Headquarters
Internship
Onsite
Intern
Start in 2026 SpringZekelman Industries is a family of companies and the largest independent steel pipe and tube manufacturer in North America. As a Business Intelligence Intern at Z Modular, you will design and refine an internal analytics tool to deliver insights into active properties, working with data exports and visualization tools to aid business decision-making in real estate and modular construction.
Building MaterialManufacturing
Responsibilities
Connect and integrate data from HelloData and Yardi (rent roll, unit availability, occupancy)
Build a foundational reporting model in Power BI or Excel to track occupancy, leased %, and exposure
Incorporate rent banding analysis and compare budget vs. actuals across multiple properties
Test the reporting model across properties for consistency and reliability
Document key assumptions, data sources, and refresh procedures
Validate KPIs by reconciling model outputs with Yardi and HelloData reports
Investigate discrepancies in metric definitions (e.g., true occupancy vs. reported)
Refine the tool to highlight red flags such as incorrect unit status or unusual absorption patterns
Deliver a final dashboard and user guide for business users
Perform other duties as assigned
Qualification
Required
Pursuing a bachelor's or master's degree in Data Analytics, Business Analytics, Information Systems, Computer Science, or a related field
Strong analytical and problem-solving skills
Familiarity with Power BI, Excel, or other data visualization tools
Excellent communication skills, with the ability to explain technical findings clearly
Highly organized with strong attention to detail
Available to travel for the Internship Summit, hosted at a Zekelman Industries location
Preferred
Exposure to SQL, database connections, or data modeling preferred
Benefits
Low-cost, high-quality medical and dental benefits
Tuition assistance program
Bonus plan
401(k) plan with a generous company match
Immediate vesting
Company-wide networking events
Team-building activities
Learning sessions
Regular coaching and feedback
Company
Zekelman Industries
Zekelman Industries is an independent steel tubular manufacturer.
Founded in 1877
1001-5000 employees
H1B Sponsorship
Zekelman Industries has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (2)
2023 (2)
2022 (4)
2021 (1)
2020 (2)
Funding
Current Stage
Late StageLeadership Team
B
Barry M Zekelman
Chief Executive Officer
James Hays
President - Electrical
Recent News
Company data provided by crunchbase