ALM Scripting & Reporting Intern

Data and Business Intelligence Analyst, Intern

Location: Toronto, Ontario, Canada (Hybrid) – 100 Consilium Place, Scarborough, ON M1H 3E3.

Duration: September 2026 – August 2027 (12 months).

Work hours: 40 hours per week.

Pay: $23–$30 CAD hourly.

Key Responsibilities

• End-to-End BI Development: Support colleagues across all disciplines in defining requirements and develop functional Power BI prototypes and production-ready reports.
• Data Modeling & Engineering: Build and maintain robust semantic models for both BI and AI applications using Python, SQL, Power Query and/or DAX.
• Security Implementation: Manage and configure Row-Level Security (RLS) and evaluate Object-Level Security (OLS) for sensitive data models.
• UI/UX & Design: Champion the adoption and utilization of the Hitachi Rail Power BI Toolkit. Apply modern design patterns to create intuitive, user-friendly reports, and actively contribu...