Share this Job
Requisition Number:  4295
Position Type:  Term
Position Length:  Until December 31, 2022
Location: 

Ottawa (Downtown), ON, CA

Closing Date:  August 12, 2020 - 23:59 EST

Diversity and Inclusion
As one of Canada’s Top 100 Employers, we offer you a superior work environment that allows you to reach your full potential both professionally and personally. 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.

Contact accessiblecareers@bankofcanada.ca to discuss how.

Data Engineer


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 a diverse and inclusive organization with significant impact on the economic and financial well-being of all Canadians. You will be challenged, energized and motivated to excel in an environment where we are reinventing central banking, renewing ways of doing business and reinforcing a culture of innovation.

 

Find out more about the next steps in our Recruitment process

 

Did you know?
The Bank is undertaking an evolution of its data management infrastructure and exploring new data and analytics technologies (i.e. machine learning, AI, RPA) to empower the next generation of economic analysis and insight. This role will be present as our current data and analytic infrastructure is enhanced to meet the demands of a modern data-centric Central Bank. 

 

What you will do 
The Bank of Canada’s Information Technology Services (ITS) Analytics Environment and Currency Portfolio provides the applications, software and hardware to support the business functions of the Bank’s Currency and Economic departments.
As a data engineer (DE) within the Analytics Environment and Currency Portfolio you are part of a dedicated and innovative team that maintains, integrates and builds solutions key to our internal and external stakeholders. 

 

As part of the evolution of the workforce, “Data” is a critical skill area that is increasingly and broadly required at the Bank. The DE role will bridge the gap between the infrastructure Database administrators (DBA), the Application Architects and the Developers. The focuses are on obtaining data from a variety of different sources, in the right formats and data quality standards, resolving any information flow or content issues and ensuring data transformation using various types of data processing pipelines. 

 

You will collaborate with architects, scrum masters, product owners, and other team members in an Agile environment to deliver maintenance support, testing services, bug fixes, and optimizations of existing application integrations, and to engineer and support data pipelines from acquisition to discovery. You will write automated tests for new and existing software systems and report to your team daily by participating in scrums and stand-ups.  You will also take an active role in performing code reviews and feature analysis as well as participate in product feature discovery and technical experiments. Finally, you will support and develop APIs to enable the simple sharing of data internally and externally. 

 

You will: 

  • Work closely with architects and take ownership of the development and implementation of data processing solutions that support high performing and scalable data pipelines
  • Provide input on infrastructural decisions pertinent to data and database systems
  • Develop, maintain and troubleshoot complex data ETL / ELT processes, jobs, schedules etc. (including writing scripts, calling APIs, write SQL queries, etc.) and build ETL processes ingesting data into BI stores
  • Identify, design, and implement internal process improvements – optimize the delivery/quality/reliability of our data and automating manual processes
  • Collaborate with wider IT teams to make sure that data engineering solutions fit into IT infrastructure and support corporate standards and practices
  • Work closely with data scientists, data analysts and other data consumers to help resolve their data needs
  • Analyze data-related system integration challenges and design and implement appropriate solutions
  • Design databases key and indexing schemes and designs partitioning 
  • Participate in the implementation of operational data stores, data lakes. and data marts 
  • Document and Translate user requirements into technical designs and implementations
  • Create quality ERD’s (entity-relationship diagrams) and system documentation 
  • Implement security and recovery tools and techniques as required 
  • Work with other development teams to review and approve database changes according to database design standards and principles 
  • Resolve conflicts between models, ensuring that data models are consistent with the Bank’s enterprise 
  • Integrate data from one or more source systems into data repositories that are optimized for reporting and analytics

 

What you need to succeed
You are a curious, rational and critical thinker who by nature loves to dig deeper on problems and always questions the “why”.  As an effective communicator, you have the ability to articulate your thoughts in a clear and concise manner. You have a team and security first mentality and can naturally step in to support your co-workers. You prefer to utilize best practices when building integrations to third party systems. 

 

  • Advanced knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases
  • Data modeling experience with different tools (Dimensional and 3rd Normal Form, Erwin, ER Studio, Enterprise Architect etc.)
  • Strong background in Database administration or design 
  • Experience with at least one visual ETL tool 
  • Experience in using Enterprise BI tool such as Cognos, Power BI, Tableau, Qlik client-side report authoring and/or server-side administration
  • Experience developing Data Quality processes: data profiling, unit-testing etc.
  • Experience in the DevOps best practices such as GIT source control, continuous integration lifecycle such as Jenkins, Bamboo and such
  • Experience with deploying and maintaining data infrastructure in the cloud 
  • Experience implementing / administering continuous integration/delivery process 
  • Experience with deploying and maintaining data infrastructure in the cloud 
  • Experience implementing / administering continuous integration/delivery process

 

Your education and experience
The position requires a bachelor’s degree in Computer Science, Information Systems, or other related field and a minimum of 5 years of experience in data engineering, data science, or software engineering, including knowledge of Big Data ecosystem. 

What you need to know

  • Language requirement: English or French essential
  • Priority will be given to Canadian citizens and permanent residents
  • Security level required: 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.
  • In response to the COVID-19 pandemic and further to public health guidelines, preventative measures are being taken to ensure health and safety during the recruitment process. All interviews are conducted via Skype.  

 

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

 

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 $79,100 to $93,000 (job grade 16)
  • Depending on performance, you may be eligible for performance pay for successfully meeting (5 to 7% of your base salary) or for exceeding expectations (10% of your base salary). 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 strive to make our policies, programs and workplace more inclusive, respectful and barrier-free. We encourage applications from women, Indigenous peoples, veterans, persons with disabilities, members of visible minorities and persons of all races, ethnic origins, religions, abilities, sexual orientations, and gender identities and expressions.