We are looking for a Data Engineer to join our growing team of analytics experts within the Data and Analytics Program. Responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. Working along side fellow software developers, database architects, data analysts and data scientists on data initiatives while ensure optimal data delivery architecture is consistent throughout ongoing projects.
Who you’ll work with
Communicate and interact effectively with systems professionals, as well as end users who are not systems experts. Work independently, prioritize work assignments, meet deadlines and produce an adequate volume of work.
What you’ll do
With supervision, completes well designed and architected systems that make appropriate use of technology.
Responsible for completion of an acceptable volume of work and for the communication of status of personal work plans and tasks required to design, develop, and test assigned portion of projects.
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 in new technology investigation and make recommendations for new technology adoption where appropriate. To assist with consistently evolving our data processes and techniques in accordance with industry best practices.
Build analytics tools that utilize data pipelines to provide actionable insights into operational efficiency and other key business performance metrics.
Other duties as assigned.
What you’ll need
Computer Science or Engineering degree or equivalent working experience.
Advanced knowledge of information systems theories, concepts, methods, and techniques.
Minimum 3 years design/development experience work on data and analytics projects.
Experience in contributing to initiatives through the full software development life cycle - from conception to completion.
Strong communication and customer service skills required for interactions with people of varying levels of technical expertise.
Understanding of core data management and analytics concepts. Experience with relational and dimensional models using Oracle/PL-SQL and Microsoft SQL Server, Microsoft SSIS/SSAS, or equivalents
Experience with big data tools infrastructure and architecture within the MS Azure ‘big data’ stack such as Databricks and Spark
SQL skills, with experience querying large, structured and unstructured, datasets from multiple sources and developing automated reporting.
R and/or Python skills for scripting, data manipulation, custom ETLs, statistical/regression analysis.
Experience/interest in capital markets, related to financial trading, and investment concepts .
Exposure with various software development methodologies and practices such as Test Driven Development, Continuous Delivery, Scrum and Agile. Experience with the following technologies, or equivalents: Jira, GitHub, Nexus.
What we’re offering
Pay for performance environment that offers competitive salary and incentive
Numerous opportunities for professional growth and development
Guaranteed retirement income through a defined benefit pension plan
Discount programs including Edvantage and Perkopolis
Degreed: a digital platform that helps you quickly and easily discover, share, and track ALL kinds of learning resources — from courses to videos to articles and more
At Ontario Teachers', we are a globally minded organization and take pride ensuring that the people we hire and the culture we create reflects and celebrates diversity of thought, background and experience.
If you require an accommodation for the application, recruitment or interview process, please let us know and we will work with you to meet your needs.
How to apply
Are you ready to pursue new challenges and take your career to the next level? Apply today!
We thank you for applying, however, only those selected to continue will be contacted. Note that 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.