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