Data Analyst, Power BI

SYSTRA Canada

Montreal

On-site

CAD 65,000 - 90,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

SYSTRA Canada, part of the SYSTRA group, is seeking a BI/Data Analytics professional in Montreal to manage and standardize project data for the ALTO initiative. You will develop data processes and automate workflows across the Microsoft Power Platform to support decision making.

The role focuses on building dashboards and semantic models in Power BI and Fabric, using DAX and Power Query. You will collaborate with stakeholders, document governance, and ensure data quality while communicating in

Qualifications

  • Bachelor's degree or equivalent in a related field.
  • 2 to 3 years of experience in a similar role.
  • Experience with Power Platform and BI tooling is required.

Responsibilities

  • Manage, structure, analyze, and standardize project data to support business and user requirements.
  • Develop and automate data processes and optimize tools across Power Platform.
  • Build and maintain dashboards, dataflows, and semantic models in Power BI and Fabric.
  • Collaborate with stakeholders to define reporting needs and deliver effective solutions.
  • Maintain documentation and ensure governance and data quality.

Skills

Bilingual (French & English)

Education

Bachelor's degree in computer science / BI / data analytics

Tools

Microsoft Fabric
OneLake
Dataflow Gen2
Data Factory
Notebooks
Power BI
DAX
Power Query
Data governance

Job description

SYSTRA Canada is part of the SYSTRA group, an international consulting and engineering group, a world leader in the design of transport infrastructures. SYSTRA Canada is an engineering and consulting firm whose primary focus is to offer transportation solutions, whether for passengers or goods: feasibility studies of building a new railway line, increasing the capacity of the existing infrastructure, privatization of a railway.

Context

The ALTO project is a major infrastructure initiative in Canadian history, aimed at developing over 1,000 km of new passenger rail service between major urban centers, including Toronto, Ottawa, Montreal and Quebec City.

Missions/Main Duties
  • Manage, structure, analyze, and standardize project data to support business and user requirements.
  • Develop and automate data processes and optimize tools across the Microsoft Power Platform ecosystem to improve efficiency and data quality.
  • Build and maintain dashboards, visualizations, dataflows, and semantic models in Power BI and Microsoft Fabric to monitor performance and generate insights.
  • Work with stakeholders to define reporting needs, deliver effective solutions, and support informed decision-making.
  • Maintain documentation and ensure compliance with governance, security, and regulatory requirements.
Profile/Skills
Education

Education: Bachelor’s degree in in computer science, business intelligence, data analytics, statistics, business administration, or a related field. An equivalent combination of education and relevant experience may be considered.

Years of experience

Years of experience: 2 to 3 years of experience in a similar role.

Technical Skills
  • Experience with Microsoft Fabric, including OneLake, Dataflow Gen2, Data Factory, and Notebooks, for data ingestion, storage, organization, transformation, and orchestration of analytics workflows.
  • Proficiency in Microsoft Power BI and Microsoft Fabric to design, maintain, and optimize semantic models, dashboards, and reporting solutions.
  • Strong command of DAX and Power Query for data modeling, extraction, cleansing, transformation, and advanced analytics.
  • Solid understanding of data modeling, data governance, and data quality principles.
  • Ability to communicate clearly both verbally and in writing, in French and English*
  • Reasons for the bilingual requirement: You will have the opportunity to collaborate with various project stakeholders; bilingualism is essential for building strong relationships with our clients, understanding their specific needs, and communicating effectively in their preferred language.
Interpersonal Skills
  • Analytical mindset, rigor, and autonomy
  • Ability to work in an agile and collaborative environment
  • Strong technical communication skills.

SYSTRA Canada is committed to having a diverse and inclusive workforce. We are an Equal Opportunity Employer that values applications from all and offers employment equity based on the merits and abilities of candidates and personnel.

Note: In this description, the masculine gender is used for easy reading purposes and includes the feminine.

We use AI-enabled tools in our recruitment platform (iCIMS) for tasks like resume parsing and candidate matching. These tools do not make hiring decisions; all applications are reviewed by a human recruiter, and final decisions are made by our hiring team.

For questions about our hiring process or AI tools, please contact [email protected].

Workplace Type

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst, Power BI
Data Analyst, Power BI

SYSTRA • Montreal

On-site
CAD 70,000 - 95,000
Senior Analyst, Geographic Information System (GIS)
Senior Analyst, Geographic Information System (GIS)

SYSTRA Canada • Montreal

Hybrid
CAD 90,000 - 130,000
MBSE & Digital Twin Specialist (Internship) - ALTO project / Cadence
MBSE & Digital Twin Specialist (Internship) - ALTO project / Cadence

SYSTRA • Montreal

Hybrid
CAD 85,000 - 120,000
Hydrology Specialist – ALTO
Hydrology Specialist – ALTO

SYSTRA Canada Inc. • Montreal

On-site
CAD 120,000 - 150,000
Project Engineering Coordinator - ALTO project / Cadence
Project Engineering Coordinator - ALTO project / Cadence

SYSTRA • Montreal

Hybrid
CAD 55,000 - 75,000
Commercial Specialist – ALTO project / Cadence
Commercial Specialist – ALTO project / Cadence

SYSTRA • Montreal

Hybrid
CAD 80,000 - 110,000
Design Planning Manager – Alto Project
Design Planning Manager – Alto Project

SYSTRA • Montreal

On-site
CAD 110,000 - 160,000
Commercial Specialist - ALTO project / Cadence
Commercial Specialist - ALTO project / Cadence

SYSTRA • Montreal

Hybrid
CAD 85,000 - 115,000
Design Planning Manager – Alto Project
Design Planning Manager – Alto Project

SYSTRA Canada Inc. • Montreal

On-site
CAD 110,000 - 140,000
Spécialiste MBSE et jumeau numérique (stage) - projet ALTO / Cadence
Spécialiste MBSE et jumeau numérique (stage) - projet ALTO / Cadence

SYSTRA • Montreal

Hybrid
CAD 90,000 - 120,000