Bi Jobs in Oakville, ON

Description

WHO WE ARE :

At Arterra Wines Canada, we aim to inspire the simple joys of life, and we come to work every day with a shared passion to build wine brands people love. As a pioneer in the Canadian wine industry with 150 years of experience, our success is driven by our people. We work together with integrity and pride, striving to reach our fullest potential every day, and we’re looking for people who do the same.

We are undergoing a pivotal transformation, actively in search of dynamic individuals poised to make a substantial impact within our ever-evolving organization. Are you someone who embraces change and excels in diverse roles that span across various functions? If so, we look forward to hearing from you!

ROLE SUMMARY :

Reporting to the Senior Manager of Business Intelligence, the Senior BI Reporting and Predictive Analytics Analyst will create best in class commercial reporting, ensure standardization across the organization on tracking the right KPI’s and ensure consistency. This person will further lead the predictive analytic and data modeling development for AWC into key process like market forecasting and segment evolution.

KEY RESPONSIBILITIES :

Power BI Reports & Dashboards Development and Maintenance

Design, develop and maintain Power BI reports and dashboards to support Sales & Marketing teams in answering recurrent questions for internal business reviews as well as in external meetings with the customer.

Support Sales & Marketing customer needs – perform exploratory data analysis to identify trends and patterns to support business decisions, develop ad-hoc reports, complex custom calculations and KPI’s required by the business, facilitate consistent planning and measurement of market trends and performance.

Revise existing reports, calculations, develop and distribute custom datasets and reports.

Advanced Analytics

Work in close relationship with Data Science team to accelerate development of advanced forecasting models to predict sales trends, market demand, and other relevant business metrics.

Capture key macro-economic factors impacting alcoholic beverage sales across the country and anticipate future impact on sales.

Support and develop other advanced data analytics solutions to support the Sales & Marketing teams.

Data Management

Develop expert knowledge of all data sets in terms of differences between provinces, channels, metrics, etc.

Create comprehensive documentation for data / reporting processes, including step-by-step guides and best practices, regularly update documentation to reflect changes and improvements in processes.

Data Integrity and Users Support

Work closely with Data Integrity Analyst and IT team and oversee data quality processes and methodologies.

Support Power BI end-users by providing training, manuals, FAQ documents to help users understand and interpret data.

Become the key resource for user questions regarding the utilization of datasets.

WHAT YOU BRING :

University Degree, Degree in quantitative field (Mathematics, Statistics, Economics, Computer Science, Information Technology, etc.)

3-5 years in business intelligence or analytical role

Strong computer skills and working knowledge of Microsoft Office applications (Word, Excel, PowerPoint, Outlook)

Strong communication and organizational skills

Advanced analysis skills with particular attention to detail

Hands on experience with Power BI, Power Query, advanced knowledge of DAX, M languages

Advanced proficiency in MS Excel (advanced functions, pivot tables, AI add-ons)

Strong knowledge of Data Visualization best practices and techniques, with a keen eye for visual data storytelling

Working knowledge of Python for data manipulation and building predictive ML and Statistical models

Advanced analytical skills with particular attention to detail and commitment to develop high-quality data analytics solutions

Proven ability to learn quickly and work effectively both independently and as a team member

Strong prioritizing and planning skills

Microsoft Certification “Power BI Data Analyst Associate” (PL-300)

Portfolio of Power BI reports / dashboards showcasing data visualization skills and DAX knowledge

GitHub profile with examples of advanced data analytics, predictive modeling

WHAT WE OFFER :

Hybrid work model, allowing employees to balance remote and in-office work.

Competitive Salary and Bonus.

Benefits and Pension Plan.

Product Allowances.

Training & Development Programs.

Tuition Reimbursement.

Commitment to Corporate Social Responsibility.

A chance to explore and learn more about the Wine industry.

COMPENSATION :  Budgeted Range – $77,426.00 - $100,198.00. The budgeted range takes into account several factors and qualifications that are considered in making compensation decisions including experience, education, training, licenses, certifications, and other business and organizational requirements. Base pay is only one component of the total rewards offering at Arterra.

The budgeted range will align with qualifications, including experience, education, training, licenses, certifications, and other business and organizational requirements.