BC Pension Corporation

Hybrid Database Engineer/Developer

Job Type Location

Regular full time

Victoria, BC Canada

Competition Union/Excluded



Salary Range Criminal Record Check

Up to $114,400 per annum


Closing Date

April 3, 2023


An eligibility list to fill future vacancies may be established.

Why choose us?

There is more to Pension Corporation than you might think. We are an award-winning organization with meaningful purpose-driven work, where staff have impact and create peace of mind for those we serve. We have cultivated an outstanding community rooted in respect, where employees are inspired to have courage, take action, and be at their best every day.

Our new nine-year strategic plan, Plan 20|30: Our Future is Insight, will guide us from 2021 to 2030. To learn about our aspirations and objectives and how you can be a part of a people-focused organization that is grounded in operational excellence, visit bcpensioncorp.ca.

What we offer:

  • A variety of work options (modified workweek, on-campus work, or a hybrid of home/on-campus)
  • Incredible campus with collaboration spaces, sit/stand desks, and lots of natural light
  • Ongoing training and professional development opportunities and scholarship programs
  • Comprehensive extended health and dental benefits for you and your family
  • Defined benefit pension program
  • Health & wellness programs - lunchtime seminars, community activities and a comprehensive Employee & Family Assistance Program
  • Opportunities to give back to the community and support not-for-profits
  • Seasonal events and socials
  • A robust awards/recognition program
  • Discounts on BC Transit passes, travel and accommodation, cell phones and plans, and more

BC Pension Corporation is committed to the health and safety of our employees and is taking every precaution against COVID-19 while supporting our culture of community and connection in our hybrid workplace. We have implemented a COVID-19 Vaccination Policy that requires all new employees, as a condition of their employment, to confidentially self-disclose to the Corporation that they are fully vaccinated (two COVID-19 vaccinations). Details about the COVID-19 verification process will be provided at the time of offer.

Hybrid Work Model

This position is located in our Victoria, BC office. You will have the opportunity to work part of the time on-campus and part of the time off-campus. Guidelines and requirements for in-office presence are determined by operational need and vary according to the unique needs of each business area.

The opportunity

We are seeking a Hybrid Database Engineer/Developer to join our team in VICTORIA, British Columbia, Canada

The Hybrid Database Engineer/Developer is part of the Data Warehouse Services team within the IT Engineering (ITE) Branch. The Hybrid Database Engineer/Developer plays a pivotal role in building and operationalizing the data necessary for the enterprise data and analytics initiatives following industry standard practices and tools. The bulk of the position's work is building, managing, and optimizing data pipelines, moving them into production for key data and analytics consumers (such as business/data analysts, data scientists or any persona that needs curated data) for data and analytics use cases across the enterprise.

The position collaborates with other data professionals to optimize the quality, security and governance of data models and algorithms, putting them into production for large productivity gains.

What do you need to succeed?

Must have

  • University degree in Computer Science or related discipline and five years of related experience; OR
  • Diploma in Computer Science or related discipline and six years of related experience; OR
  • Certificate in Computer Science or related discipline, or program completion, and seven years of related experience; OR
  • An equivalent combination of education, training and related experience.
  • Related experience must include strong experience in two or more of the following:
    • Working with large, heterogeneous datasets in building and optimizing data pipelines, pipeline architectures and integrated datasets using traditional data integration technologies. These should include ETL/ELT, data replication/CDC, message-oriented data movement, API design and access and upcoming data ingestion and integration technologies such as stream data integration.
    • Working with Azure Data Services and Data Storage.
    • Working with data governance/data quality and data security teams and specifically information stewards and privacy and security officers in moving data pipelines into production with appropriate data quality, governance and security standards and certification.
    • Popular database programming languages including SQL, PL/SQL, T-SQL for relational databases and upcoming NoSQL databases like MongoDB, Cosmos, PostgreSQL and others for nonrelational databases.
    • Working with both open-source and commercial message queuing technologies such as Azure Service Bus, stream data integration and stream analytics technologies.
    • Various Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance, Metadata Management.
    • Basic experience working with popular data discovery, analytics and PowerBI software and others for semantic-layer-based data discovery.
    • Basic experience working with DevOps capabilities like version control, automated builds, testing and release management capabilities using tools like GitHub, Jenkins, Ansible.

Preference may be given for those with:

  • Experience working with MS SQL Server, Azure Data Services and Data Storage.
  • Experience with data-integration/ETL code in an enterprise data-warehouse environment.
  • Demonstrated success in working with both IT and business while integrating analytics and data science output into business processes and workflows.
  • Experience in agile methodologies and capable of applying DevOps and increasingly DataOps principles to data pipelines to improve the communication, integration, reuse and automation of data flows between data managers and consumers across an organization.

To learn more about the Hybrid Database Engineer/Developer position, please click the link to the job description at the bottom of the page.

Application requirements

Cover letter: Please do not submit a cover letter; it will not be reviewed.

Resume: A resume is required as part of your application. Ensure your resume includes your education, the start and end dates (month and year) of your employment, and any relevant information that relates to the job requirements.

Questionnaire: As part of the application process, you will be prompted to complete an online questionnaire to demonstrate how you meet the job requirements. Responses will be used to shortlist applicants against the job requirements. Please allow approximately 15 minutes to complete this questionnaire.

Please submit your application through the Apply Now feature on this page.

Applications will be accepted until 11:59pm PST on the closing date referenced above. Late applications will not be considered.

Diversity & Inclusion

BC Pension Corporation is an equal opportunity employer committed to establishing an inclusive, equitable, and accessible environment for all. All qualified applicants will receive consideration for employment without regard to race, national origin, age, religion, disability, sexual orientation, gender identity or expression, marital status or any other basis protected by applicable law.

We are committed to ensuring that reasonable accommodations are made available to persons with disabilities during the recruitment, assessment and selection processes and will provide reasonable accommodations upon request. If you require assistance or accommodation due to a disability, please email us at jobs@pensionsbc.ca.

Thank you for your interest in working with us. We will let you know about your status in this competition as soon as possible. If you have questions about this opportunity, please email us at jobs@pensionsbc.ca.

Full Job Description
BC Pension Corporation
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
Corporate Hiring Process Resume Tips Interview Tips Employment/Application FAQs