Lead Software Developer - Data & Analytics (hybrid)

November 25 2022
Expected expiry date: December 14 2022
Industries Bank, Insurance, Financial services
Categories Database Dev. & Admin., Programming, Development
Toronto, ON

The Opportunity

We are looking for a Lead Software Developer to join our Data Analytics Team! You will analyze, recommend, develop, support, and enhance the software and analytical systems of the organization to meet business objectives. The team is responsible for diverse data and analytics related projects, helping investment teams organize, interpret, and act upon financial and market related data. What we do has an impact on helping the teachers of Ontario feel secure in having a financially safe retirement, as well as help distribute the over $240B fund of OTPP onto deserving investment targets.

On a day-to-day level, we are looking for someone who is excited about creating data pipelines as their bread and butter, as well as additionally working on web and reporting applications which will surface the data to our business partners.

Who you’ll work with

The Data Analytics Team is a medium sized team of software developers, distributed across multiple software projects which are completed for various stakeholders. We are looking for a team player who can work in a group, as you may be working on projects and will need to communicate and work effectively within the team. You will also need to communicate with our end users and project coordinators, many whom may not be very technical.

What you’ll do

  • Lead the design, planning, estimation, execution, completion, and leadership of well-designed and architected systems in the Data Analytics delivery team.

  • Develop both personal and project plans, interfacing with developers and project managers and acting as a mentor to junior development staff

  • Participate in modern technology investigation and make recommendations for technology adoption where appropriate. To assist with consistently evolving our data processes and techniques in accordance with industry best practices for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and MS Azure ‘big data’ technologies

  • Create data pipelines and analytics solutions to surface data to the end users, using Python and C#

  • Ingest data from a variety of internal and external sources, through data stores, files, APIs, etc.

  • Architect, implement, and maintain proper corresponding data stores (SQL Server, Oracle) for data pipelines and reporting

  • Create and maintain user interfaces for surfacing or interacting with the data using Front end technology (Angular, React)

  • Set up or maintain scheduled job triggers and/or deployment orchestration (UC4/Automic, UCD, Jenkins)

  • Maintain currency in technological trends and directions, continually upgrading personal, technical, and IT (Information Technology) related skills through research, education, and self-motivated technology experimentation

What you’ll need

  • Computer Science, Engineering, or related studies, or equivalent working experience

  • Advanced knowledge of information systems theories, concepts, methods, and techniques

  • Minimum 7 years design/development experience with at least 2 years in a lead developer capacity using object-oriented programming patterns and designs, leveraging a language such as C# .NET, Python, Java

  • Experience in leading initiatives through the full software development life cycle - from conception to completion - with proven ability to assume a leadership role in coordinating activities, scheduling, and project control

  • Effective communication skills for interacting with both technical and non-technical people

  • Advanced understanding of core data management and analytics concepts. Experience with relational and dimensional models using Oracle/PL-SQL and Microsoft SQL Server, or equivalents 

  • Strong SQL skills, with experience querying large, structured, and unstructured, datasets from multiple sources and developing automated reports within web-based interface (i.e., Angular, or similar frameworks) and enterprise reporting tools (i.e., Power BI)

  • Object Oriented Programming experience (Python/C#) for scripting, data manipulation, custom ETLs, and development of APIs

  • Understanding of Machine Learning and AI concepts to design and support engagements with cross functional teams across the organization.


What we're offering

  • Pay for performance environment that offers competitive salary and incentive

  • Numerous opportunities for professional growth and development

  • Comprehensive employer-paid benefits coverage

  • Retirement income through a defined benefit pension plan

  • A flexible/hybrid work environment combining in-office collaboration and remote working

  • Competitive time off

  • Discount programs including Edvantage and Perkopolis

  • Degreed: a digital platform that helps you quickly and easily discover, share, and track various learning resources — from courses to videos to articles and more.

At Ontario Teachers', diversity is one of our core strengths. We are a globally minded organization and take pride ensuring that the people we hire and the culture we create reflect and celebrate diversity of thought, background and experience. Through our Inclusion & Diversity Employee Resource Groups (ERGs) events, celebrations , we offer a variety of opportunities for colleagues to connect for the purposes of professional development and networking & mentoring.

How to apply

Are you ready to pursue new challenges and take your career to the next level? Apply today!

Accommodations are available upon request (talent_acquisition@otpp.com) for candidates with a disability taking part in the recruitment process and once hired.


Note that all individuals employed by Ontario Teachers’ in our Toronto office will be required to provide proof of full vaccination against COVID-19 as a condition of employment. We remain committed to an accessible, inclusive and barrier free workplace; written requests for a human rights-based exemption from vaccination will be considered on a case-by-case basis.

Candidates must be legally entitled to work in the country where this role is located.

Apply now!

Jobs.ca network