Sr. Data Engineer supporting the migration of the Capital Market Investment Analytics (CMIA) team’s assets to Snowflake and Azure cloud enterprise pl

Contract Duration: 12 months

The opportunity

Responsible for supporting the migration of the Capital Market Investment Analytics (CMIA) team’s assets to OTPP’s Snowflake and Azure cloud enterprise platforms.

Who you'll work with

You will work alongside the software developers and investment professionals on the CMIA team in support of their migration to the Cloud. You will report to a Senior Manager, Solution & Quality Engineering.

What you'll do

• Develop a Data and Cloud migration framework that accelerates the migration of the CMIA team’s assets to OTPP’s Snowflake Data and Azure Cloud platforms
• Assist with the migration of the CMIA team’s assets to our clients Cloud platforms
• Maintain and improve the team's software solutions and infrastructure which runs all aspects of the team's systematic investment process including trading, execution and research.
• Contribute to the CMIA team’s continuous improvement process and help to develop software and data engineering best practices and standards particularly with respect to deployment and management of assets to OTPP’s Data and Cloud platforms
• Develop new solutions and enhance existing solutions in support of the Capital Markets investment desks that the CMIA team supports.
• 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 projects. Actively participate in the team’s agile ceremonies and work planning processes.
• Responsible for maintaining currency in technological trends and directions continually upgrading personal technical and IT skills through research, education and self-motivated technology experimentation.
• Participate in new technology investigation and make recommendations for new technology adoption where appropriate.
• Other duties as assigned.

What you'll need

• Undergraduate or graduate degree in a quantitative discipline such as Engineering or Computer Science.
• Minimum 8 years software design/development experience with at least 5 years full-time working as data engineer preferably within the financial industry.
• Communicate and interact effectively with systems professionals, as well as Capital Markets business users with minimal background in information technology.
• Excellent organizational, analytical and problem-solving skills.
• Expertise in the following languages: Python, SQL.
• Experience with the following technologies:
• Database and Data engineering: Snowflake, SQL Server, Oracle, Airflow/Astronomer, Stored Procedures, SSIS, DBT. Experience with OneTick or another time series database is an asset.
• Cloud Technologies: Azure, AKS.
• DevOps/Agile: Git, Jenkins, Nexus, Jira.
• Experience building data analytics and data engineering solutions, ex. Data pipelines and ELT processes.
• Experience migrating Data and Data Engineering assets to cloud platforms (ex. migrate data/databases to Snowflake and migrate Python analytic scripts to Azure AKS).
• Experience with common financial data providers is an asset (ex. Bloomberg, Refinitiv, S&P Xpressfeed).
• Experience working in an agile environment and with modern development methodologies such as Test-Driven Development, Continuous Delivery and Scrum
• Experience in the financial industry required. Completion of the Canadian Securities Course and/or CFA candidacy.