Senior Python/SQL Engineer - Risk Division

Job Description

Senior Python/SQL Engineer - Risk Division:
On behalf of our Banking client, Procom is searching for a Senior Python/SQL Engineer - Risk Division for a contract position. 

Senior Python/SQL Engineer - Risk Division - Job Description:
The Senior Python/SQL Engineer will support the migration of the Risk Division’s applications, reporting assets, and data dependencies to the client's Snowflake and Azure Cloud enterprise platforms. The role involves repointing existing Risk applications, processes, and dashboards to Snowflake tables, ensuring continuity of business-critical risk processes. 

Senior Python/SQL Engineer - Risk Division - Responsibilities:
• 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.

Senior Python/SQL Engineer - Risk Division - Mandatory Skills:
• 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 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.
• Strong analytical, organizational, troubleshooting, and problem-solving skills.
• Excellent communication skills and ability to provide clear updates on work plans, testing results, issues, and delivery status.

Senior Python/SQL Engineer - Risk Division – Nice-to-Have Skills:
• Experience with Julia is a plus.
• Experience with Power BI dashboard development, migration, or data source repointing.
• Financial industry experience is an asset; capital markets or risk management experience is strongly preferred.

Senior Python/SQL Engineer - Risk Division – Assignment Length:
This is a 5-month contract (until end of year)

Senior Python/SQL Engineer - Risk Division - Start Date:
ASAP.

Senior Python/SQL Engineer - Risk Division - Assignment Location:
Toronto, Ontario, Canada. This position is hybrid with 3 days in office.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.