14 Sep 2026

Senior Developer Python / SQL

Toronto, ON

Agilus by Synergie is recruiting for a Senior Developer Python/SQL in the Pension Domain in a hybrid work environment in Toronto, Ontario.
Responsible for supporting the migration of the Risk Division’s applications, reporting assets, and data dependencies to Snowflake and Azure Cloud enterprise platforms. The role will focus on repointing existing Risk applications, processes, and dashboards to Snowflake tables while ensuring continuity of business-critical risk processes.
A typical day:

Repoint existing Risk Division applications, processes, and reporting assets from Oracle and SQL databases to Snowflake across multiple Risk teams. Analyze and update C#, Julia, and Python applications that currently depend on Oracle tables, Oracle SQL, and Oracle stored procedures. Convert, rewrite, or replace Oracle SQL and stored procedure logic where required to support Snowflake-based workflows. Work with Technology teams to understand Snowflake table structures, data availability, refresh timing, and data quality expectations. Support the migration of Power BI dashboards and reports from Oracle-based data sources to Snowflake. Validate migrated applications, reports, and processes through testing, reconciliation, troubleshooting, and performance tuning. Document migration approach, technical changes, testing results, known issues, and operational handover procedures. Communicate progress, risks, dependencies, and blockers clearly, and participate in planning and delivery discussions with stakeholders across Risk. Contribute to Risk Division best practices for application repointing, SQL conversion, dashboard migration, testing, and production readiness.

Successful candidates will have:

Undergraduate or graduate degree in a quantitative or technical discipline such as Engineering, Computer Science, Mathematics, Statistics, Finance, or a related field. Minimum 4 years of software development, database development, or data engineering experience. Strong hands-on experience with Python, SQL, and C# application development. Experience with Julia is a plus Experience with Oracle databases, including Oracle SQL, stored procedures, and database-driven applications. Experience with Snowflake, including SQL development, connectivity, query optimization, and migration from legacy databases. Experience with Power BI dashboard development, migration, or data source repointing. Strong analytical, organizational, troubleshooting, and problem-solving skills. Ability to work effectively with developers, Technology teams, risk professionals, and business users with varying levels of technical background across different Risk functions. Financial industry experience is an asset; capital markets or risk management experience is strongly preferred. Excellent communication skills and ability to provide clear updates on work plans, testing results, issues, and delivery status

Total rewards:

$75.00 - $115.00 hourly
6 month contract

Soft skills:

strong written and verbal skill are required

This posting is for an active opening.

Interested?
Please apply directly online

Agilus by Synergie would like to thank all candidates for their interest in this opportunity. Due to the volume of resumes we receive; we may only be able to respond directly to those candidates being selected for an interview.
We encourage you to visit agilus.ca regularly or subscribe to our email alerts at agilus.ca/Account/Register as new exciting employment opportunities become available daily.

Job Code 156318

We value a diverse workplace.

Agilus by Synergie is committed to employ people from diverse backgrounds and we actively demonstrate inclusiveness through fair, equitable and accessible hiring practices. We recognize the strength that comes from different experiences, backgrounds and perspectives and welcome candidates who identify as visible minorities, Indigenous people, persons with disabilities, and persons within the LGBTQ+ community. We feel it is important as an organization that all people have access and opportunity to be employed, to be valued and to be respected.

Our recruiting process is human-centric and supported by AI. Our AI assistant may reach out to applicants for a prescreen. All results will be reviewed and evaluated by our Canadian based, human recruiting team.

Accommodations for job applicants with disabilities will be provided upon request during the recruitment, assessment, selection and placement process. Alternative format available on Request.