Data Analyst, Power BI

Systra; Montreal (administrative region); On-site; CAD 75,000 - 110,000; Full time

Job summary

SYSTRA Canada is seeking a data analytics professional to design, implement, and optimize reporting solutions across the Power Platform. The role focuses on building semantic models, dashboards, and data pipelines to support transportation projects, including large-scale infrastructure initiatives.

You will collaborate with stakeholders in French and English, ensuring data governance and high-quality analytics that inform decision-making. Montreal-based, hybrid work options may apply.

Qualifications

• Bachelor’s degree in computer science, BI, data analytics, statistics, business administration, or related field.
• 2–3 years of experience in a similar role.
• Experience with Power BI and Microsoft Fabric for dashboards and reporting.
• Strong command of DAX and Power Query for data modeling and analytics.
• Knowledge of data governance and data quality principles.

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 Fabric to monitor performance and generate insights.
• Work with stakeholders to define reporting needs and deliver effective solutions.
• Maintain documentation and ensure governance, security, and regulatory compliance.

Skills

Data modeling

DAX

Power Query

Data governance

French-English bilingual

Education

Bachelor’s degree in Computer Science, BI, Data Analytics, Statistics, or related field

Tools

Microsoft Power BI

Microsoft Fabric

Notebooks

Data Factory

OneLake

Dataflow Gen2

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 [e-mail].