ISL 27R - Senior Analytics Data Engineer

Government of British Columbia; Burnaby; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A provincial government agency in Burnaby is seeking a Sr. Analytics Data Engineer to manage data integration for their mission-critical Data Warehouse and Analytics Data Platform. The successful candidate will have a degree in computer science and at least 2 years of experience, particularly in ETL, SQL, and various databases. The role may offer flexible work arrangements.

Benefits

Competitive benefits

Flexible work arrangements

Professional development opportunities

Qualifications

• Minimum of 2 years of related experience required.
• Experience must be within the last 5 years.

Responsibilities

• Manage extraction, transformation and loading of data.
• Support regular and ad-hoc data analytics.
• Design the data pipeline based on business requirements.

Skills

Experience with ETL tools

SQL

Experience with various databases

SOAP or REST APIs

Education

Degree or diploma in computer science or information technology

Tools

Tableau

Power BI

Talend Data Integration

Cloud-based data warehouse solutions

Job description

Overview

About the BCLDB: The BC Liquor Distribution Branch (LDB) is one of two branches of government that provide oversight for the beverage alcohol and non-medical cannabis industries in the province. The LDB is responsible for the wholesale distribution of liquor and cannabis, and operates the retail brands BCLIQUOR and BC Cannabis Stores.

The LDB is committed to government’s goals of making life better for people in B.C., improving services, and ensuring a sustainable province for future generations. The revenue generated by the LDB helps fund essential public services like health care, education, and community programming. Learn more on the LDB careers page.

LDB’s Information Technology (IT) team consists of 7 competency areas: Customer Experience, Infrastructure & Operations (I&O), Information Security, Enterprise Architecture, Software Services, Data Services, and IT Program Governance. Currently 4 divisions managed by IT Directors collectively are responsible for all of the 7 competency areas to deliver the IT mandate of supporting LDB’s corporate and business operations and enabling future needs and initiatives.

At present, the IT team consists of more than 260 full-time employees and includes a sourcing strategy to leverage external expertise to ensure the integrated IT team continues to deliver LDB’s strategic initiatives timely and in high quality.

IT department of the LDB is responsible for the entire computing infrastructure for all of the 230+ BC Liquor Stores, BC Cannabis Stores as well as LDB’s head office in Burnaby and 4 Warehouse/Distribution Centres including Delta, Kamloops, Richmond, and Victoria. IT department also manages three data centres located in Burnaby, Delta and Kamloops.

Position

Sr. Analytics Data Engineer — Reporting to the Senior Manager, Data Analytics Governance, this role provides technical and analytical skills for development, enhancement, installation, administration, and maintenance of the organization’s mission critical Data Warehouse (DW) and Analytics Data Platform, focusing on Data Integration using modern data integration products. The position manages the extraction, transformation and loading of data from diverse operational systems and external data sources to create data sets and databases, in support of regular and ad-hoc data analytics for decision making. It also requires understanding business requirements to design the data pipeline.

The incumbent will need to quickly gain and maintain knowledge of the Branch business and the applications it uses, the content of diverse operational source systems, and the physical structure of the databases. The incumbent must understand the fundamentals of data architecture and data warehousing to lead migration of data to data warehouse structures.

The position manages the extraction, transformation and loading of data from diverse operational systems to create data sets and databases, in support of regular and ad-hoc reports for decision making. It also functions as an expert consultant regarding current systems / data architecture and assists in system development and conversion during data warehouse subject area development phases.

A criminal record check is required.

For complete details about this opportunity, including accountabilities, please refer to the attached job description, located in the Additional Information section at the bottom of the posting. An eligibility list for permanent or temporary future opportunities may be established.

Position requirements

Education and Experience:

A degree or diploma in computer science, information technology and a minimum of 2 years of related experience.

*Recent, related experience must have occurred within the last 5 years and must include the following:

• Experience with ETL (extract, transform and load) tools.
• Experience in SQL (Structured Query Language).
• Experience with various databases, such as Oracle, MS SQL Server, Postgres, etc.
• Experience in SOAP or REST (or RESTful) APIs.

Preference may be given to those candidates with:

• Experience with dimensional modeling.
• Experience with BI tools such as Tableau and Power BI.
• Experience with Talend Data Integration.
• Experience with Cloud-based data warehouse solutions.
• Experience with version control.
• Experience with enterprise job scheduler.
• Experience with Java programming language.

Application instructions

To be considered for this position, your application must clearly demonstrate how you meet the education and experience as outlined in the position requirements section above. Applicants selected to move forward in the hiring process may be assessed on the knowledge, skills, abilities and competencies as outlined in the attached Job Description. Applicants must meet the requirements as described below to be considered:

• A cover letter is required as part of your application. The content and/or format of your cover letter may be evaluated as part of the assessment process.
• Ensure your resume includes your educational accomplishments, employment history including start and end dates (month and year) of your employment, and any relevant information that relates to the job to which you are applying.

For specific position-related enquiries, please contact Jennifer Robinson, HR Advisor, Talent & Compensation at [e-mail].

Only applications submitted using the BC Public Service Recruitment System on this website will be accepted. For more information about how to create or update your profile, please refer to the attached Application Instructions or refer to the Job Application page on the MyHR website. If you are experiencing technical difficulty applying for a competition, please send an e-mail to [e-mail] before the stated closing time, and they will respond as soon as possible to assist you.

Note: Applications will be accepted until 11:00pm Pacific Time on the closing date of the competition.

Working for the BC Public Service:

The BC Public Service is committed to creating a diverse workplace to represent the population we serve and to better meet the needs of our citizens. Consider joining our team and being part of an innovative, inclusive and rewarding workplace.

This position is eligible for flexible work arrangements, such as a hybrid work combination of in-office and work-from-home, following the guidelines established for flexible workplaces.

The Indigenous Applicant Advisory Service is available to applicants that self-identify as Indigenous seeking work or already employed in the BC Public Service. For guidance on applying and interviewing, please contact [e-mail] or 778-405-3452.

The BC Public Service is an award-winning employer and offers employees competitive benefits, great learning opportunities and a chance to engage in rewarding work with exciting career development options. For more information, visit What the BC Public Service Offers.