Data Analyst, Power BI

SYSTRA Canada; Montreal (administrative region); On-site; CAD 55,000 - 85,000; Full time

Job summary

SYSTRA Canada is seeking a BI/Data Analytics Engineer to drive data projects, build dashboards, and optimize analytics workflows using Power BI and Microsoft Fabric. You will partner with stakeholders to deliver insights, ensure data quality, and maintain governance across the Power Platform ecosystem.

Ideal candidates have 2–3 years of experience, strong DAX/Power Query skills, and bilingual English/French communication for collaboration with multiple project teams in Montreal and beyond.

Qualifications

• Bachelor’s degree in a relevant field or equivalent experience.
• 2 to 3 years in a similar BI/data analytics role.
• Strong communication in French and English is required.

Responsibilities

• Manage, structure, analyze, and standardize project data.
• Develop and automate data processes within Power Platform.
• Build dashboards and semantic models in Power BI and Fabric.
• Collaborate with stakeholders to define reporting needs.
• Maintain governance and data quality documentation.

Skills

Power BI

Microsoft Fabric

DAX

Power Query

Data modeling

Bilingual French/English

Data governance

Education

Bachelor’s degree in Computer Science/BI/Data Analytics

Tools

OneLake

Dataflow Gen2

Notebooks

Data Factory

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 [email protected].