:
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 looking for a Data Engineering Specialist for the Go Expansion program as part of the MCS Delivery Partner Consortium.
Missions/Main Duties:
- Data Science and Strategic Support
-
Assist the Data Science Manager in achieving objectives.
-
Contribute to data transformation efforts, including data engineering and reporting applications to align with client goals.
-
Support the development and execution of strategic roadmaps for data management and mobilization.
-
Collaboration and Teamwork
-
Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment.
-
Provide input to enhance team capabilities and support continuous learning initiatives.
-
Data Architecture and Management
-
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.
-
Analytics and Insights
-
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.
-
Reporting and Analytics Enablement
-
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
Profile/Skills:
- Educational and Professional Background
-
Education: Bachelor’s degree in Computer Engineering, Data Science, or related discipline; Master’s degree preferred.
-
Certifications: CSM, ITIL V4, and certifications in tools like Microsoft SQL Server, Tableau, AWS, Azure, or GCP.
-
Technical Expertise
-
Proficiency in:
-
Power BI, Tableau, and SQL, including data modeling, visualization, and report development.
-
ETL processes, data governance, and data integrity.
-
Advanced Excel, Power Query, DAX, and Python for analytics.
-
Microsoft Fabric, Power Platforms, Data Marts, Synapse Pipelines, and Azure cloud solutions.
-
Domain Knowledge
-
Experience in transit, transportation, or infrastructure domains is advantageous but not mandatory.
-
Analytical and Software Skills
-
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.
-
Additional Tools and Knowledge
-
Familiarity with Microsoft SharePoint, SQL, Primavera P6, and Earned Value Management software is a plus.
-
Salary Range
-
CAD 90,000 - CAD 130,000 annually
:
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].
