Job Description

Overview

The Analytics Data Services department of WorkSafeBC is looking for one highly motivated, innovative, and customer-focused Co-op student, Data Engineer, with a keen interest in data-science, strategic analysis, and program evaluation to join our team to help us strive towards our vision.

As a co-op student, you\'ll contribute to the effectiveness of WorkSafeBC by creating, administering, and delivering data platforms (e.g. data warehouse, data lake) for analytics use.You will also assist in building and maintaining the entire end-to-end data for analytics pipeline including: ingesting data from a variety of data sources, creating datasets for analytics purposes, ensuring quality, security and privacy of analytics-ready data, and optimizing of analytics delivery.

This is a four-month temporary opportunity beginning in May 2023 with a possibility of extending to 8 months.

How you\xe2\x80\x99ll make a difference: You\xe2\x80\x99ll apply what you\xe2\x80\x99ve learned in your post-secondary program to benefit workers and employers across B.C.

Where you\xe2\x80\x99ll work

At WorkSafeBC, we offer a hybrid work model that combines the convenience of working remotely with the dynamism of working in one of our offices, based on the operational needs of the position.

In this role, you\xe2\x80\x99ll work primarily from your B.C. home and at a minimum of once per month in our Richmond office.

What you\'ll do

• Ensure stability of source applications is not impacted through the data ingestion process
• Ingest relational, structured, semi-structured, and unstructured data from on premise, cloud, external, document, and other data sources
• Design logical data models and turn them into physical data structures which turns \xe2\x80\x9chow applications store data\xe2\x80\x9d \xe2\x80\x93 modelling best practices
• Translate structured, semi-structured, and unstructured data into analytics ready data structures using a variety of data warehousing programming languages and technology (e.g. SQL, Python, Informatica, Talend, etc.)
• Sequence and schedule ETL scripts by understanding source data and data dependencies
• Perform quality assurance to ensure data meets entity and attribute quality requirements
• Proactively look for opportunities to develop datasets to improve the end-to-end delivery of analytics or identification of business insights
• Monitor platform metrics and health reports
• Develop data models, data dictionary definitions, and source-to-target mappings
• Identify and define problems, develop and describe research questions, and develop sound and novel approaches to problem solving and propose recommendations and business solutions.

Is this a good fit for you?

We\'re looking for someone who can:

• Demonstrate strong analytical and problem-solving skills.
• Demonstrate strong teamwork and collaboration skills.
• Demonstrate strong organization skills.
• Build solid relationships with internal and external customers.
• Communicate effectively both in writing and verbally.

Learn more: on what it\xe2\x80\x99s like to work here.

Your background and experience

• Enrolled in any of the following majors or specializations: Computer Science, Technology, Engineering, Consulting & Strategic Management, Business Technology Management (

), Business Analytics and Decision Making, Data Science, Finance - , Accounting, Statistics/Mathematics, or Operations Management/Research, or Business Analytics. * Strong proficiency in Microsoft Office: MS Excel, PowerPoint, Access, SharePoint, Visio, Adobe Suite, Outlook.

• Experience in database development, ETL/Data integration tools (e.g., Hevo, Talend, Stich, data factory, MS Azure Stack, etc.); database and cloud computing design, architectures and data lakes; reporting or statistical tools would be an asset: Power BI, SSRS, SQL, Tableau, Business Objects / SAP - Web Intelligence, Xcelsius, Crystal Reports, SPSS, SAS, Python, R, Microstrategy, Microsoft Reporting Services, Performance Point.

Important to know

Before we can finalize any offer of employment, you must:

• Confirm you\xe2\x80\x99re legally entitled to work in Canada
• Confirm you\xe2\x80\x99re a registered student at a post-secondary institution and is participating in a work integrated learning program
• Consent to a criminal record check and successfully meet the criminal record check clearance

WorkSafeBC\xe2\x80\x99s COVID-19 Employee Mandatory Vaccine Policy (the \xe2\x80\x9cPolicy\xe2\x80\x9d) is suspended effective January 9, 2023, however we reserve the right to re-implement it in response to changes in the public health landscape, including public health orders. We are committed to the protection, health, and safety of our employees and our Communicable Disease Prevention Program and related protocols remain in effect.

Who are we?

At WorkSafeBC, we promote safe and healthy workplaces across British Columbia. We partner with workers and employers to save lives and prevent injury, disease, and disability. When work-related injuries and diseases occur, we provide compensation and support injured workers in their recovery, rehabilitation, and safe return to work. We\xe2\x80\x99re honoured to serve the 2.49 million workers and 263,000 registered employers in our province.

What\xe2\x80\x99s it like to work at WorkSafeBC?

It\xe2\x80\x99s challenging, stimulating, and rewarding. Our positions offer diversity and opportunities for professional growth. Every day, the work we do impacts people and changes lives. What we do is important, and so are the people we do it for.

Our ability to make a difference relies on building a team with a rich variety of skills, knowledge, backgrounds, abilities, and experiences that reflects the diversity of the people we serve. We are committed to fostering a welcoming, inclusive, and supportive work culture where everyone can contribute as their best, authentic self.

Learn more: Discover .

Want to apply?

• A cover letter, resume and transcript are required. Your cover letter should state your availability (either four or eight months).
• Submit all documents in one file (either Word or PDF files).
• Applications are welcomed immediately, however must be received no later than 4:30 p.m. PST on the closing date.
• We encourage all qualified applicants to apply. If you require an accommodation in the assessment process, please email

(SM) when you submit your application.

WorkSafeBC