Zekelman Industries-posted 2 months ago
Full-time • Intern
Troy, MI
1,001-5,000 employees

As a Developer Analyst Intern at Z Modular (a division of Zekelman Industries), you will design and refine an internal analytics tool that delivers meaningful insights into our active properties. You’ll work hands-on with data exports, visualization tools, and key performance metrics to build a reporting product that drives business decision-making in real estate and modular construction. You will report to the Analytics Manager and gain real-world experience building dashboards, validating KPIs, and documenting processes for end users. This is a full-time, on-site internship located at our Troy, MI facility. The official Zekelman internship program runs from May 26, 2026, through August 14, 2026. This role is perfect for someone who is analytical, detail-oriented, and motivated to turn raw data into working business solutions.

  • 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.
  • 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.
  • Exposure to SQL, database connections, or data modeling preferred.
  • 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.
  • PAID internship experience with meaningful work.
  • Professional development and the opportunity to make a real impact.
  • Hands-on experience building and refining an analytics product.
  • Practical exposure to Yardi, HelloData, and property-level KPIs.
  • Opportunities to test, validate, and improve data models in a real business environment.
  • Access to company-wide networking events, team-building activities, and learning sessions.
  • Regular coaching and feedback to support personal and professional growth.
  • Participation in a company-wide Intern Summit.
  • Competitive compensation and excellent benefits, including low-cost, high-quality medical and dental benefits.
  • Tuition assistance program, bonus plan, and a 401(k) plan with a generous company match.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service