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 you\xe2\x80\x99ll make a difference: You\xe2\x80\x99ll turn data into knowledge that benefits workers and employers across B.C.Where you\xe2\x80\x99ll 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, you will work primarily from our
Richmond office
with some flexibility to work from your home in B.C.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?We\xe2\x80\x99re 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
• We\xe2\x80\x99ll consider an equivalent combination of education and experience.

WorkSafeBC