Software Developer, Data Engineering

As part of a new team, this 12-month contract is an exciting opportunity for a junior developer to expand their skills in data modelling and manipulation, market and regression trends and data wrangling.

Toronto, ON

Ontario Teachers' Pension Plan

Our employees make a difference by providing a secure retirement for 327,000 working and retired Ontario teachers. They&rsquo;re the reason for our success and talent development is one of the most important tenets of our strategy.<br /><br />We look for people who are willing to truly embrace the three cornerstones of our culture: innovation, agility and partnership. We provide our employees with the tools, resources and learning opportunities they need to be the best at what they do &ndash; so together we can support our mandate to deliver outstanding service and retirement security to our members &ndash; today and tomorrow.<br /><br />Ontario Teachers&rsquo; is headquartered in Toronto with offices in London and Hong Kong. With $191.1 billion in net assets as of December 31, 2018, we are responsible for providing immediate, personalized services to our members along with investing across a variety of asset classes in virtually every corner of the world.

keywords: the opportunity,who you'll work with,what we're offering,own your work,learn,r&d,collaborate,build,manipulate big data,the education,the experience,the knowledge,the drive,the relationship-building expertise

Mid Level

Overview: <h2><strong>The opportunity</strong></h2> <p dir="LTR">As we undertake an exciting new project, EPIC - the three-year transformation of our service and delivery model, we are adding a Software Developer, Data Engineering to be part of an organization-wide investment in new and optimized technology. It is an evolutionary time here as we bring all ownership of IT infrastructure and expertise in-house.</p> <p dir="LTR">As part of a new team, this 12-month contract is an exciting opportunity for a junior developer to expand their skills in data modelling and manipulation, market and regression trends and data wrangling. It&rsquo;s a chance to learn and grow your hands-on skills as you explore, collect, refine and inject data into our organization. We need a Software Developer, Data Engineering who is passionate about learning, wants to be part of a team, and is interested in helping us expand&nbsp; our analytical capabilities to benefit the organization and make impactful changes.</p> <p dir="DEFAULT">&nbsp;</p> <h2><strong>Who you'll work with</strong></h2> <p dir="LTR">You will report to the Technical Team Lead and work closely within and across Agile teams to focus and execute on 3-4 stories a week. You will build out SQL packages, write and deploy Python code to scrape and integrate internal and external business systems data, and dive into the data extraction. This is an inquisitive, analytical and close-knit team, continuously learning through experimentation, research, and professional development opportunities. While this is a junior role, we are always open to the ideas and suggestions of every team member; we want to hear your opinions on how we can evolve our data and analytics delivery system.&nbsp;</p>
Responsibilities: <h2><strong>What you'll do</strong></h2> <ul> <li>Own your work. You will design, develop, and test assigned portions of projects directly related to data manipulation through infrastructure, technology, and solutions. You will work closely with systems experts and end users to ensure all technical design solutions are considered.</li> <li>Learn. You will continually pursue technical and IT related skills through research, education, and self-motivated technology experimentation.</li> <li>R&amp;D. You will investigate and make recommendations for new technology adoption where appropriate.</li> <li>Collaborate. You will work with stakeholders and data and analytics experts to enhance the data capabilities of the organization.</li> <li>Build. You will develop the data pipeline and analytics tools to provide actionable insights into operational efficiency and other key business performance metrics.</li> <li>Manipulate big data. You will leverage infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and MS Azure.</li> </ul>
Requirements: <h2><strong>What you'll need</strong></h2> <ul> <li>The education. You have a postsecondary diploma or degree in Data Science, Computer Science, Mathematics, Statistics or a related field.</li> <li>The experience. You have a minimum of 3 years of software development experience using object oriented programming patterns and designs. You are highly analytical and have skills related to working with both structured and unstructured datasets. You have hands-on experience with: <ul> <li>Python.</li> <li>Relational and dimensional models using Oracle/PL-SQL and Microsoft SQL Server, Microsoft SSIS/SSAS, or equivalents</li> <li>Big Data tools such as Hadoop, Spark, Hive, or Kafka.</li> </ul> </li> <li>The knowledge. You have an understanding of: <ul> <li>Core data management and analytics concepts.</li> <li>Various software development methodologies and practices such as Test Driven Development, Continuous Delivery, Scrum and Agile.</li> <li>Current information systems theories, concepts, and techniques.</li> </ul> </li> <li>The drive. You are self-motivated, detail-oriented and take ownership of your work and how it impacts your team. You are curious, resourcefully seeking out trends in data.&nbsp; You learn quickly and have good judgement.</li> <li>The <span class=" WCE1 ">relationship-building</span> experience. You are comfortable working with individuals at any level. You have outstanding written and verbal communication skills. You want to be part of a team where you can make a difference.</li> </ul> <p dir="DEFAULT">&nbsp;</p> <h2><strong>What we're offering</strong></h2> <ul> <li>Pay for performance environment that offers competitive salary and incentive</li> <li>Numerous opportunities for professional growth and development</li> <li>Discount programs including Edvantage and Perkopolis</li> </ul> <p dir="DEFAULT">&nbsp;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.</p> <p dir="LTR">Accommodations are available upon request for candidates with a disability taking part in the recruitment process and once hired.&nbsp;</p>