Developer Analyst Intern

Zekelman Industries


Date: 9 hours ago
City: Troy, MI
Contract type: Full time
You may not know our name, but you know our products. What we make is part the places where we live, work and play – all day, everyday.

Zekelman is a family of companies — 100% domestic manufacturers — with a legacy dating back to 1877. We’re proud to be the largest independent steel pipe and tube manufacturer in North America and the leading innovator in multi-family housing development.

We believe in what we build and what we build, builds the world around us. Hospitals, hotels, schools, bridges, airports and more.

Come build a career you believe in.

About The Role

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.

What You’ll Do

  • 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.

Who You Are

  • 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.

What You’ll Get

Zekelman Industries offers a PAID internship experience with meaningful work, professional development, and the opportunity to make a real impact. Interns also enjoy:

  • 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.

Zekelman Industries offers competitive compensation and excellent benefits, including low-cost, high-quality medical and dental benefits.  In addition, we have an amazing tuition assistance program, a bonus plan, a 401(k) plan with a generous company match, immediate vesting, and much more.

M/F/D/V

We are Zekelman Industries.

We manufacture superior quality tubular and related products, and provide outstanding service for our valued customers.

We seek to continuously advance the skills and opportunities of our employees, utilizing the latest technology and management tools available to consistently increase profitability and the enterprise value of Zekelman Industries and of our customers.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume