About the Role
SYSTRA Canada is seeking a Data Engineering Specialist for the Go Expansion program within the MCS Delivery Partner Consortium. This role involves assisting the Data Science Manager, contributing to data transformation, and supporting strategic data management roadmaps.
Responsibilities
- Assist the Data Science Manager in achieving objectives.
- Contribute to data transformation efforts, including data engineering and reporting applications.
- Support the development and execution of strategic roadmaps for data management and mobilization.
- Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment.
- Provide input to enhance team capabilities and support continuous learning initiatives.
- Ensure scalable and flexible data architecture to achieve operational excellence and data reliability.
- Participate in creating and maintaining a data dictionary and catalog.
- Support efforts to address data debt by optimizing data structures and introducing robust management practices.
- Apply data modeling expertise to design and optimize data structures for efficient storage, retrieval, and analysis.
- Collaborate with cross-functional teams to gather, analyze, and model datasets, translating data requirements into actionable insights.
- Support the development of advanced reporting strategies using data engineering tools to enhance efficiency.
- Assist in building ecosystems for self-analytics enablement, providing training and fostering informed decision-making.
Requirements
- Bachelor’s degree in Computer Engineering, Data Science, or related discipline; Master’s degree preferred.
- CSM, ITIL V4, and certifications in tools like Microsoft SQL Server, Tableau, AWS, Azure, or GCP.
- Proficiency in Power BI, Tableau, and SQL, including data modeling, visualization, and report development.
- Proficiency in ETL processes, data governance, and data integrity.
- Proficiency in Advanced Excel, Power Query, DAX, and Python for analytics.
- Proficiency in Microsoft Fabric, Power Platforms, Data Marts, Synapse Pipelines, and Azure cloud solutions.
- Experience in transit, transportation, or infrastructure domains is advantageous but not mandatory.
- Strong problem-solving and analytical skills with a results-oriented mindset.
- Substantial experience with project control tools and dashboarding software.
- Expertise in Microsoft Power BI, Word, Excel, PowerPoint, and Visio, with skills in Macros and coding as a plus.
- Familiarity with Microsoft SharePoint, SQL, Primavera P6, and Earned Value Management software is a plus.
Skills
- Data Engineering
- Reporting Applications
- Data Management
- Data Mobilization
- Data Architecture
- Data Governance
- Data Integrity
- Data Modeling
- Data Analysis
- Power BI
- Tableau
- SQL
- ETL
- Advanced Excel
- Power Query
- DAX
- Python
- Microsoft Fabric
- Power Platforms
- Data Marts
- Synapse Pipelines
- Azure Cloud Solutions
- Project Control Tools
- Dashboarding Software
- Microsoft Word
- Microsoft PowerPoint
- Microsoft Visio
- Macros
- Coding
- Microsoft SharePoint
- Primavera P6
- Earned Value Management
Location
- Canada
Work Type
- Full-time
Experience Level
- Specialist
Education Level
- Bachelor's degree
- Master's degree
Salary/Compensations
- CAD 90,000 - CAD 130,000 annually
About the Company
- 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.
Equal Opportunity
- 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.
