Sql data analyst Jobs in Ottawa, ON

About the Bank of Canada’s New Mandate to Oversee Consumer-Driven Banking

Through the 2025 Federal Budget the Government of Canada has given the Bank of Canada the mandate to oversee the Consumer-Driven Banking Act.

Consumer-Driven Banking is a framework that allows consumers to share their financial data with financial companies of their choice. Within the framework, consumers may control, edit, manage, and delete their information. Consumers may decide when, how, and to what extent their financial institution shares information with financial companies. Providing a framework that allows consumers to safely and confidently use their financial information can help improve their choices with new financial products and services while keeping their information safe.

Under the Consumer-Driven Banking mandate, the Bank of Canada will:

• Accredit entities to participate in the framework’s data-sharing ecosystem;
• Maintain a registry of accredited entities;
• Supervise participating entities and make sure the risks associated with data sharing are appropriately managed – this includes assessing participating entities’ compliance with the following Consumer-Driven Banking Act requirements for:
  • Data sharing;
  • Security safeguards;
  • Technical standard;
  • Consent management;
  • Consumer measures;
  • Complaints procedures;
• Oversee accredited third-party service providers, an external complaints body and a technical standards body to determine whether they are compliant with the provisions of the Consumer-Driven Banking Act;
• Monitor and evaluate trends and emerging issues that may have an impact on consumers of consumer-driven banking; and
• Foster competition in the financial sector in the interests of consumers.

The Payments and Regulatory Oversight (PRO) department is undergoing preparations to implement this new mandate through contributions to the regulatory development process (led by the Department of Finance) and internal work to design and implement a supervisory framework.

Given the scale and scope of the initiative, a Business Analyst is essential to support informed direction‑setting and decision‑making activities during the development and early implementation of the Consumer‑Driven Banking supervisory framework.

What you will do

Reporting to the Program Manager, Consumer‑Driven Banking (CDB), the Business Analyst (BA) supports the design, build, and implementation of CDB supervisory capabilities and related technology solutions. Working closely with supervisory, IT, and enabling teams, the BA provides execution‑level analysis, coordination, and delivery support to ensure CDB modules—primarily on the Bank’s supervision platform (CRM solution)—are implemented effectively, consistently, and in a timely manner.

You will:

• Support the design and implementation of the CDB supervisory framework and related supervisory modules
• Elicit, document, and maintain business requirements, workflows, criteria, and supporting operational artefacts
• Develop and maintain implementation documentation, including procedures, templates, service standards, and training materials
• Support reporting and data requirements, including metrics, dashboards, and internal/external reporting inputs
• Contribute to product backlog management by documenting enhancements, issues, and change requests
• Coordinate with CDB teams, IT, and vendors to support build, testing, and rollout activities
• Identify, track, and document implementation issues, risks, dependencies, and assumptions
• Provide business input to user facing content to ensure clarity, consistency, and policy alignment
• Conduct analysis to support readiness assessments, trend analysis, and early operational monitoring
• Prepare briefing materials and analysis to support decision making, planning, and stakeholder communications
• Build strong working relationships across supervisory, policy, IT, communications, and enabling teams

What you need to succeed

• Strong written and verbal communication skills, with the ability to clearly convey complex information to diverse audiences
• Proven ability to plan, organize, and prioritize work in a fast‑paced environment with competing demands
• Sound judgment and adaptability, balancing regulatory rigor with product agility
• Demonstrated ability to understand organizational context and impacts of change
• Ability to synthesize information from multiple sources, produce high quality analysis and clearly articulate business relevance
• Strong collaboration and stakeholder engagement skills across all organizational levels
• Ability to identify process inefficiencies and propose and implement practical improvements
• Comfort using data, analytics, and AI‑enabled tools to enhance analysis, identify patterns, explore scenarios, and support evidence‑based decision‑making

Nice-to-have

• Knowledge of agile approaches, particularly as they relate to product lifecycle support and backlog prioritization

Your education and experience

The position requires a bachelor’s degree in public administration, business administration, economics, or a related discipline, combined with at least 5 years of relevant experience involving complex business or process analysis related to products, operations, or technology‑enabled transformation or an equivalent combination of education and experience may be considered.

Innovative Mindset

We value candidates who demonstrate adaptability, curiosity, and a willingness to learn new technologies, including AI and digital tools. We seek individuals who can think critically about data, question existing processes, and find ways to simplify our work while embracing change and new ways of doing things.

Language requirement
The Bank’s work environment is conducive to the use of both of Canada’s official languages - English and French. Although the position language requirement is English or French essential, we do encourage everyone to improve their second language proficiency for future career growth and to contribute towards fostering a bilingual environment.

What you need to know

• • Priority will be given to Canadian citizens and permanent residents
  • Security level required: Be eligible to obtain Secret
  • There will be no relocation assistance provided
  • Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.

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 portion 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 12 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 $94,193 to $110,816 (job grade 16)
  • 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 and dental coverage that meets your needs
  • Extra vacation days (up to five each year) that you can purchase to add to your vacation entitlement
  • Option to join the indexed, defined-benefit pension plan after 24 consecutive months of service

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