Hitachi Rail is a global leader in digital transformation and technology. The Data and Business Intelligence Analyst Intern will support data-driven decision-making by driving the lifecycle of Power BI reporting and data modeling while also exploring AI-driven solutions to enhance operational efficiency.
Responsibilities
End-to-End BI Development: Supporting colleagues, across all disciplines, in defining requirements and develop functional Power BI prototypes and production-ready reports based on those use cases
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 contribute to the further development and expansion of the toolkit's assets
AI & Automation Initiatives: Contribute to building agentic workflows and propose innovative ideas where AI can be leveraged to improve operational efficiency within the BI function or broader engineering operations
Process & Quality Assurance: Documenting the data processing steps for Reports, manage testing and verification of reports, and prepare/host Gate Reviews for production releases alongside Data and Report Owners as required
Continuous Improvement: Analyze datasets for usability, propose methods to improve data integrity, and contribute to future initiatives such as developing version control processes for Power BI reports
Analyzing company datasets for usability and propose means to improve data integrity
Provide technical support on Power BI and UI/UX design, as required
When available, develop prototypes of Power BI Reports based on defined requirements
Qualification
Required
4th or 5th year in a Computer Science, Software Engineering, or IT program (Bachelor's or Master's) or equivalent experience
Strong presentation and communication skills, fluent in written and oral English
Demonstrated experience developing Power BI reports, including 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, ideally VS Code, and AI-assisted coding tools like GitHub Copilot
Knowledge of UI/UX principles and a strong analytical mindset focused on data transparency
Excellent organizational skills with the ability to balance multiple priorities in a hybrid work environment
Able to work full time (40 hours) for the agreed work term with a minimum of 2 days (16 hours) in the Toronto office
Fluent in English both in written and oral communication
Strong in organizational skills and their ability to balance multiple priorities
Preferred
Experienced in data processing scripting and automation using Python, Powershell and/or SQL
Benefits
Intern Orientation
Online Onboarding Curriculum
Buddy Program for mentorship and guidance
Real-world projects with top industry talent
Paid internship + paid vacation
Hybrid work model
"Ask Me Anything" with the Executive Committee
Employee Resource Groups (ERGs)
Social Intern Events: Coffee Breaks, Onsite/Offsite events
Business Intern Events: Intern Showcase & Graduation ceremony
Company Social Events: Holiday Party, Employee BBQs, Golf tournament, etc.
Hitachi Rail is a provider of rail solutions across rolling stock, signalling services and turnkey.
