ISL R - Senior BI Analyst, Cannabis IT

BC Liquor Distribution Branch Burnaby, BC 2022-09-19 Full-time
Apply Now Copy link

Position: ISL 27R - Senior BI Analyst, Cannabis IT

Senior BI Analyst, Cannabis IT Information Systems R27

On November 1, 2021, the BC Public Service announced the COVID-19 Vaccination Policy that defines the conditions and expectations for BC Public Service employees regarding vaccination against COVID-19. Among other possible measures, proof of vaccination will be required. It is a term of acceptance of employment that you agree to comply with all vaccination requirements that apply to the public service.

More information can be found here . or Distribution Branch (LDB) our vision of 'Service. Relationships. Results.' is all about providing a valued service, building strong relationships with our stakeholders, and achieving greater results for the province. The LDB is one of two branches of government responsible for the cannabis and liquor industry of B.C. We operate the wholesale distribution of beverage alcohol and non-medical cannabis within the province, as well as the household retail brands of BC Liquor Stores and BC Cannabis Stores.

We employ nearly 5,000 people in over 200 communities and have hundreds of career opportunities spanning our entire wholesale, retail and corporate operations - from supply chain logistics, to high-tech solutions, and everything in between. The LDB has been named one of BC's Top Employers 12 times over for offering exceptional places to work, flexible work hours and earned days off, extended health and dental benefits, maternity and parental leave top-up payments, a pension program, in-house professional and leadership development, and subsidies for professional accreditation.

The information technology (IT) team is highly customer focused and directly supports four distinct lines of business: retail liquor, wholesale liquor, cannabis, and corporate. These line of business IT teams are supported overall by both a Chief Information Security Officer and a Chief Technical Officer and their respective departments to ensure the organization prioritizes security and innovation. At present the technology team consists of more than 200 full-time employees, and has also adopted a multi-sourcing strategy and leverages external expertise, Cloud SaaS based services and government shared services as appropriate.

The teams integrate, maintain and enhance more than 80 business systems on a hybrid on-premises and cloud infrastructure. These include:

Merchandising and retail store systems that process 40 million plus customer transactions per year. Wholesale, distribution, and warehouse systems that enable the movement of 17 million plus cases per year. Corporate finance systems to service an annual budget of approximately $3 billion and HR and payroll systems to service more than 5000 employees. The Senior BI Analyst has responsibility to coordinate and lead the design, development, test, implementation and support of specific solutions for the Retail, Corporate, or Wholesale Division, delivered via the various forms of information delivery and via multiple BI, Analytics and Visualization Tools.

These include reports, analytics, dashboards, visualizations using Tableau and Cognos. Driving and supporting Business Self-serve through education, mentoring, and delivering analytical starter kits are also a key focus. The position is responsible for completing detailed end-to-end business analysis, obtaining clear definition of business requirements, and translating them into functional specifications, developing cost-benefit/alternative analysis, risk assessments, recommendations, and preparing branch standard documentation.

The position also identifies time frames, resources/ budget requirements and presents findings to both IT and business leaders. This position is also responsible for the analysis of requirements, analyzing and confirming ability to test; programming of custom workflow for test management and defect tracking; and development of automated test scripts/ scenarios traceable to requirements. Successful completion of a criminal record check.

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


Education and Experience:

Degree or diploma in Computer Science, Business Administration, or a related field with a minimum of 5 years of recent, related experience*. OR An equivalent combination of education and experience may be considered, i.e., 7 years of recent, related experience

• with formal coursework and/or certification.

• Recent, related experience must have occurred in the last 10 years and must include the following:

Experience with enterprise report development including dashboards, reports, visualizations and/ecards creation.

Experience with developing SQL queries and stored procedures. Experience delivering analytic solutions utilizing Cognos and/or Tableau.

Experience working on…