Share this Job
Requisition Number:  4599
Position Type:  Permanent
Position Length:  Indeterminate

Various locations, CA

Closing Date:  30 September 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 to discuss how.

ETL Developer/Senior Developer

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


What you will do 
We are currently seeking Extract, Transform and Load (ETL) one Developer (16) and one Senior Developer (17) to join the Financial Market & Banking Operations (FMBO) Portfolio in the Information Technology Services (ITS) Department. 


Note: Our positions are to be filled either at our Head Office location in Ottawa or at our Calgary Operational site depending on selected candidate preference.


Reporting to the Assistant Director, Business Solutions & Architecture, you will be part of the data scrum team to support existing and deliver new ETL applications and jobs using DataStage tool suite, within the overall FMBO Data Warehouse platform. Adopting an agile and DevOps mindset, you will design, develop, test, optimize and secure DataStage application and jobs, following industry best practice. You will also support DataStage configuration relating to FMBO applications and job.


As a Developer / Senior Developer, you will: 

  • Assist in debugging issues during the project cycleAnalyze, design and implement enhancements to meet business requirements 
  • Perform technical and root-cause analysis on issues and make recommendations for correction
  • Analyze diagnostic information about uncommon cross-functional problems and provide recommendations for resolution to more senior colleagues or management
  • Create working procedures and documentation on solutions and populate knowledge databases such as the wiki, testing plans and results
  • Look for new ways of doing or providing services to our clients; changing or reconfiguring approaches to improve efficiency and capacity
  • Write unit test cases and implement pipelines to automate code validation 
  • Implement monitoring and alerting solutions 
  • Build automation scripts and workflows 
  • Contribute to sprint goals and coordinate with your team by participating in daily scrums 
  • Provide third-line support, including On-Call, shift and weekend work as required


What you need to succeed

  • hands-on work experience supporting applications with high criticality, availability, reliability and security requirements
  • experience working in Agile Teams ability to explore new applications, cloud based or on-prem to solve evolving business needs
  • knowledge of executing and tracking incident requests to their resolution
  • ability to rank tasks per priority, meet deadlines and perform multiple tasks concurrently
  • ability to work effectively and maintain positive and co-operative working relationships with the other project members and IT teams
  • ability to work in a fast-paced environment with dynamically changing priorities



  • experience with Unix/Linux operating systems
  • knowledge of Python, Spark/Pyspark 
  • hands-on work experience Cloud technologies


Your education and experience
The position requires a bachelor’s degree or diploma in computer science, information technology, or computer engineering, a minimum of five years of hands on experience with software and database development and a minimum of three years of experience with DataStage, or an equivalent combination of education and experience may be considered. 


As a Senior Developer role, we expect that you have participated in delivering multiple projects using DataStage, and demonstrated experience in DataStage configuration and setting standards and best practice.



What you need to know

  • Language requirement: English or French essential
  • Priority will be given to Canadian citizens and permanent residents
  • Security level required: 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.
  • 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


ETL Developer

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


ETL Senior Developer

  • Starting salaries are based on qualifications and experience and typically range from $83,900 to $104,800 (job grade 17). 
  • Depending on performance, you may be eligible for performance pay for successfully meeting (7 to 10% of your base salary) or for exceeding expectations (15% 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, 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 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.