Data Software Developer – Enterprise Data Warehouse (Hybrid)
City : Toronto, Canada
Category : Enterprise Operations
Industry : Financial Services
Employer : Ontario Teachers’ Pension Plan - OTPP
As the Software Developer, you will analyze, design, develop, and support software solutions to help Ontario Teachers' Pension Plan meet its business objectives. You will contribute your technical knowledge to complex and interesting IT projects for our Investments division. You’ll have the opportunity to work remotely and come into the office on occasion for team collaboration moments. Our Flexible Travel Program gives you the option to work abroad for a month in another region/country. The choice is yours!
Who you'll work with
This position is part of the Information Technology group, within the Enterprise Operations Division. You will work in a cross-functional team building custom analytics solutions for the front office customers in Investments division.
What you'll do
With guidance and support, complete well designed systems of high quality that make appropriate use of technology.
Develop personal plans and the task detail appropriate for completion of an acceptable volume of work and for the communication of status
Responsible for maintaining currency in technological trends and directions; continually upgrading personal, technical, and IT related skills through research, education and self‑motivated technology experimentation.
Participate and lead in new technology investigation and make recommendations for new technology adoption where appropriate
Opportunities to lead technical projects and act as mentor to junior development staff
What you'll need
Computer Science or Engineering degree or equivalent working experience.
Expert level knowledge of current information systems theories, concepts, and techniques.
Excellent organizational, analytical and problem-solving skills.
Ability to communicate and interact effectively with end users who are not technical.
Minimum of 5 years of professional software development experience
Knowledge of data modelling for transactional as well as reporting/ data analytics systems.
Experience with system integration using service-oriented architecture (SOA) and event-based integration.
Experience with the following technologies: Python, T-SQL/SQL, .NET (core and legacy), Microsoft SSIS (or similar ETL tool).
Practical experience with Continuous Delivery tools / practices (e.g. Github, Jenkins, Nexus, Delphix, UrbanCode).
Experience with cloud platforms such as Snowflake, Azure, AWS, is an asset.
Knowledge of front end development in Angular or other SPA frameworks is an asset.
Experience in various software development methodologies and agile development practices; Test Automation, Test Driven Development, Continuous Delivery.
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
The opportunity to invest back into the fund through our Deferred Incentive Program
A flexible/hybrid work environment combining in office collaboration and remote working
Competitive time off
Our Flexible Travel Program gives you the option to work abroad in another region/country for up to a month each year
Employee 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 take pride in ensuring that the people we hire and the culture we create, reflect and embrace diversity of thought, background and experience. Through our Diversity, Equity and Inclusion strategy and our Employee Resource Groups (ERGs), we celebrate diversity and foster inclusion through events for colleagues to connect for professional development, networking & mentoring. We are building an inclusive and equitable workplace where our talent is respected, accepted and empowered to be themselves. To learn more about our commitment to Diversity, Equity and Inclusion, check out Life at Teachers'.
How to apply
Are you ready to pursue new challenges and take your career to the next level? Apply today! You may be invited to complete a pre-recorded digital interview as part of your application.
Accommodations are available upon request (email@example.com) for candidates with a disability taking part in the recruitment process and once hired.
Candidates must be legally entitled to work in the country where this role is located.
The privacy of your personal information is important to us. Please visit our Privacy Centre to learn how we handle your personal information.
Functional Areas:Information Technology