Zekelman Industries is looking to design and refine an internal analytics tool that delivers meaningful insights into their active properties, building a reporting product that drives business decision-making in real estate and modular construction.
Requirements
- Familiarity with Power BI, Excel, or other data visualization tools.
- Exposure to SQL, database connections, or data modeling preferred.
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).
Other
- 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.
- 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.
