Sql server dba Jobs in Ottawa, ON

Data Analytics Specialist

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

Find out more about the next steps in our Recruitment process.

Did you know?
At the Bank, data is at the core of how we make decisions, manage performance, and continuously improve. Across operational and financial domains, we are generating increasing volumes of data from modern systems and platforms, creating powerful opportunities to enhance insight, quality, and outcomes through analytics.

What you will do
As a Data Analytics Specialist, you will play a hands on role in enabling insight through data, analytics, and technology enabled reporting. You will support both operational and enterprise level decision making by preparing, analyzing, validating, and communicating high quality analytical products.

You will:

• Integrate, prepare, transform, and validate data from multiple operational and financial systems using SQL, Python, and modern data platform capabilities.
• Develop and maintain analytical datasets, Power BI reports, dashboards, semantic models, and workspaces that support performance monitoring, quality management, planning, and decision making.
• Support recurring and ad hoc analytical and reporting requests, translating complex information into clear, actionable insights.
• Apply data governance standards and quality controls to ensure accuracy, consistency, and reliability of data.
• Collaborate with cross-functional partners (e.g., Finance, Operations, Digital Data Services) to identify analytics use cases and contribute to the design and improvement of data solutions.
• Contribute to continuous improvement by identifying opportunities to streamline reporting processes, enhance data quality, and adopt modern analytics tools.
• Write, optimize, and validate SQL queries and Python scripts to support data extraction, transformation, quality checks, automation, and reproducible analysis.
• Work with modern data platforms, including Databricks and Microsoft Fabric to support streamlined analytics workflows.
• Maintain Power BI reports by managing semantic models, measures, refresh schedules, workspace content, access permissions, and documentation in alignment with governance practices.
  

What you need to succeed
You are a self-starter with strong analytical skills who is comfortable working independently while collaborating with diverse stakeholders.

You bring:

• Progressive experience in data, analytics, or reporting roles, working with large, multi source datasets.
• Ability to query, join, aggregate, transform data from relational databases and analytical platforms to create comprehensive analyses and troubleshoot problems.
• Working knowledge of SQL, Python, or R for data analysis, data manipulation, automation, and validation of analytical logic.
• Demonstrated experience developing, maintaining, and enhancing Power BI reports and dashboards, including semantic models, DAX measures, pipelines and other Fabric solutions.
• Working knowledge of enterprise systems (e.g., SAP, financial or operational platforms).
• Familiarity with modern data platforms, including Databricks, Microsoft Azure, Microsoft Fabric, or similar cloud platforms, with an understanding of data pipelines, infrastructure, and governance.
• Strong attention to detail and sound judgment within established frameworks.
• Excellent written and verbal communication skills, with the ability to present analytical findings to non technical audiences.
• A collaborative, proactive mindset and a commitment to continuous improvement.
  

Your education and experience
This position requires a university degree in data analytics, finance, accounting, economics, business, or a related field, along with 5 years of relevant experience, or an equivalent combination of education and experience.

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. 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 Secret
• 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.

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, 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
• Indexed, defined-benefit pension

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