Job Description

Overview

We are looking for a highly motivated, innovative, customer-focused analyst, with a keen interest in data-science, strategic analysis, and program evaluation to join our Analytics Data Services team which has been rated as one of the best in the Canadian public sector. As a Data Engineer 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're a team player and a strong communicator with sound problem solving and critical thinking skills.

Working closely with analysts and managers in the Analytics Data Services department and project teams, the student will 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- or eight-month full-time co-op student opportunity starting January 2023. WorkSafeBC has adopted a hybrid model offering opportunities to work remotely and onsite based on the operational needs of the position.

What you'll do

As an Data Engineer co-op student, you will:

• Ensuring stability of source applications is not impacted through the data ingestion process
• Ingesting relational, structured, semi-structured, and unstructured data from on premise, cloud, external, document, and other data sources
• Designing logical data models and turning them into physical data structures which turns "how applications store data" - modelling best practices
• Translating 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.)
• Sequencing and scheduling ETL scripts by understanding source data and data dependencies
• Performing quality assurance to ensure data meets entity and attribute quality requirements
• Proactively looking for opportunities to develop datasets to improve the end-to-end delivery of analytics or identification of business insights
• Monitoring platform metrics and health reports
• Developing data models, data dictionary definitions, and source-to-target mappings
• Identifying 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.

Your experience and educational background:

• Enrolled in any of the following majors or specializations: Computer Science, 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 (Hevo, Talend, Stich, 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.

Application instructions:

• A cover letter, resume and transcript are required.
• Submit all documents in one file (system accepts Word or PDF files).
• The posting will close at 4:30pm on the closing date of the competition.

If you require an accommodation in the assessment process, please email (SM) at the time you submit your application.

Who are we?

At WorkSafeBC, we're dedicated to promoting 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 also work diligently to sustain our workers compensation system for today and future generations. We're honoured to serve the 2.4 million workers and 255,000 registered employers in our province.

WorkSafeBC requires all employees to be fully vaccinated against COVID-19. In implementing the policy, WorkSafeBC will consider its obligations to accommodate those staff who are unable to be vaccinated.

We recognize that our ability to make a difference relies on building a team with a rich variety of skills, knowledge, backgrounds, abilities, and experiences, and which 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. We encourage all qualified applicants to apply.

What's it like to work at WorkSafeBC?

It's challenging, stimulating and hugely rewarding. Our positions offer tremendous diversity and excellent 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.

WorkSafeBC has adopted a hybrid model offering opportunities to work remotely and onsite based on the operational needs of the position.

Learn more about .

This position is restricted to those legally entitled to work in Canada.

Thank you, in advance, for applying.

To learn more about our co-op or student opportunities, meet and learn how her experience here helped her build her skillsets and expand her knowledge.