Analyst, Business Intelligence
- Montreal, QC, H3K 3K2, Canada
Annual Salary / Hourly Rate : $80,108 - $100,135
Applications open in a new tab.
Job details
- Pay
- Annual Salary / Hourly Rate : $80,108 - $100,135
- Apply by
- Posting language
- English
- Posted
Original job description
Reference Number : 1480
Status : Permanent - Full-time
Annual Salary / Hourly Rate : $80,108 - $100,135
Number of positions to be filled : 1
Application Deadline : 10/31/2026
Did you know that VIA Rail is carrying out ambitious projects to modernize its services and infrastructure? From our new ultramodern train fleet to ongoing improvement of our infrastructure, we’re building the future of transportation in Canada. Working for VIA Rail is being a part of a collective effort in sustainable mobility.
Why VIA Rail?
We’re proud to offer a workplace that reflects the diversity and inclusivity of Canadian society. At VIA Rail, you’ll enjoy:
- Competitive Compensation & Benefits
- Excellent Pension Plan & Bonus Program
- Generous Vacation, Parental, and Personal Leave
- Hybrid Work Options (role-dependent)
- Unlimited Access to Telemedicine Services
- Comprehensive Health & Wellness Coverage
- Train Travel Privileges for You and Your Family
- Career Development & Training Opportunities
- Commitment to Equity, Diversity & Inclusion
- Participation in Social Initiatives & Employee Resource Groups
POSITION
The BI Business Analyst will be responsible for managing the data aiming the optimization of business processes that impact reliability, business efficiency and passenger services. He will use their advanced data analysis and process modelling/optimization skills to properly target needs and identify plans for continuous improvement. The BI Business Analyst will help implement proven analytical methodologies to increase the maturity level of business analysis practices. They will also use the right tools and techniques to provide various stakeholders with information (visuals, KPI, reports, dashboards, etc.) when recommending and promoting business solutions that meet the company’s needs.
RESPONSIBILITIES
Production
- Contribute to the continuous improvement of data collection and quality-related processes;
- Develop and implement strategies and monitoring measures (IP and KPIs);
- Review and improve data governance to support the established business rules, flows and processes;
- Make complex information and abstract concepts accessible for all levels of management, from the supervisor to the president;
- Group data from several sources to provide a complete operational profile;
- Develop and execute database queries (SQL);
- Work with the IT department to manage the data analysis platform while ensuring the integrity of data, including data extraction, storage, handling, processing and analysis.
Analysis
- Evaluate and improve existing BI reports and dashboards;
- Understand the company and the user’s needs to propose appropriate data solutions;
- Ensure the proper management of technical documentation;
- Respond to ad-hoc requests for information and statistics from the BI system;
- Urge the department towards innovative solutions, like artificial intelligence;
- Establish the best performance indicators for various business units.
Support
- Provide support to managers when validating reports and data;
- Help transition on-site data sources to cloud-based sources;
- Provide technical assistance to users during report generation;
- Create and support innovations that impact the Power Platform;
- Work with our information systems team when integrating data into our BI system.
WHAT WE ARE LOOKING FOR
- University degree in engineering, operations management, computer science, or equivalent (Master's degree an asset);
- 5+ years experience in a BI or similar role;
- 2 years experience with Microsoft data analysis tools (Power BI, Azure Analytics, etc.);
- Experience in a production field (maintenance and railway an asset);
- Knowledge of on-site and cloud-based infrastructures;
- Advanced programming skills with Python (asset) or R, DAX, Power Query, SQL and Spark (asset);
- Knowledge of Office 365 and Power App an asset;
- Knowledge or understanding of artificial intelligence (RPA, machine learning, etc.);
- Excellent communication skills;
- Must be able to read and write in French and English;
- Data and performance-oriented thinking;
- Change management experience;
- Experience in unionized environments (asset).
At VIA Rail, we are proud to be an employment-equity employer and we strive to form teams that reflect the diversity of Canadian society. We aim to remove barriers to employment accessibility and aspire to provide an inclusive and equitable work environment where everyone is valued, regardless of their identity or differences, to enable them to reach their full potential.
If you need assistance in making the recruitment process or the position you are applying for more accessible, please let us know. Alternate arrangements may be offered to individuals who request them at any stage of the recruitment process. All information received in relation to arrangements will be kept confidential.
Note that we will only contact those who are selected for an interview.
Join our 3,000 other employees in helping provide Canadians with a safe, accessible, environmentally sustainable way to travel!
More about this job
Responsibilities
The BI Business Analyst manages data to optimize business processes, reliability, and passenger services. They develop analytical methodologies, create dashboards, and provide actionable insights to stakeholders across the organization.
Requirements
Candidates must hold a university degree in engineering, computer science, or a related field and possess at least 5 years of experience in a BI role. Proficiency in Microsoft data tools, SQL, and advanced programming languages like Python or R is required.
Skills
- Business intelligence
- Data analysis
- Process modeling
- SQL
- Power BI
- Azure Analytics
- Python
- R
- DAX
- Power Query
- Spark
- Data governance
- KPI development
- Artificial intelligence
- Change management
- Communication skills
Benefits
- Competitive compensation
- Pension plan
- Bonus program
- Generous vacation
- Parental leave
- Personal leave
- Hybrid work options
- Telemedicine services
- Health and wellness coverage
- Train travel privileges
- Career development
- Training opportunities
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Transportation
- Software
- Engineering
Keywords
- Business Intelligence
- Data Analysis
- SQL
- Power BI
- Azure Analytics
- Python
- R
- DAX
- Power Query
- Spark
- Data Governance
- KPI
- Artificial Intelligence
- Machine Learning
- RPA
- Power Platform
- Cloud Infrastructure
- Database Queries
- Process Optimization
- Change Management
- Railway
- Maintenance
- Operations Management
- Data Integrity
- Dashboarding
- Reporting
- Information Systems
- Data Extraction
- Business Analysis
- Sustainable Mobility