Data Engineering Specialist

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 .

We are looking for a Data Engineering Specialist for the Go Expansion program as part of the MCS Delivery Partner Consortium.

• 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

• Educational and Professional Background
• Education: Bachelors degree in Computer Engineering Data Science or related discipline; Masters 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 90000 - CAD 130000 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