Software Engineer

LanceSoft; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

A leading Canadian tech firm is looking for a skilled Software Engineer to develop integrations for a new FP&A platform. The role focuses on coding with Python and SQL, building robust data pipelines, and collaborating with business stakeholders. Ideal candidates will have a strong background in software engineering, particularly in financial data integration. This position offers the opportunity to work with cutting-edge technologies in a hybrid work environment.

Benefits

Exposure to leading SaaS technologies

High visibility with stakeholders

Opportunity to build from scratch

Qualifications

• 7+ years of experience as a Software Engineer/Developer.
• 3+ years of hands-on Python experience required.
• 3+ years working with SQL databases, writing complex queries.

Responsibilities

• Integrate new data pipelines into the FP&A platform.
• Build and enhance the integration engine/platform for data ingestion.
• Collaborate with Business Analysts to translate requirements into logic.

Skills

Software engineering principles

Python

SQL databases

Data integration

Stakeholder interaction

Education

Bachelor’s degree in a technical field

Tools

Anaplan

Apache Airflow

SQL Server

GCP

Kubernetes

Job description

Overview

Location Address: Hybrid - 44 King Street W 19th Floor, Toronto – 4/week
Subject to change: 3–4 days onsite may be required based on business needs
Contract Duration: ASAP to Oct 31, 2026 – approx. 7 months
Possibility of extension & conversion to FTE
Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group: Data Models & Analytics – the primary technology group supporting all financial functions within the CFO organization. This includes financial forecasting, planning and analysis, budgeting, treasury, performance data, and any technology solutions required by Finance. The group is an internal-facing technology team of ~300 people. Immediate team they will be working with is 6 total (others on the team are software engineers).

Responsibilities

• Integrate new data pipelines from various source systems into the FP&A platform to enable its use as a core forecasting and budgeting tool.
• Build and enhance the integration engine/platform that ingests data from multiple sources.
• Apply best-practice software engineering principles throughout development.
• Contribute to the development of a full-scale data-driven application that will continue to expand as new data sources are onboarded.
• Work closely with Business Analysts and end users to translate business requirements into technical logic for data handling.
• Analyze financial data and work directly with databases.
• Role breakdown: 80% coding / 20% requirements gathering and stakeholder interaction.
• Technical Stack - Languages: Python, Apache Airflow; Platforms: Anaplan, Cloud Composer; Cloud: GCP; Infrastructure: Kubernetes; Databases: SQL, SQL Server, Postgres

Candidate Value Proposition

• Opportunity to work on a brand-new platform built from scratch, following modern best practices (unlike legacy-heavy environments).
• Exposure to leading SaaS and cloud technologies.
• High visibility and interaction with diverse business stakeholders across a top-tier Canadian bank.
• Chance to influence and build large-scale data integrations supporting critical financial processes.

Qualifications

1. 7+ years as a Software Engineer/Developer
2. 3+ years of hands-on Python experience
3. 3+ years working with SQL databases, including writing complex, efficient queries and understanding data structures

Nice-To-Have Skills

1. Experience with Anaplan would set them apart
2. Experience with Apache Airflow
3. Experience with database tools: SQL Server (preferred), or Oracle, DB2, Postgres
4. Experience working financial data and financial planning and analysis
5. Experience with Hyperion
6. Experience with cloud technologies (GCP preferred, Azure is acceptable)
7. Experience with Kubernetes
8. Experience with cloud composer

Education

• Bachelor’s degree in a technical field (e.g., Computer Science, Software Engineering)
• Anaplan certifications are an asset
• Data engineering certifications (Google Cloud, Azure) are an asset

Best vs. Average Candidate

The strongest candidates will have experience supporting or integrating data into FP&A platforms such as Anaplan or Hyperion, combined with strong Python development skills. Additional experience building applications from scratch—whether in Python, Java, C++, or similar languages—is highly valued. A strong data-centric mindset and experience processing large datasets efficiently will stand out.