BC Pension Corporation

Data Analytics Engineer


Branch: Information Technology Services

Job Type: Regular/Full Time

Classification: Information Systems R27

Union/Excluded: BCGEU

Salary Range: $74,514 to $85,057 per annum (Salary includes a temporary market adjustment of 6.6%)

Security Clearance: Required

Competition: PC20:47244


Closing Date: January 29, 2020

Geographically Restricted: No


Why work with us?

At BC Pension Corporation, we are committed to our people. We are an organization with wellbeing at its core; offering an outstanding workplace experience where all employees can achieve their full potential.  Some highlights of what we offer include:

  • Flexible work schedules (mobility work, modified work weeks, job sharing, etc.)
  • Competitive compensation
  • Ongoing training and professional development opportunities
  • Comprehensive extended health and dental benefits for you and your family, including 100% employer paid MSP premium coverage
  • Defined benefit pension program
  • Health & wellness programs – lunchtime seminars, community health activities (yoga, kayaking, etc.) and a comprehensive Employee & Family Assistance Program

One in nine BC citizens is a member of one of the five pension plans we serve 

To learn more about us and how you can be a part of a culture that encourages innovation, continuous improvement and a passion for delivering an outstanding customer experience, visit bcpensioncorp.ca 


What is the opportunity?

The Data Analytics Engineer reports to the Assistant Director, (AD) Solution Engineering within the Information Technology Services branch. Working with both internal and external providers, this position provides technical guidance, consultation, development and implementation to enable data analytics and insights across the enterprise. This position will develop and implement governance, standards and practices for the technology supporting analytics in the corporation. This position will also provide hands on support to deliver the required data to the analytics team while remaining compliant to the corporation's responsibility to protect personal information. This position has broad technical expertise across multiple technology stacks related to data acquisition and transformation.

What do you need to succeed?


  • Bachelor's Degree in Software or Computer Engineering or related field required and four years of recent related experience in a hands-on data storage design or data management role.
  • An equivalent combination of education, training and experience may be considered.
  • Demonstrated recent experience that includes:
    • Data warehousing, database creation and on-going maintenance, and establishing Extract-Transform-Load (ETLs) between data sources.
    • Systems design, architecting and defining and implementing data strategy.
    • Developing data models, data marts, and writing queries in an enterprise data warehouse environment such as Oracle or MS SQL Server.
    • Utilizing Microsoft Power BI.


  • Demonstrated recent experience that includes:
    • Architecting, developing, and/or maintaining technical solutions in virtualized environments.
    • Determining appropriate use of various problem structuring methods and statistical methods for sampling, distribution assessment, bias and error.
    • Using programming languages, such as Visual Studio (C#) for data transformation activities.
    • Data validation, cleansing and normalization of structured dataset, performing data lineage and aggregation, data replication, and data manipulation.
    • Leveraging large structured and unstructured data sources.
    • SQL server tools such as SSRS and SSIS.
    • Jira and Confluence.

Interested in applying?

To learn more about the Data Analytics Engineer position, please review the job description at the bottom of this page.


Your resume must provide detailed information about your education and employment history in order to clearly demonstrate how you meet the job requirements as listed above.  Please ensure your resume includes the month and year(s) for each job in your employment history as well as the job related responsibilities.


Please submit your application through the "apply now" feature located at the top of this page.


Important details

If you are unable to access the links, please contact us by email at jobs@pensionsbc.ca.

Lesser qualified applicants may be appointed at a lower level.  An eligibility list may be established. Testing may be required. 

We thank you for your interest in working with us. You will be informed of your status in this competition as soon as possible.

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, sex, 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 an accommodation due to a disability, 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