Data Engineering Specialist
SYSTRA•Toronto, ON
•CA$90,000 - CA$130,000
About The Position
SYSTRA Canada is seeking a Data Engineering Specialist for the Go Expansion program, as part of the MCS Delivery Partner Consortium. SYSTRA Canada is an engineering and consulting firm focused on transportation solutions, including feasibility studies for new railway lines, increasing existing infrastructure capacity, and railway privatization. The Data Engineering Specialist will play a key role in data transformation, architecture, management, and analytics to support client goals and operational excellence.
Requirements
- Bachelor’s degree in Computer Engineering, Data Science, or related discipline.
- Proficiency in Power BI, Tableau, and SQL, including data modeling, visualization, and report development.
- Proficiency in ETL processes, data governance, and data integrity.
- Proficiency in Advanced Excel, Power Query, DAX, and Python for analytics.
- Proficiency in Microsoft Fabric, Power Platforms, Data Marts, Synapse Pipelines, and Azure cloud solutions.
- 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.
Nice To Haves
- Master’s degree preferred.
- CSM, ITIL V4 certifications.
- Certifications in tools like Microsoft SQL Server, Tableau, AWS, Azure, or GCP.
- Experience in transit, transportation, or infrastructure domains.
- Skills in Macros and coding.
- Familiarity with Microsoft SharePoint, SQL, Primavera P6, and Earned Value Management software.
Responsibilities
- 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.
- Collaborate closely with multidisciplinary teams to foster a high-performing and collaborative environment.
- Provide input to enhance team capabilities and support continuous learning initiatives.
- 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.
- 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.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
