Job Description

OverviewAre you passionate about creating re-usable analytics datasets which are used to optimize business decisions, provide departmental oversight, track the success of our business objectives, and explore the next new business improvement insight?In this role, you will be responsible for ensuring the quality, timeliness, availability, and design of data for analytics at WorkSafeBC.How youll make a difference: Youll turn data into knowledge that benefits workers and employers across B.C.Where youll workWorkSafeBC, 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, youll work primarily from your B.C. home and occasionally in our Richmond office.What you\'ll doAs a data engineer you will:

• Ingest a wide variety of data in data platforms for analytics
• Create datasets for analytics by designing logical data models and turning them into physical data structures
• Build and maintain ETL pipelines by sequencing and scheduling ETL scripts
• Ensure analytics-ready data is of sufficient quality to make critical operational, tactical, and strategic business decisions
• Contribute and work under the parameters of organization data governance, security policies, and privacy requirements
• Administer analytics data platforms by working with various technology professionals
• Develop resources which aid analytics data platform users by developing data models, data dictionary definitions, and source-to-target mappings
• Conduct impact analysis for upstream application changes
• Maintain a strong relationship with analytics solution technology and analytics delivery teams

Is this a good fit for you?Were looking for someone who can:

• Demonstrate ability to independently organize and prioritize a fluctuating workload, delegating where appropriate, while maintaining accuracy and timelines
• Demonstrate ability to teach, mentor and lead others, ensuring knowledge transfer within the workgroup
• Demonstrate ability to establish and maintain credibility within and outside of the immediate team through collaboration and using one's own expertise to deliver high quality results
• Demonstrate ability to elicit business requirements using interviews, document analysis, requirement workshops, surveys, site visits, business process descriptions, business cases, scenarios and workflow analysis and make appropriate recommendations or decisions in a proactive manner
• Demonstrate ability to use a variety of computer-based business intelligence reporting, dashboard, and other tools to create medium to high-complexity end-user solutions
• Demonstrate working knowledge of relational database systems, concepts, structures and business and technical models
• Demonstrate specialist knowledge of creating scripts/jobs/packages to extract data from sources, transform data, and load data into data stores for use in business intelligence, whilst ensuring a high degree of data integrity, data quality, data store performance, storage efficiency and other requirements
• Demonstrate working knowledge of logical design and data modeling, ideal for use in business intelligence solutions, including entity relationship diagrams, source-to-target mappings, data dictionaries, and understanding end-to-end data lineage from the originating source to the end solution to determine impacts of changes

Your background and experience

• A degree in Computer Science or STEM (Science, Technology, Engineering, Math)
• A minimum of 3 years of analytics-related experience, inclusive of a minimum of 2 years in a role building SQL/ETL for analytics data platform
• Well consider an equivalent combination of education and experience.

Important to knowBefore we can finalize any offer of employment, you must:

• Consent to a criminal record check
• Confirm youre legally entitled to work in Canada

WorkSafeBCs COVID-19 Employee Mandatory Vaccine Policy (the Policy) 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 we areAt 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 or diseases occur, we provide compensation and support injured workers in their recovery, rehabilitation, and safe return to work. Were honoured to serve the 2.49 million workers and 263,000 registered employers in our province.Whats it like to work at WorkSafeBC?Its 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 .Our benefitsAs a member of our team, youll have access to services and benefits that help you get the most out of work and life. Along with a competitive salary, your total compensation package includes:

• Defined benefit pension plan that provides you with a lifetime monthly pension when you retire
• 3 weeks of vacation in your first year, with regular increases based on years of service
• Extensive health care and dental benefits
• Optional leave and earned-time-off arrangements
• Development opportunities (tuition reimbursement, leadership development, and more)

Learn more: Find out .Salary: $43.57 - $54.91/hourlyWant to apply?

• Applications are welcomed immediately, however must be received no later than 4:30 p.m. PST on the closing date.
• Please note that we will be starting assessments prior to the closing date.

We encourage all qualified applicants to apply. If you require an accommodation in the assessment process, please email when you submit your application.Any additional application materials must be received by email to by 4:30 p.m. PST on the closing date of the competition.

WorkSafeBC