Gtsgbu

ALM Scripting & Reporting Intern

Toronto · Intern · Internship

Sponsorship not specified$23k-$30kDetected 50 days ago

PythonPowerShellSQLData VisualizationUX DesignCustomer SupportCommunicationMentoringOrganizational Skills

About the role

With operations in every corner of the world, our work goes to the cutting-edge of digital transformation and technology.
From the multi-cultural strength of our global organisation to the sustainable and innovative ways we work to bring people together, there's something for everyone to get stuck into.
While the primary focus of this role is Business Intelligence, the successful candidate will also allocate time toward exploring and implementing AI-driven solutions to enhance operational efficiency.

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.
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.
When available, develop prototypes of Power BI Reports based on defined requirements.

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.
Provide technical support on Power BI and UI/UX design, as required.
Required Skills and Experience
The ideal candidate will be:

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 G itHub Copilot.
Knowledge of UI/UX principles and a strong analytical mindset focused on data transparency.
Able to work full time (40 hours) for the agreed work term with a minimum of 2 days (16 hours) in the Toronto office

We welcome and value differences in background, age, gender, sexuality, family status, disability, race, nationality, ethnicity, religion, and world view.

A career at Hitachi Rail will help create a legacy. With operations in every corner of the world, our work goes to the cutting-edge of digital transformation and technology. From the multi-cultural strength of our global organisation to the sustainable and innovative ways we work to bring people together, there's something for everyone to get stuck into. And that's where you come in.
Toronto, Ontario, Canada (Hybrid)
Job Title: Data and Business Intelligence Analyst, Intern
Rail Pass Type: Internship/Co-op (Full-time/Hybrid)
Holiday Party, Employee BBQs, Golf tournament, etc.
The Data and Business Intelligence Analyst (Intern) will drive data-driven decision-making by supporting the end-to-end lifecycle of Power BI reporting and data modeling.
While the primary focus of this role is Business
Intelligence, the successful candidate will also allocate time toward exploring and implementing AI-driven solutions to enhance operational efficiency.
This role requires a strong technical foundation, an eye for modern
design, and a commitment to "Glass Box" reporting-ensuring data transparency and clear logic for all stakeholders.
A career at Hitachi Rail will help create a legacy.
And that's where you come in.

This listing is sourced directly from Gtsgbu's careers page and normalized into a canonical job model.