Data Engineering Specialist - Toronto - ref. v19744219
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:
This role will support the client on Go Expansion Program.
Missions/Main Duties:
Key Accountabilities & Responsibility- Data Science and Strategic Support
o Assist the Data Science Manager in achieving objectives.
o Contribute to data transformation efforts, including data engineering and reporting applications to align with client goals.
o Support the development and execution of strategic roadmaps for data management and mobilization.- Collaboration and Teamwork
o Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment.
o Provide input to enhance team capabilities and support continuous learning initiatives.- Data Architecture and Management
o Ensure scalable and flexible data architecture to achieve operational excellence and data reliability.
o Participate in creating and maintaining a data dictionary and catalog.
o Support efforts to address data debt by optimizing data structures and introducing robust management practices.- Analytics and Insights
o Apply data modeling expertise to design and optimize data structures for efficient storage, retrieval, and analysis.
o Collaborate with cross-functional teams to gather, analyze, and model datasets, translating data requirements into actionable insights.- Reporting and Analytics Enablement
o Support the development of advanced reporting strategies using data engineering tools to enhance efficiency.
o Assist in building ecosystems for self-analytics enablement, providing training and fostering informed decision-making.
Profile/Skills:
Technical Competencies Required- 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.
- 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.