ALM Scripting & Reporting Intern (Ontario)

ALM Scripting & Reporting Intern (Ontario)

03 Aug
|
Hitachi Automotive Systems Americas
|
Ontario

03 Aug

Hitachi Automotive Systems Americas

Ontario

Location: Toronto, Ontario, Canada Job ID: R1012816 Date Posted: 2026-07-07 Company Name: Hitachi Rail Canada Inc. Profession (Job Category): Administration & Facilities Job Schedule: Full time Remote: No
About Us 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.
Job Description: Job Title: Data and Business Intelligence Analyst, Intern Rail Pass Type: Internship/Co-op (Full-time/Hybrid) Departure and Arrival Date (Start -End): September 2026 - August 2027 (12months) Vacancy: 1 Location: 100 Consilium Place, Scarborough, ON M1H 3E3 Work hours/week: 40 Pay Details: $23-$30 CAD hourly
Stations on Your Journey:
Welcome and Onboarding Station Intern Orientation Online Onboarding Curriculum Buddy Program for mentorship and guidance
Hands-On Work Station Real-world projects with top industry talent Paid internship + paid vacation Hybrid work model A chance to build your career with a global leader driving digital transformation and innovation that helps support sustainable future
Networking Station “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.
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.
Key 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 contemporary 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.
Required Skills and Experience 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 Skills and Experience Experienced in data processing scripting and automation using Python, Powershell and/or SQL
Thank you for your interest in Hitachi Rail. If your application is of interest, we will be in contact. Please do not hesitate to discover more about us and our latest jobs at https://www.hitachirail.com/careers.
At Hitachi Rail, there is a place for everyone. 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.
We would be delighted if you would be one of our followers at https://www.linkedin.com/company/hitachirail. Hitachi brings together the world’s greatest minds to help breathe life into new possibilities – and drive innovation for a better future. That’s why we look for individuals who share our pioneering spirit, have imaginative ideas and are fearless when it comes to tackling the world’s biggest challenges. Our people love technology – and they love making a difference. They have a passion for finding new solutions and working with brilliant colleagues. Every day they dedicate themselves to a huge range of exciting projects, contributing to the Hitachi vision around the globe. From engineering new sustainability solutions that conserve water and energy to creating the infrastructure for the smart cities of tomorrow, there’s no challenge too great for our pioneers. And there’s no shortage of opportunities for you to make a difference. Come and experience the dynamic, collaborative and creative environments where your ideas are welcome and new discoveries are waiting. To help you grow to your full potential, we strive to support our employees in their career aspirations and promote the freedom to explore new horizons.
E-mail us for data privacy inquiries or technical support.

#J-18808-Ljbffr

📌 ALM Scripting & Reporting Intern (Ontario)
🏢 Hitachi Automotive Systems Americas
📍 Ontario

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: alm scripting & reporting intern (ontario) / ontario

Subscribe to this job alert:

Get the latest job offers by email for: alm scripting & reporting intern (ontario) / ontario