Senior Data Engineer

Job Description
Metrolinx is connecting communities across the Greater Golden Horseshoe. Metrolinx operates GO Transit and UP Express, as well as the PRESTO fare payment system. We are also building new and improved rapid transit, including GO Expansion, Light Rail Transit routes, and major expansions to Toronto’s subway system, to get people where they need to go, better, faster and easier. Metrolinx is an agency of the Government of Ontario.
At Metrolinx, equity, diversity and inclusion are essential to living our values of serving with passion, thinking forward and playing as a team.
CPG’s workforce is made up of driven and dedicated professionals who care deeply about working together to deliver infrastructure and make a positive impact in our communities. Join us as we build a knowledgeable and collaborative team that courageously changes how transit projects will be delivered.
This role is accountable for the development of CPG Business Intelligence (BI) tools/applications that meet the needs of CPG management, project delivery teams, functional teams and other internal/external partners. The Senior Data Engineer is responsible for transforming data from source layer to presentation layer to develop dashboards and management reporting to support a data driven culture within CPG. This position reports into the Manager, Manager, Data Architecture and Analytics.
What will I be doing?

• Understand business requirements in BI & Analytics context, translate, refine and unify into technical reference architecture and design data solutions to transform raw data into meaningful insights
• Develop and test Data Analytics prototypes, proof of concepts, pilots and production builds for business improvement plans and business cases that aim to understand and improve on the performance and success metrics through the analysis, processing and reporting of data that is collected through business processes and systems
• Assist in development of data product roadmaps and delivery of full BI & Analytics solution lifecycle including design, development, implementation of new data solutions, production support, performance tuning of reporting environments, integration and sharing data with other applications
• Analyze and recommend through evaluations, presentations and analyses for business cases the technologies to enhance Data Analytics to meet business objectives and strategies
• Design, build and deploy Business Intelligence (BI) solutions using Power BI integrated with Microsoft Fabric’s environment for analytical and management review within Project Delivery Teams, Management and Central Function teams
• Develop and execute database queries (SQL) and conduct analyses to be used by CPG to identify and measure performance improvement and by Management to identify opportunities for meeting and exceeding strategic goals and targets.
• Develop applications using Microsoft Power Platform components, including Power Apps and Power Automate, with hands-on experience
• Evaluate and improve existing BI systems by analyzing the design and architecture, Power BI data model to identify root causes of poor performance (in information accuracy and speed) and providing solutions to address them
• Gather business requirements and facilitate key BI initiatives in partnership with the business units
• Perform and support data analysis and advanced analytics using tools such as Python and R, and conduct predictive modeling and optimization to help Project Delivery Teams make data‑driven decisions
• Keep up to date with Power BI new features and MS cloud integration
• Design and implement automated data cataloging and metadata‑driven insight generation capabilities

What Skills and Qualifications Do I Need?

• Completion of a degree in Engineering, Computer Science, or a related discipline - or a combination of education, training and experience deemed equivalent
• Demonstrated experience in Data Science, Data Analytics and Business Intelligence
• Demonstrated experience with Microsoft Power BI tools creating data-rich dashboards, implementing row-level security, Power Query and DAX using Microsoft BI stack
• Highly proficient in reading and writing advance SQL queries, data analysis and experience with at least one major programming languages like Python, R. and Java
• Experience with Microsoft Fabric and Power BI Premium, including relational databases, data warehousing, data pipelines and dataflows, notebooks, and semantic models.
• Strong understanding of data warehousing, dimensional modeling, ELT/ETL pipelines, and modern cloud data architecture patterns
• Familiarity with relational databases such as SQL Server, Azure SQL, or Oracle.
• Experience with Power Platform (Power Apps, Power Automate) is an asset.
• Knowledge of machine learning concepts, model lifecycle, and/or experience using Azure ML or Fabric Notebooks for predictive analytics
• Excellent time-management and organizational skills, with the ability to handle conflicting demands and prioritize effectively
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude

Don’t Meet Every Requirement?
If you’re excited about working with Metrolinx but your past experience doesn’t quite align with every qualification of this posting, we encourage you to apply. You just might be the right candidate for this or other roles. We are always looking for great talent to join our team.
We invite all interested individuals to apply and encourage applications from members of equity-deserving communities, including those who identify as Indigenous, Black, racialized, women, people with disabilities, and people with diverse gender identities, expressions and sexual orientations.
Accommodation
We value the unique skills and experiences each person brings to Metrolinx and are committed to creating and maintaining an inclusive and accessible environment. We are committed to the requirements of the Accessibility for Ontarians with Disabilities Act so if you require accommodation during the hiring process, please let our Recruitment team know by contacting us at: 416-202-5601 or email hr.recruitment@metrolinx.com .
Application Process
All applicants must be legally entitled to work in Canada. Metrolinx will be using email to communicate with you for all job competitions. It is your responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time-sensitive correspondence, we recommend that you check your email regularly. If no response is received, we will assume you are no longer interested in pursuing the opportunity. Please be advised that a Criminal Record Check may be required of the successful candidate.
Should it be determined that any background information provided is misleading, inaccurate or incorrect, Metrolinx reserves the right to discontinue with the consideration of your application.
We thank all applicants for their interest, however, only those selected for further consideration will be contacted.
WE ARE AN EQUITABLE AND INCLUSIVE EMPLOYER.