Senior Software Developer - Data Integration

Metrolinx; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

Metrolinx, a leading agency connecting communities in Ontario, is seeking a Senior Software Developer in Toronto. This exciting role offers the opportunity to build cloud-based data solutions and BI components while supporting an inclusive workplace. Ideal candidates will possess strong software development experience, expertise in data engineering, and the ability to collaborate effectively across teams, making significant contributions to various data-driven initiatives.

Qualifications

• Completion of a degree in Engineering or Computer Science or equivalent.
• Experience as a Technical Lead or Senior Software Engineer.
• Ability to mentor developers and communicate technical topics clearly.

Responsibilities

• Build end-to-end cloud-based data pipelines and data products.
• Design, develop, and maintain CI/CD pipelines and deployment systems.
• Create visualizations and reports for requested projects.

Skills

Data Engineering

SQL

Cloud Technologies

Business Intelligence

Data Visualization

Software Development

Agile Methodology

Root Cause Analysis

Technical Communication

Education

Degree in Engineering or Computer Science

Tools

Qlik

Power BI

Power Apps

Tableau

AWS

GCP

Azure

MS SQL

Oracle SQL

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

Metrolinxs Innovation and Information Technology group supports female team members via Go Tech Women an affinity group for women in Information Technology led by our Chief Information Officer.

This role will provide technical specific development skills and experience to the following product portfolios : Data Engineering; Data Platform Development; Data Analytics; Data Architecture.

The Data Platform Delivery team will provide data engineering capabilities (extraction storage retention cataloging classification modelling cleansing staging aggregation summarization mining predictive modelling analysis forecasting optimization reporting visualization) to the organization. The purpose of this role is to combine these responsibilities into a new and more structured role which would add relevant experience and leadership skills to better deliver various solutions in the areas of BI and analytics. This may also require the knowledge of scientific methods processes algorithms and systems to extract knowledge and insights from a variety of structured and unstructured data.

What will I be doing

• Build end-to-end cloud-based data pipelines and data products including creating and assembling large complex datasets to meet functional and non-functional business requirements and user stories
• Familiar with relational and non-relational databases data warehouses lakehouse
• Experience with ETL (extract transform load) tools processes and related concepts using Cloud and SQL technologies
• Experience with Cloud IaaS PaaS SaaS stacks (AWS GCP Azure)
• Design develop and maintain CI / CD pipelines and deployment systems (DevOps)
• Identify data issues and perform root cause analysis
• Use the latest concepts in data architecture and standard Software Development Life Cycle (SDLC)
• Experienced with Structured / unstructured data systems MS SQL Oracle SQL Cloudera MariaDB etc.
• 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.
• Processes to determine technical design develop and test code and document and implement software solutions
• Design build and deploy Business Intelligence (BI) components of solutions using reporting platforms such as Qlik Power BI Power Apps and Tableau
• Create visualizations and reports for requested projects
• Develop test and support applications as needed either individually or as part of a team including the modification of existing programs to conform to system changes or to make improvements in the existing program
• Review all programs prior to implementation to verify consistency and conformance with established departmental guidelines policies and practices as well as industry standard guidelines
• Lead the technical analysis program design coding testing debugging and documentation with full technical knowledge of all phases of applications systems analysis and programming
• Creates prototypes / proof-of-concept to demonstrate or validate designs.
• Ability to translate business needs to technical specifications clearly communicate advanced technical topics with non-technical audiences and to work effectively with support teams user communities and application development groups.
• Mentor and provide knowledge of best practices to developers and analysts on software development. Facilitate collaboration with other developers product owners product teams and designers to solve interesting and challenging problems through delivery of various analytics solutions.
• Strong interpersonal and oral / written / presentation skills
• Familiarity with Agile Software Development is an asset

What Skills and Qualifications Do I Need

• Completion of a degree in Engineering or Computer Science or a related discipline or a combination of education training and experience deemed equivalent
• Experience in Software development as a Technical Lead Senior Software Engineer Project
• leader
• Develop and test Cloud prototypes proof of concepts pilots and production builds
• Design build and deploy Business Intelligence (BI) components of solutions using reporting
• platf orms such as Qlik Power BI Power Apps and Tableau
• Develop and execute database queries and conduct analyses to be used by Operations to identify and measure performance improvement and by management to identify opportunities for meeting and exceeding strategic goals and targets.
• Create visualizations and reports for requested projects

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.

For Internal applicants with the recent implementation of the Internal Mobility Policy the internal recruitment process has changed for non-union roles. Candidates must be in their current role for 12 months prior to applying for another role and each applicant must be in good standing (not participating in a Performance Improvement Plan). Please review all provisions of the policybefore submitting your application.

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-SC1

Required Experience :

Senior IC

Key Skills

Distribution,Baan,Information Technology Sales,Infrastructure,Loans

Employment Type : Full-Time

Experience : years

Vacancy : 1

Create a job alert for this search

Senior Software Developer • Toronto, Ontario, Canada