Senior Data Analyst
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
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 .
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
- Bachelors (with at least 3-4 years experience) or Masters 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.
Salary range for this role is between CAD 90000 - CAD 120000.
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 .
Required Experience:
Senior IC
Key Skills
- Databases
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
