Data Analyst, Power BI

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 One. Lake, 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. 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.

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

Lake, 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.