Senior Software Developer - Data Integration

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.

Metrolinx's 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
• Proficiency in developing applications and tools with programming and scripting languages – JavaScript, PowerShell, Bash, SQL, Java, Python, etc.
• 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

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