Extract-Transform-Load
(ETL) Developer Co-op
Open to students registered in a recognized co-op program only
(Within the Greater Victoria area)
BC Pension Corporation, Victoria BC
- Duration: Fall 2023 + Winter 2024 (September 2023 - April 2024; 8 months)
- Location: Victoria (our office is situated on the Selkirk Waterfront on the Gorge Inlet. Enjoy stunning views of downtown Victoria and the Olympic mountains and take advantage of the nearby Galloping Goose Regional Trail for walking and biking).
- Salary: $1,819.12 bi-weekly (for students working towards a diploma or bachelor's degree) or $2,136.88 (for students working towards a post-graduate degree)
- Grant: As part of our inVESTED scholarship program, you may be eligible for reimbursement up to a maximum of $1,000 per four-month work term to cover the cost of co-op work term tuition fees.
- Hybrid Work Model: Employees are supported to work part of their time from home and part of their time on campus to encourage flexibility, performance and connection.
- Skills for Success Program: Engage with other co-op students in a monthly virtual event designed to build connection and community while developing skills to support your success.
- LinkedIn Learning: During your time working here, you will have 24/7 unlimited access to over 16,000 online courses to help support your personal, educational, and professional goals.
- Team: The Information Technology Engineering branch (ITE) provides the IT services to the BC Pension Corporation including Solution Design and Application Development & Maintenance, Release Management and Deployment.
Who We Are
BC Pension Corporation is one of the largest professional pension service providers in Canada. We serve over 685,000 active and retired members and more than 1,000 plan employers, paying out $500 million in benefits each month ($5.5 billion a year) to over 224,000 retirees. This is an opportunity to gain hands-on experience using Enterprise level technology which is not readily available.
The Job Responsibilities
Under the direction of the Technical Integration Manager and Senior Data Analytics Engineer, this position will perform a diverse set of tasks through all stages of the software development life cycle in support of our Operational Analytics program and Data Warehouse. This position is responsible for but not limited to the design, development, enhancement, maintenance, testing and execution of our Data Warehouse ETL pipelines:
- Architecting, developing, maintaining, and testing ETL solutions in a virtualized environment.
- Evaluating, prototyping, and rolling out new tools and technologies to improve the way we build products and help projects deliver to our customers.
- Designing, developing, troubleshooting, and executing scripts to automate tasks.
- Participating in testing, code reviews, quality assurance checks and post implementation reviews.
- Complying with team standards and best practices.
- Providing estimates for requested work.
- Documenting the above.
Learning Outcomes
The successful candidate can expect to gain experience in the following areas:
- Experience with modern data analysis technology
- Experience implementing ETL solutions using various tools as listed above (SQL, SSIS, SSRS, SSMS, PBIRS, Power Shell, Visual Studio)
- Experience with Software Development Life Cycle (SDLC) and Release Management practices
- Good understanding of day-to-day software development experience in a mid-size organization.
- Experience with code repositories such as GitHub and SVN
- Some exposure to Azure Cloud Services.
Requirements
This opportunity is available to 3rd or 4th year Computer Science and Software/Computer Engineering students and graduate level students studying Computer Engineering/Science or related fields. You will bring your enthusiasm to contribute, willingness to learn new skills and tools, strong sense of ownership, and your disciplined approach to software development. Knowledge and/or experience in any of the following areas would be an asset:
- Experience with Microsoft suite of tools such as SQL, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSMS (SQL Server Management Studio), Power Shell, Visual Studio.
- Experience creating SQL Database queries and packages.
- Exposure to Microsoft Azure and Power BI Service.
- Experience with Microsoft PBI Report Server (PBIRS).
- Experience with code repositories such as GitHub or SVN.
- Enjoy working in a team environment, developing consensus rather than going it alone.
- Ability to work independently as required but seek assistance when needed.
- Ability to analyze complex issues, develop and recommend options, and implement solutions.
- Comfortable giving your opinion respectfully in a group setting.
As part of your application, please upload the following documents (note: your application may not be viewed if you do not include all 3 required documents as per below):
- Cover letter
- Resume
- Transcripts (unofficial transcripts are accepted)
Testimonial
"I had two Co-op terms at BC Pension Corporation as a Test Automation Developer in 2018. It was through my Co-ops that I learned just how passionate I am about computer programming and automated software testing. Working in my role I was able to make significant contributions to the automated testing framework and increase test coverage. I was able to see the positive impacts of my work and how and it benefited my team and the corporation. Deciding that I wanted to continue with a career path in automated software testing, I was hired full time as an Intermediate Test Automation Developer after completing my degree in Computer Science at the University of Victoria. I have continued working here ever since and have obtained a position as a Senior Test Automation Developer. I strongly recommend a Co-op at BC Pension Corporation as a Test Automation Developer, especially if you are looking to develop your computer programming skillset."
- Dallas, Senior Test Automation Developer and UVIC Graduate 2019
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 co-op@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 co-op@pensionsbc.ca.
