Data Analyst, Regulatory Reporting

Bank of Canada; Ottawa; Hybrid; CAD 72,000 - 85,000; Full time

Job summary

The Bank of Canada is seeking a Data Analyst with strong coding skills and experience in data validation to enhance its analytical capabilities. This role involves working with financial data to support policy decisions and ensure accurate data management. Candidates will enjoy a competitive salary and a supportive work environment that encourages professional development.

Benefits

Competitive salary

Comprehensive benefits package

Flexible work arrangements

Opportunity for performance bonuses

Extra vacation days

Qualifications

• Advanced coding skills in Python, SQL, or PySpark.
• Solid experience in data validation and publication.
• Understanding of financial statements and statistical methods.

Responsibilities

• Report and publish regulatory data to the Bank’s website.
• Use analytic tools to ensure data accuracy and streamline workflows.
• Update legacy scripts into PySpark and SQL and develop data visualizations.

Skills

Data validation

Statistics

Analytical mindset

Collaboration

Education

University degree in economics

Degree in accounting, statistics, mathematics, computer science, or finance

Tools

Python

SQL

PySpark

Power BI

Excel

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Equity, Diversity & Inclusion
The Bank is committed to achieving a workforce that reflects the diversity of our country and isrepresentative and inclusive of all Canadians regardless of race, ethnicity, colour, religion, sex, age, disability, sexual orientation, gender identity or expression, socio-economic background or lived experience. By living our values and prioritizing our actions to enhance equity, diversity and inclusion, the Bank ensures broader discussions, better decisions, and a more engaging workplace.

We make career growth and professional development a priority. We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce.

Let our team know if you need accommodation or support during the recruitment process due to a disability or other reason. We can provide support in multiple ways, from using this site and submitting your application, right through to the interview process. If you are the successful candidate, you can also discuss accommodation needs when you receive your offer.

We invite you to join an organization where differences are seen as strengths and are recognized, valued and respected. We welcome all candidates to apply and strongly encourage candidates to self-identify if they identify with an Employment Equity designated group (Indigenous Peoples, Persons with Disabilities, Women or Racialized/Visible Minorities).

Data Analyst, Regulatory Reporting

Take a central role

The Bank of Canada has a vision to be a leading central bank—dynamic, engaged and trusted—committed to a better Canada. No other employer in the country offers you the unique opportunity to work at the very center of Canada’s economy, in an organization with significant impact on the economic and financial well-being of all Canadians. You will be challenged, energized and motivated to excel in our environment.

Building on the principles that have always guided us – excellence, integrity and respect – we strive to be forward-looking and innovative, to welcome people with diverse perspectives and talents, and to earn trust by living up to our commitments and by clearly explaining the intent of our policies and actions.

With our defined-benefit pension plan, benefits, and high flexibility for work life balance - find out more about why we are annually ranked as one of Canada's top employers: Working Here - Bank of Canada

Join a dynamic team at the heart of Canada’s financial data ecosystem. As an integral part of the Financial Institutions Statistics (FIS) team, you’ll play a key role in collecting, validating, and publishing data from federally regulated financial institutions—data that supports key economic analysis and policy decisions.

You’ll use your strong analytical mindset and technical expertise to ensure the quality and reliability of regulatory data. Working with tools like Python, PySpark, SQL, Power BI, and Excel, you’ll automate processes, troubleshoot data issues, and contribute to innovative projects that enhance the Bank of Canada’s analytical capabilities. This role offers a unique opportunity to develop deep expertise in Canadian banking data, collaborate across departments, and make a tangible impact on the financial system.

Specifically, you will:

• Contribute to the accurate reporting and timely publication of regulatory data to the Bank’s website and to external organizations, on time and tailored to a variety of user requirements
• Leverage a variety of analytic tools, from macro-enabled Excel workbooks to PowerBI dashboards and artificial intelligence, to ensure data accuracy and drive enhancements that streamline and strengthen validation workflows
• Take ownership of creating and documenting key data validation and dissemination processes as we shift to next-generation technologies
• Update legacy scripts and formulas into PySpark and/or SQL and develop data visualizations to support client requirements and continuous process improvements
• Lead and support user acceptance testing of system upgrades or redesigns, including occasional after-hours or weekend testing to ensure smooth implementation
  Support knowledge sharing and help strengthen the team’s technical capabilities through collaboration and skill development.

Note: This poster can be used to fill either a permanent or 18-month term position.

What you need to succeed
You possess advanced coding skills and are proficient in at least one programming language such as PySpark, Python, SQL, or DAX. You bring solid experience in data validation, statistics and data publication, along with the ability to automate processes and develop innovative solutions to complex problems. Your knowledge of financial statements, the operations of financial institutions, and statistical methods enables you to understand and analyze data in a meaningful way.

As a collaborative team player, you actively share your expertise and contribute to achieving shared goals. You approach challenges with optimism and adaptability, maintaining excellent judgment and strong organizational skills. Your keen attention to detail and ability to prioritize tasks allow you to consistently meet deadlines in a dynamic work environment.

Nice-to-have

• Experience in a regulatory reporting environment or data reporting area of a financial institution
• Proficiency with key software tools such as Azure Data Factory, Databricks, SAS, Stata
• Knowledge of Canadian financial market structures and financial market instruments

Your education and experience

This role requires a university degree in economics, accounting, statistics, mathematics, computer science, finance, or a related field, along with at least two years of relevant experience. Your background should include validating and analyzing financial data, troubleshooting technical issues, and demonstrating progressively greater responsibility. An equivalent combination of education and experience may be considered.

Language requirement
The Bank’s work environment is conducive to the use of both of Canada’s official languages - English and French. The position language requirement is Level 5 (Fully Functional). If a qualified candidate who meets the language requirement of the position is not found, a qualified candidate who does not meet the language requirement may be considered. Training may be provided to help reach the required level. Both bilingual and unilingual candidates are encouraged to apply.

What you need to know

• Priority will be given to Canadian citizens and permanent residents
• Security level required: Be eligible to obtain Reliability
• Relocation assistance may be provided, if required
• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
• The official title for this position is “Financial Data Analyst”

Hybrid Work Model

The Bank offers work arrangements that provide employees with flexibility, enable high-performing teams, and support an excellent workplace culture. Most employees can telework from home for a substantial part of each month as part of the Bank`s hybrid work model, and they are expected on site at the Bank location a minimum of eight days per month to help build connections between colleagues. You must live in Canada, and within reasonable commuting distance of the office.

What you can expect from us
This is a great opportunity to join a leading organization and be part of a high-performing team. We offer a competitive compensation and benefits package designed to meet your needs at every stage of your life and career. For more information on key benefits please visit A great deal to consider .

• Salaries are based on qualifications and experience and typically range from $72,070to $84,788 (job grade 14)
• The Bank offers an incentive for successfully meeting expectations at 5 to 7% of your base salary. The Bank offers additional performance pay (3%) for those who exceed expectations.Exceptional performers who far exceed expectations may be eligible for higher performance pay.
• Flexible and comprehensive benefits so you can choose the level of health, dental disability and life and/or accident insurance coverage that meets your needs
• Extra vacation days (up to five each year) that you can purchase to add to your vacation entitlement

We wish to thank all applicants for their interest and effort in applying for this position.Onlycandidates selected for interviews will be contacted.