Data warehouse engineer Jobs in Ottawa, ON

Data and 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.

What you need to know
Join our Data and Digital Services (DDS) department which provides data and analytical support across several areas of the organization. Our work ensures that economists and researchers in the monetary policy and financial system departments have efficient access to accurate, coherent, relevant, timely and interpretable data. We also provide support financial markets data used in operations and research, while expanding our capabilities to support business administration areas such as Human Resources, Corporate Services and Cyber Security.

Our teams provide a broad range of data, statistical and analytical services through centralized support and product-line teams. Our solutions span automated data pipelines, data modelling, data quality, analytical models, APIs, dashboards and integrated data and analytics products, supporting both analytical needs and business decision-making across the Bank.

Our product lines operate using agile principles and bring together users from across the Bank, partners in Information Technology Services (ITS), colleagues within our data function and external partners to deliver solutions that respond to evolving business needs.

What you will do
Under the guidance of a Lead, you will develop, deliver, and maintain meaningful enhancements to dana and product lines, applying development best practices and creative approaches to meet user needs.

More specifically, you will:

• Develop and deploy high-quality data and analytic solutions for client departments or product lines, applying best practices in solution development, data modeling, data quality, visualization and dissemination
• Support, enhance, and integrate existing data and analytical solutions to meet evolving business needs.
• Contribute to recommendations for client departments on data quality and analytical solutions
• Collaborate with colleagues and actively participate in agile practices and team ceremonies.
• Work closely with DDS, ITS and other partners within and outside the Bank to implement best practices, share knowledge and improve solutions.

What you need to succeed

• Strong quantitative and analytical skills, with proficiency in at least one statistical or analytical programming language, such as Python or R.
• A solid understanding of coding and DevOps principles, along with experience developing data and analytical solutions and working with SQL databases.
• The ability to translate analytical needs into effective technical solutions, with a strong focus on client needs.
• Experience developing technical workflows that incorporate automation, improve data quality and deliver clear, accessible results.
• Strong communication and collaboration skills, with the ability to build relationships and explain technical concepts to both technical and non-technical audiences.
• The ability to thrive in an agile environment, contribute constructively to team discussions, adapt positively to change and manage competing priorities.
• A creative and innovative mindset when approaching data and analytics challenges.
  
  

Nice-to-have

It would be an asset if you have:

• Worked in an Agile / Scrum environment
• Familiarity with Business Intelligence tools
• Knowledge of cloud platforms such as Azure and orchestration tools such as Data Factory
• Worked with securities data, including developing financial market applications and visualisations.

Your education and experience
The position requires a college diploma or university degree in statistics, mathematics, computer science, economics or related field along with a minimum of 2 years of relevant experience. 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 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.

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 $74,981 to $88,213 (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
• 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.