Data Aggregation & Control – Analyst/Senior Analyst
- Toronto, ON, Canada
$100,000 to $120,000 CAD / year · Full-time
Applications open in a new tab.
Job details
- Pay
- $100,000 to $120,000 CAD / year
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
An Initial AI Screening will be conducted for this role. Please Click Here to complete your AI screening while submitting your application.
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.
More about this job
Responsibilities
Aggregate and prepare risk and finance data for stress testing, and build data quality checks, reconciliations, controls, and lineage documentation. Investigate data issues, automate manual processes with SQL and Python, and provide evidence for audits, model validation, and regulatory requests.
Requirements
Requires at least five years of experience in risk, finance, or data roles at a bank or financial institution, with hands-on SQL and Python, advanced Excel, and experience in data quality, reconciliation, and control testing. Applicants must have a bachelor's degree in Finance, Computer Science, Statistics, or a related field; BCBS 239, stress testing, ICAAP, regulatory capital reporting, and data governance tools are advantageous.
Skills
- SQL
- Python
- Advanced Excel
- Data Quality
- Reconciliation
- Control Testing
- Data Lineage Documentation
- Risk Data
- Finance Data
- Credit Data
- Risk-Weighted Assets
- Balance Sheet Data
- Stress Testing
- Root-Cause Analysis
- Data Process Automation
- Regulatory Reporting
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Finance & Accounting
- Technology
Keywords
- Risk Data
- Finance Data
- Stress Testing
- Credit Data
- Risk-Weighted Assets
- Balance Sheet Data
- Data Quality
- Reconciliation
- Controls
- Data Lineage
- SQL
- Python
- Excel
- Data Automation
- Audit Support
- Model Validation
- Regulatory Requests
- BCBS 239
- Risk Data Governance
- ICAAP
- Regulatory Capital Reporting
- Data Visualization
- Data Governance Tools
- Root-Cause Analysis