Data and Business Intelligence Analyst, InternLocation: 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 ResponsibilitiesEnd-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 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: Document 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.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 Experience4th 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.Robust 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 organizational skills and ability to balance multiple priorities.Preferred Skills and ExperienceExperience in data processing scripting and automation using Python, PowerShell and/or SQL.Equal Opportunity Employer StatementAt 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.#J-18808-Ljbffr

📌 Alm Scripting & Reporting Intern - C$23 - C$30 An Hour (Winnipeg)
🏢 Hitachi Rail
📍 Winnipeg