Data Analyst, Power BI

SYSTRA

Montreal

On-site

CAD 70,000 - 95,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

SYSTRA Canada is seeking a data analytics professional to manage and optimize project data across Power BI and Microsoft Fabric. You will design semantic models, dashboards, and dataflows to monitor performance and deliver actionable insights for major infrastructure initiatives.

Strong DAX/Power Query skills and bilingual French/English are essential. You will collaborate with stakeholders to define reporting needs, drive data quality, and ensure governance and compliance across our transport

Qualifications

  • Bachelor's degree in computer science, business intelligence, data analytics, statistics, business administration, or related field.
  • 2 to 3 years of experience in a similar role.
  • Proficiency with Microsoft Fabric and Power BI for analytics workflows.
  • Strong knowledge of DAX and Power Query for data modeling, cleansing, transformation, and analytics.
  • Understanding of data governance and data quality principles.
  • Bilingual in French and English for collaboration with stakeholders.

Responsibilities

  • 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.

Skills

Microsoft Fabric
Power BI
DAX
Power Query
Data modeling
Data governance
Data quality
French-English bilingual

Education

Bachelor's degree in Computer Science / BI / Data Analytics / Statistics / Business Administration

Tools

OneLake
Dataflow Gen2
Data Factory
Notebooks

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: 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: 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 infocanada@systra.com.

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 Canada • Montreal

On-site
CAD 65,000 - 90,000
Senior Transport Economist
Senior Transport Economist

SYSTRA • Montreal

On-site
CAD 90,000 - 130,000
Senior Analyst, Geographic Information System (GIS)
Senior Analyst, Geographic Information System (GIS)

SYSTRA • 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
Senior Transportation Economist — Strategic Economic Analysis
Senior Transportation Economist — Strategic Economic Analysis

SYSTRA • Montreal

On-site
CAD 90,000 - 130,000
Senior Analyst, Geographic Information System (GIS)
Senior Analyst, Geographic Information System (GIS)

SYSTRA Canada • Montreal

Hybrid
CAD 90,000 - 130,000
Design Planning Manager - Alto Project
Design Planning Manager - Alto Project

SYSTRA • Montreal

On-site
CAD 120,000 - 160,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
Quality Coordinator – ALTO project / Cadence
Quality Coordinator – ALTO project / Cadence

SYSTRA • Montreal

Hybrid
CAD 60,000 - 90,000