Share this Job

Analyst, EBI Data and Reporting (FT, 25 Months)

Apply now »

Date: Aug 7, 2019

Location: Vancouver, BC, CA

Company: British Columbia Lottery Corporation

Why you should work with us


At BCLC, we believe that our people are what makes us amazing so we are committed to our people. We have a culture of fun and hard work – it’s not unusual to see teams eating together at lunch in the cafeteria or heading outside for a walking meeting. We continue to have a highly engaged team and we’ve been named one of BC’s Top 50 Employers for over 10 years. Here are a few reasons why it’s great to be part of the team:

  • Flexible work hours
  • Robust wellness program with free onsite yoga, bootcamp, running club and more
  • Competitive compensation
  • Company paid Flexible Health and Dental plan for you and your family
  • Defined Benefit Pension Program
  • Leadership and professional development programs



Why our Vancouver office is so awesome


Vancouver has been regularly voted one of the top cities to live in the world with one of the mildest climates of any city in Canada. It is home to our Marketing and Sales Office and features:

  • A subsidized cafeteria with healthy and delicious food choices
  • Free parking
  • Easy access to transit, including the Sky Train
  • Secure bike facilities and easy access off the Central Valley Greenway


Job Summary:
The Analyst, EBI Data and Reporting performs analytical work to support the development, implementation and maintenance of business intelligence and reporting solutions to grow business intelligence capabilities.  As a specialist in business intelligence, is a consultative partner to both internal and external stakeholders, providing education and recommendations for improvement, and for bringing new concepts and methods to the analytics team.  Supports adoption and implementation of the best practices in the data and reporting practice area.


Key Accountabilities:
•    Closely collaborates with Analytics Execution specialist to understand detailed BI needs and develop solutions that are supporting integrity of the reporting data. Supports Client Management and Analytics Execution teams by providing feedback and sign off on requirements
•    Develops data and reporting functionality, including reports and dashboards, based on requirements. Responsible for unit, integration and regression testing.
•    Designs, develops and executes queries to access and expose data layers to be used in providing business insights.
•    Analyzes data and provides verbal and/or written recommendations to Senior Client Insights Partners that are used when compiling insights to be presented to client.  Identifies new insights as well as new technical capabilities and shares with Client Management team.
•    Collaborates with Enterprise Data Warehouse team and other members of the BCLC’s Business Technology teams to support integrated data solutions.
•    Maintains an oversight of the overall model suite to ensure consistency, accuracy and repeatability. Collaborates with Analytics Execution Specialist in creating logical data models and physical data models for new solution development in support of the business needs. Ensures data models are fully documented and appropriate data dictionaries are created.
•    Performs user access management for newly developed reporting functionality and/or applications, or initiates and coordinates user access management with other BCLC technical teams. Performs technical maintenance and upgrades to applicable tools.
•    Continuously researches and learns about new technologies and data and reporting best practices (where best practices may include industry, general business or BCLC business acumen) and provides feedback to the rest of the team, EBI Director and Managers in order to influence departments’ strategic initiatives.

Minimum Required Qualifications:
Education and Experience

•    A degree in a business discipline such as Business Analytics, Information Technology, Marketing, Business Analysis or Statistics; 
•    3-5 years of related experience in leading the development of business intelligence solutions within a SQL based or SAS solution within a cross functional team, including a minimum of 3 years proven technical experience working within a complex business environment with the demonstrated ability to analyze business situations and develop innovative solutions to complex situations.
•    Experience with the following: developing end-to-end analysis with limited guidance; data intelligence best practices; including disparate data source integration techniques, segmentation, core KPI development, promotion/campaign ROI analysis and post analysis; data analysis and designing reporting solutions including (but not limited to) dashboards, portals, and report objects; web analytics, including but not limited to java script tagging, web dashboard creation and conversion funnel analysis;
•    An equivalent combination of education and/or experience may be considered.


Technical Requirements 
•    Knowledge in the areas of business analysis, business intelligence reporting, web/digital analytics and/or database marketing;
•    Understanding of data mining and database query tools.
•    Familiarity with contact history management/strategies, customer lifecycle and privacy requirements;
•    Understanding of statistical analytics including the use of statistical software, the gathering of data and analysis to support predictive model generation;
•    Clear communication skills to explain complex information in an effective manner. Demonstrates strong presentation and data visualization skills; ability to convey complex technical concepts to a non-technical audience;
•    Excellent interpersonal skills.
•    Ability to act on own initiative, exercise sound judgment and prioritize tasks with the experience and confidence to know when to ask for support;
•    Ability to work with a high degree of accuracy and attention to detail.


Please Note: This opportunity will remain open until a qualified candidate pool has been established.

Please Note: Candidates must be legally entitled to work in Canada.

Job Segment: Database, Developer, Outside Sales, Data Analyst, Business Analyst, Technology, Sales, Data