Data and Business Intelligence Analyst, Intern (Fall 2026, …, Toronto

Job Title

Data and Business Intelligence Analyst, Intern Location

Toronto, Ontario, Canada (Hybrid) Duration

September 2026 - August 2027 (12 months) Overview

The Data and Business Intelligence Analyst (Intern) will support the end‑to‑end lifecycle of Power BI reporting and data modeling, and explore AI‑driven solutions to enhance operational efficiency. Responsibilities

Support colleagues across disciplines in defining requirements and developing functional Power BI prototypes and production‑ready reports. Build and maintain robust semantic models for BI and AI applications using Python, SQL, Power Query, and/or DAX. Manage and configure Row‑Level Security (RLS) and evaluate Object‑Level Security (OLS) for sensitive data models.Champion the use of the Hitachi Rail Power BI Toolkit and apply modern design patterns to create intuitive, user‑friendly reports. Contribute to AI and automation initiatives, building agentic workflows and proposing ideas to improve operational efficiency. Document data processing steps, manage testing and verification, and prepare/host gate reviews for production releases.Analyze datasets for usability, propose methods to improve data integrity, and contribute to version‑control processes for Power BI reports. Requirements

4th or 5th year student in Computer Science, Software Engineering, IT or equivalent experience. Strong presentation and communication skills fluent in written and oral English. Experience developing Power BI reports, proficiency in DAX and Power Query. Strong foundational knowledge of SQL or T‑SQL for data querying and transformation.Experience or strong familiarity with Python for data processing, scripting, or automation. Familiarity with modern development environments (e.g., VS Code) and AI‑assisted coding tools (e.g., GitHub Copilot). Knowledge of UI/UX principles and a strong analytical mindset focused on data transparency.Excellent organizational skills and ability to balance multiple priorities in a hybrid work environment. Availability to work full‑time (40 hours) for the full term, with a minimum of 2 days (16 hours) per week in the Toronto office. Fluency in English both written and oral. Preferred Skills

Experience in data processing scripting and automation using Python, PowerShell, or SQL. EEO Statement

At Hitachi Rail, we welcome and value differences in background, age, gender, sexuality, family status, disability, race, nationality, ethnicity, religion, and world view. It is our commitment to create an inclusive environment– we are proud to be an equal‑opportunity employer.

#J-18808-Ljbffr