Business Intelligence Analyst

  • KORE Software
  • Vancouver, British Columbia, Canada
  • Jun 19, 2022

Job Description

Company Summary

KORE is the global leader in sports and entertainment business management solutions. Comprised of KORE Software and KPI (KORE Planning and Insights), KORE provides leading B2B SaaS software to more than 500 sports properties worldwide, providing practical tools, services and insights that drive ticket sales, digital marketing, corporate sponsorships, activation management, premium hospitality and more.

Role Overview

KORE Planning & Insights (KPI) is KORE's consulting practice providing key insights and expertise to the Sport & Entertainment industry in addition to our best-in-class software. KPI works with rights-holders, brands and agencies delivering integrated analysis and strategy on all aspects of sports business.

This team member will report directly to the Senior Director, Global Analytics & Strategy and will focus on current and future projects for rights holders and brand clients. The focus will be on problem solving for clients using data to create analytics solutions and data visualizations (SQL, Tableau, PowerBI).

The ideal candidate for this position will be self-motivated, able to meet deadlines, detail-oriented, data-focused, and have a strong ability to work well in a team-based setting with internal and external stakeholders. They're also expected to demonstrate the ability to build data visualizations (Tableau/PowerPoint) and show the technical aptitude to expand their SQL scripting skills.

Duties and Responsibilities

Client Strategy

  • Leverage our deep relationships and knowledge base with sports and entertainment clients across the globe to create strategies that drive business results for our clients.
  • Create technical solutions for clients based on objectives outlined by them

  • Assist the clients in problem solving using the full suite of data tools available to clients like AWS Glue, SQL, Tableau, PowerBI, etc.
  • Create stored procedures, custom views, data snapshots, custom tables
  • Help implement the data analytics vision for business decision making through Tableau dashboard design
  • Provide partners with dynamic measurement and reporting across key metrics, and demonstrate performance across a variety of data types and sources.
  • Leverage data and reporting to drive greater adoption into customer software products

  • Bachelor's Degree required; Graduate degree preferred.
  • 2+ year(s) experience with data visualization tools (Tableau, PowerBI, Looker)

  • Must-Haves
    • Comfortable with the differences between tables, views, stored procedures and the different scenarios to use
    • Comfortable with SELECT, FROM, JOINS (LEFT, RIGHT, FULL OUTER), WHERE, GROUP BY, HAVING operations
    • Temp Tables and CTEs
    • Amazon S3/ Redshift Copy Command
  • Nice to Have
    • Indexes
    • Query Optimization
    • SQL Jobs
2+ year(s) experience with SQL, Postgres required Proficient in Microsoft Suite, particularly with PowerPoint, Word and Excel Strong organizational, analytical, and technical skills Knowledge of sports industry Ability to communicate professionally in both a written and verbal context with external end-users and internal colleagues