Data Aggregation & Control – Analyst/Senior Analyst

FP Inc.; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

FP Inc. is seeking a data and risk professional to aggregate risk and finance data for stress testing, build data quality checks, and document data lineage from source to output.

The role emphasizes SQL/Python automation and strong data governance in a regulated environment. The candidate should have 5+ years in risk/finance/data roles at financial institutions and hold a Bachelor's degree in Finance, CS, Statistics or related field.

Qualifications

• 5+ years in risk, finance or data roles at a bank or financial institution.
• Strong hands-on SQL and Python, plus advanced Excel.
• Experience with data quality, reconciliation and control testing.
• Understanding of risk and finance data: loan-level credit data, RWA and balance sheet data.
• Experience documenting data lineage and controls.
• Bachelor's degree in Finance, Computer Science, Statistics or a related field.

Responsibilities

• Aggregate and prepare risk and finance data for stress testing, including credit, RWA and balance sheet data.
• Build and run data quality checks, reconciliations and controls across source systems and model inputs.
• Document data lineage from source to stress testing output.
• Investigate and resolve data breaks, track issues and drive root-cause fixes.
• Automate manual data processes using SQL and Python.
• Support audit, model validation and regulatory requests with clear evidence of data controls.

Skills

Data quality

Reconciliation

Controls testing

Data lineage documentation

Education

Bachelor's degree in Finance, Computer Science, Statistics or related field

Tools

SQL

Python

Excel

Job description

Key Responsibilities:

• Aggregate and prepare risk and finance data for stress testing, including credit, RWA and balance sheet data.
• Build and run data quality checks, reconciliations and controls across source systems and model inputs.
• Document data lineage from source to stress testing output.
• Investigate and resolve data breaks, track issues and drive root-cause fixes.
• Automate manual data processes using SQL and Python.
• Support audit, model validation and regulatory requests with clear evidence of data controls.

Must-Haves:

• 5+ years in risk, finance or data roles at a bank or financial institution.
• Strong hands‑on SQL and Python, plus advanced Excel.
• Experience with data quality, reconciliation and control testing.
• Understanding of risk and finance data: loan-level credit data, RWA and balance sheet data.
• Experience documenting data lineage and controls.
• Bachelor's degree in Finance, Computer Science, Statistics or a related field.

Nice-to-Haves:

• Direct BCBS 239 or risk data governance experience.
• Exposure to stress testing, ICAAP or regulatory capital reporting.
• Experience with data visualization or data governance tools.

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The yearly compensation range for this role is $100k - 120k. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.