About the role#
The Data and Business Intelligence Analyst intern will support data-driven decision-making through the end-to-end lifecycle of Power BI reporting and data modeling. This role focuses on building transparent, logical reporting solutions while exploring AI-driven workflows to improve operational efficiency. The position is a 12-month, full-time commitment running from September 2026 to August 2027.
What you'll do#
- Support end-to-end BI development by defining requirements and creating functional Power BI prototypes and production-ready reports.
- Build and maintain robust semantic models using Python, SQL, Power Query, and DAX.
- Manage and configure Row-Level Security and evaluate Object-Level Security for sensitive data models.
- Apply modern design patterns and the Hitachi Rail Power BI Toolkit to create intuitive, user-friendly reports.
- Analyze datasets for usability and propose methods to improve data integrity.
- Document data processing steps, manage report testing, and host gate reviews for production releases.
- Contribute to AI and automation initiatives by building agentic workflows.
What you'll need#
- Currently in the 4th or 5th year of a Computer Science, Software Engineering, or IT program.
- 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 familiarity with Python for data processing, scripting, or automation.
- Knowledge of UI/UX principles and an analytical mindset.
- Familiarity with development environments like VS Code and AI-assisted coding tools.
- Strong organizational skills with the ability to balance multiple priorities.
- Excellent written and oral English communication skills.
Location & details#
- Location: 100 Consilium Place, Scarborough, Ontario, Canada.
- Modality: Hybrid, with a minimum of 2 days (16 hours) per week in the office.
- Schedule: Full-time (40 hours per week).
- Term: September 2026 to August 2027.
