Business Intelligence Analyst

Company Description

The Business Intelligence Analyst is responsible for coordinating sales and distribution data and support its process, developing and delivering all standard reports, tools and information (right information, at the right time).

In this position, the successful candidate will play a key role leading the design, implementation, and distribution of Business Reports, Data Visualizations, and Exploratory Data Analysis (EDA) supporting the Trade Sales and Distribution functions of business. In addition, this position will be responsible for understanding key business issues, gathering data, conducting analysis and interpreting data while concurrently developing, streamlining and updating KPI’s, dashboards, scorecards and reporting. She/he will acts as the local subject matter expert for data applications (i.e. SAP BI, RedShift, Snowflake) and interacts with the local team and global counterparts.

Job Description

REPORTING AND DATA TOOL DEVELOPMENT

Develop tools to support sales and distribution teams and guarantee the data consistency.

Create new reports and data visualizations to drive insights and tell stories using data.

Continuously improve standard reports for operational efficiencies.

Lead automation initiatives to streamline reporting process for the commercial data team.

DATA PREPERATION

Data cleansing and structuring to ensure quality data outputs.

Prepare, interpret, and distribute all reporting on established regular frequency as well as ad hoc basis.

Provide training to end users on utilization of reports.

Continuously identify ways to simplify, automate, and improve reporting.

Under guidance of Senior Commercial Data Manager, will help to drive ad-hoc initiatives & projects to deepen Red.

Bull Canada’s insights in the Distribution landscape; will support On & Off Premise Sales and other initiatives as assigned.

PROJECT MANAGEMENT

Oversee the translation of business requirements into the technical solution, from design till go-live.

Work closely with Red Bull Global and Red Bull North American teams to adopt and transition best in class tools and processes for Canada Team.

Work closely with IT to coordinate new initiatives and tools for the data team.

Qualifications

Bachelor’s Degree required.

2+ years’ experience in a similar analytical role.

Expert level competence with Microsoft Excel & other Office Suite tools.

Excellent knowledge of statistical measures and techniques.

Experience with data visualization tools (Power BI, Tableau, SAP Analytics Cloud) and related techniques.

Experience working with large datasets through Access and Excel, statistical software such as SAS, R.

Proficiency with relational databases (SQL).

Strong quantitative, analytic and problem-solving skills.

Basic knowledge of Consumer-Packaged Goods (CPG) industry is considered an asset.

Ability to analyze diverse data and formulate clear, focused and actionable recommendations.

Solid communication & presentation skills.

Self-motivated and able to work independently.

Ability to prioritize and multi-task.

Knowledge of or exposure to R, Python or other statistical programming languages/tools is a plus.

Additional Information

Red Bull Canada is committed to treating all people in a way that allows them to maintain their dignity and independence. We believe in integration and equal opportunity. Accommodations are available throughout the recruitment process and applicants with a disability may request to be accommodated throughout the recruitment process. We will work with all applicants to accommodate their individual accessibility needs.