Senior Data Analyst

SYSTRA; Toronto; On-site; CAD 125,000 - 150,000; Full time

Job summary

A leading consulting firm in Toronto is seeking an experienced Data Analyst to support data management, analysis, and insights. The role involves automating processes using Power Automate, conducting data analytics tasks with Power BI, and managing ETL pipelines with Python. Candidates should have a strong background in data visualization and a degree in a relevant field, along with a collaborative spirit and communication skills. This position promises a dynamic environment focused on transportation solutions.

Benefits

Diverse and inclusive workforce

Equal Opportunity Employer

Qualifications

• 3-4 years’ experience for Bachelor's or 1-2 years for Master's in data field.
• Strong background in data management, analysis, and visualization.
• Proficiency in Python, DAX, PowerBI, and GIS platforms.

Responsibilities

• Implement and leverage Power Automate for data management.
• Collaborate on data transformation and analytics.
• Support the development of data engineering metrics dashboards.

Skills

Python

DAX

PowerBI

GIS platforms

Data management

Data analysis

Problem-solving

Attention to detail

Education

Bachelor's degree in data related domain

Master's degree in related field

Tools

EtL tools

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.

Understand better who we are by visiting www.systracanada.com.

Context

We are seeking an experienced Data Analyst to join our team. The Data Analyst will play a vital role in data management, analysis, insights, GIS, and power app automation. The successful candidate will assist the Data Science Manager in tasks related to data transformation, data analytics, PowerBI Datamart, Dataflow, and GIS story map development. The data analyst will have the opportunity to work on data engineering tasks with focus on Extract, Transform, and Load (ETL) processes using Python and Power BI Query.

Missions/Main Duties

Key Responsibilities

• Implement and leverage Power Automate to automate processes and ensure proper data management practices by automating workflows.
• Collaborate with the team in various data management tasks, including data transformation, data analytics, PowerBI Datamart, and DataFlow.
• Assist in maintaining data catalog, business glossaries, and data dictionaries to ensure data consistency, integrity, and standardization.
• Support the development and maintenance of data engineering metrics dashboards and data mobilization dashboards to monitor data performance effectively.
• Utilize Python, DAX, PowerBi, and GIS platforms proficiently to conduct data analysis and derive meaningful insights.
• Collaborate with cross-functional teams to perform data analytics tasks and provide valuable insights for data-driven decision-making.
• Create and develop script to manage ETL pipelines using Python and Power BI to efficiently collect and process data from various sources.
• Work with Data Science Manager on addressing existing data debts within the current systems to improve data accuracy and reliability
• Participate in the creation of insightful Data About Data visualizations using Power BI, enabling an understanding of as-is, to-be, and in-progress data assets
• Create content and conduct training sessions for various teams and communicate effectively with different users and provide support in order to transform the program into self-analytics ecosystem.
• Develop and work on GIS Storymaps, utilizing geographical information to support compelling data visualizations and insights
• Provide technical support and assure data governance by managing access security and apply row level security.

Profile/Skills

Requirements

• Bachelor's (with at least 3-4 years’ experience) or Master's degree with (with at least 1-2 years’ experience) in data related domain, computer science, statistics, or a related field.
• Proven experience as a Data Analyst, with a strong background in data management, analysis, and visualization.
• Proficiency in Python, DAX, PowerBi, and GIS platforms, showcasing the ability to handle complex data-related tasks.
• In-depth knowledge of data cataloging, business glossaries, and data dictionaries, ensuring data accuracy and adherence to best practices.
• Strong problem-solving skills and keen attention to detail, ensuring accurate and actionable data insights.
• Excellent communication and interpersonal skills, enabling effective collaboration with team members and stakeholders.
• Strong team spirit and a positive attitude, fostering a collaborative and supportive work environment.
• Strong knowledge of data structures and data modeling concepts.
• Familiarity with ETL processes and tools, with proficiency in Python and Power BI being advantageous.
• Detail-oriented and highly organized, with a keen eye for data accuracy and quality.
• Strong problem-solving and analytical skills.
• Self-motivated and eager to learn about data engineering and data science practices.
• Excellent communication and teamwork abilities.
• Puts team success above own interests.

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.