Senior Developer Python / SQL

Senior Developer Python/SQL – Pension Domain

Agilus by Synergie is recruiting for a Senior Developer Python/SQL in the Pension Domain in a hybrid work environment in Toronto, Ontario. Key Responsibilities

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 Candidate Qualifications

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

#J-18808-Ljbffr