Senior Data Engineer

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

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

CPGs 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 Engineeris 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 ManagerManager 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 Fabrics 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 datadriven decisions
Keep up to date with Power BI new features and MS cloud integration
Design and implement automated data cataloging and metadatadriven 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

Dont Meet Every Requirement

If youre excited about working with Metrolinx but your past experience doesnt 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: or email.

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.

#LI-MM3

Required Experience:

Senior IC

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