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 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].