Via rail Logo

Job Title :
BI Architect
Reference Number :
Status :
Permanent - Full time
Job Category :
Information Technology
City :
Province :
Annual Salary / Hourly Rate :
96886 - 113983
Number of positions to be filled :
Application Deadline :
Reporting to the Director, Corporate Architecture, the BI architect plays a key role in designing solutions and ensuring these solutions meet business needs and align with corporate commercial objectives. BI architects must comply with enterprise architecture guidelines and principles, as well as IT operating standards, including the security component.

The incumbent leads and supports a project team from the selection to the implementation of a solution, and acts as a point of contact for all matters pertaining to the solution as a whole.

As a member of the Corporate Architecture team, the BI architect participates in defining standards (rankings) and architectural patterns according to their field of expertise (application, information, technologies or security).

More specifically, the business intelligence architect (including the data architecture component) is responsible for establishing a coherent overview of the enterprise-level BI architecture and the solutions architecture supporting data management services and analytics.

Tasks :

1- Participate in the analysis, design and planning of VIA Rail’s project phases for their area of expertise. Prepare and maintain the solution/system architecture documentation supporting project requirements and IT operations, including the drafting of requests for proposals.

2- Review and validate proposals from suppliers and participate in the selection of products and a solution.

3- Ensure the reuse and evolution of VIA Rail’s IT ecosystem (infrastructure and systems) by minimizing impacts and complexity. Identify and define architecture models in need of upgrading in their area of expertise.

4- Advise the other architects on the choice of implementation diagrams. Play a key role in breaking down the recommended solution subsystems, and then oversee their development and integration.

5- Work collaboratively with the other architects to provide a suitable business solution that is upgradeable, adaptable and synchronized with the company’s ever-changing needs.

6- Work with business and IT stakeholders on the definition of requirements, the design, performance and the modernization of infrastructure in line with the business’s overall technology architecture strategy.

University degree in computer science, computer engineering or equivalent.

A minimum of 10 years of experience in IT as an IT solution architect, including data and technology architecture covering analytics solutions design.

Hands-on experience working with DBMS Oracle and MS SQL Server as well as technologies supporting analytics and business intelligence (BI) on Microsoft platforms (Power BI Desktop,, SSIS, SSAS, SSRS, Power BI Report Server, etc.), including cloud platform services in the data and analytics field.

Experience working with data modelling tools and data management principles, as well as with various database types (relational, object-oriented, etc.) and information modelling techniques in a large enterprise context, including the data vault modelling method.

Good knowledge of recent technologies in BI and AI, such as NoSQL databases, data virtualization, in-memory data analysis, as well as their respective products and suppliers.

Knowledge of an architecture framework (TOGAF, SABSA, CBM-IT, etc.) and solution delivery methodology (Waterfall and/or Agile, e.g., SAFe 4.0) is considered an asset.

Competencies :

Works collaboratively with members of various teams. Promotes teamwork, provides constructive feedback, guides others and shares knowledge. Adopts internal partners’ perspectives to clarify their needs and deliver value.

Draws from a wide range of work practices to implement solutions to complex problems in a timely manner, using creativity where appropriate. Incorporates continuous improvements in day to day activities, keeping the customer in mind.

Excellent verbal and written communication skills in English and French. Ability to interact and negotiate with others. Initiates open and frank discussions on topics that are in the best interest of the organization. Explains concepts in a clear and logical manner.

Strong analytical skills, and ability to resolve problems and make decisions. Identifies priorities and works out the best ways to use available resources. Makes sound decisions after careful analysis using experience and judgment.

Takes a proactive approach, anticipating and addressing issues as they arise.
Provides expert advice in their discipline. Motivates others by demonstrating a high level of engagement.

VIA Rail thanks all applicants for their interest, however only those selected for an interview will be contacted. VIA Rail is an employment-equity employer and encourages all qualified candidates to apply. VIA Rail Canada is proud to be a military friendly employer.

Job Alert