Apply now »

Data Warehouse Developer (Permanent)


Ottawa, ON, CA, K1P 5E7 Victoria, British Columbia, CA, V8Z 0B9

Onsite or Hybrid: 


Data Warehouse Developer (Permanent)

Victoria, BC or Ottawa, ON 


Underpinned by a deep understanding of technology integration, asset management, and specialist training, Babcock International works with customers around the world to improve the capability, reliability, and availability of their most critical assets within the key market sectors of Marine, Land, Aviation, and Nuclear.


In Canada, Babcock works in the Marine sector, where our teams provide critical and complex support to Canada’s submarine fleet. Our Canadian team is proud to be trusted to deliver key naval in-service support for the Royal Canadian Navy. We also operate in the Aviation sector, where Babcock ensures that the aircrew trainees of our partner nations receive the world’s best flying training. We deliver vital aerial emergency services and are proud to have been selected by the Government of Manitoba to deliver their wildfire suppression services, as well as key components of their critical air ambulance services.


Whether it is providing technical training instruction, developing training materials or maintaining critical training assets, Babcock is trusted by its customers to deliver world-class training solutions.


Babcock’s Purpose is to create a safe and secure world, together. Our Principles create the foundation for how we will do this. They keep us on the right course, unify the way we work and guide us towards success. By thinking, connecting, and acting in line with these Principles, we’ll deliver better outcomes for our Culture, Customers and Communities. Collectively at Babcock, our employees embody the Principles that help make us great at what we do:


  • Challenge the status quo, Be Curious, and ask, ‘how might we?’
  • Whenever measuring success, Think: Outcomes and positive impacts.
  • Be Kind to ourselves, each other, and our planet.
  • Babcock employees Collaborate – we are greater than the sum of our parts,
  • Be Courageous – be brave, ambitious, and determined.
  • Everyone has a part to play - Own and Deliver to be successful.


We encourage you to explore our Babcock Canada website to learn more about us at


In this role, you will:

  • Develop and maintain the Babcock Data Warehouse.  Includes but not limited to SSMS, SSAS and SSIS solutions.
  • Model various complex data sources using the Kimball methodology.
  • Provide data as a service to end users via the Data Warehouse.
  • Provides analytical and technical support for complex requests, projects, or initiatives.
  • Perform Database Administration tasks for the various Data Warehouse environments and objects.
  • Document and maintain the existing Data Warehouse environments.
  • Work with the business to ensure appropriate governance is applied and adhered to in accordance with IT best practices.
  • Carry out data validation with the Applications Manager to ensure reports are pulling all correct data accurately and achieving customer needs.
  • Where applicable, develop the reports within the existing Data Warehouse and ERP.
  • Develop reports and extract from multiple data sources.
  • Other duties as directed.


The ideal candidate brings:

  • 4+ years of relevant experience including experience with data repository design and maintenance and database administration and complex reporting analysis.
  • Technical and/or business experience with demonstrable professional growth.
  • Experience with problem and issue resolution preferred.
  • Minimum of 3 years’ experience of Data Warehouse technology - SSMS, SSIS, SSAS.
  • Thorough understanding of the Kimball data modelling methodology.
  • Minimum of 3 years’ experience of working with Microsoft technologies.
  • Experience of report writing using SQL, Crystal, Power BI, SSRS, Business Intelligence or other reporting tools is preferable.
  • Good organization skills with the ability to prioritize multiple activities and objectives in a rapidly changing environment, while delivering quality service.
  • Strong analytical and critical thinking skills.
  • Strong collaboration and consulting skills, committed to providing exceptional customer service and responding to user needs in a prompt, courteous manner.
  • Strong written, verbal and presentation skills with the ability to communicate complex technical issues in terms clearly understood by technical and non-technical audiences.
  • Technical writing skills with experience in gathering and documenting user requirements and the ability to produce documents ranging from specifications to user manuals.
  • Self-motivated, self-directed and independent thinking as well as an effective team player.
  • Experience working in a large-scale organization with ERP systems desired.
  • Good knowledge of word processing, spreadsheet, and presentation computer programs, preferably Microsoft.
  • You are eligible for a Canadian Secret Security and ITAR Clearance


Babcock Canada supports the safety and wellbeing of our employees through the following programs:

  • Contributions towards an employee’s physical and mental health
  • Wellness days
  • Supportive work life balance: flexible work schedule and competitive annual vacation time off
  • Comprehensive health and dental benefits
  • Pregnancy and Parental Leave top-up available
  • Employer matching of employee retirement contribution
  • Employee recognition and bonus programs
  • Support of professional development and reimbursement of membership dues
  • Relocation assistance for individuals and families


Babcock is committed to promoting a workforce without boundaries. One that welcomes everyone to contribute to our success regardless of race, nationality, colour, religion, sex, gender identity or expression, sexual orientation, disability, or age. If you require accommodation during any stage of our recruitment process, please let us know how we can assist you.


Applicants, please apply online at



Job Segment: Data Warehouse, DBA, Business Intelligence, Database, Technical Writer, Technology

Apply now »