You're using an older version of Internet Explorer that is no longer supported. Please update your browser.
BC Liquor Distribution Branch

ISL 27R - Senior BI Analyst, Wholesale IT

Burnaby, BC
Full Time
2 days ago
72,724 to 83,014 per year
Senior BI Analyst, Wholesale 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 .

At the Liquor 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 14 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.

A criminal record check is required.

For complete details about this opportunity, including accountabilities, please refer to the attached job description, also 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:

Degree or diploma in Computer Science, Business Administration, or a related field with a minimum of 5 years of recent, related experience*.

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/or KPI scorecards creation.
  • Experience with developing SQL queries and stored procedures.
  • Experience delivering analytic solutions utilizing Cognos and/or Tableau.
  • Experience working on information products or reports in any of the following areas: gathering and defining requirements, designing or developing process changes and/or recording results and findings.
  • Experience performing analysis, such as problem analysis, gap analysis, impact analysis, risk assessment, etc.

Preference may be given to those candidates with any of the following experience:
  • Experience in business analytics across a multi-subject area information base, such as retail, wholesale, finance, marketing etc.
  • Experience with developing SQL queries used in data sources, adhoc reports or production support analysis.
  • Experience with Data Warehouse.
  • Experience with the following tools: MS Office 365, MS Project, VISIO. PowerBI is a nice to have.
  • Experience with business modeling tools and techniques.
  • Experience with eliciting and documenting requirements.

How to Apply & Application Requirements:

In order 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.

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 Harshada Nair, R/HR Advisor, Human Resource Services at 604-252-8561.

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 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.

Job Category

Information Management/Information Technology

Additional Information

Job_Profile_Senior BI Analyst, Wholesale IT
Information Technology Management and Executive