Role: Senior Commercial Analyst (Data & BI)

Legal Entity: Richards Packaging Inc.

Details of this position:

Permanent, Full time
40 hours a week Minimum
$48.08 per hour or $100,000.00 annually
Bonus: Eligible for an annual performance-based bonus with a target of CAD $10,000, based on the achievement of agreed-upon performance objectives. Bonus eligibility is subject to Company policy and applicable terms and conditions, including prorating where applicable.
15 vacation days & 5 paid personal days
Long-Term Disability (LTD) Insurance, Life Insurance, Dependent Life Insurance, AD&D Insurance, Dental Insurance, Extended medical Insurance, Vision care benefits, paramedical coverage – All premium paid by employer with the exception of LTD.

Key Responsibilities

The Senior Commercial Analyst (Data & BI) is responsible for translating sales and marketing data into actionable insights that support senior leadership decision-making. This role leads the collection, documentation, and analysis of organizational data requirements while designing, developing, and administering enterprise databases and data management systems.

Key Responsibilities

· Design, develop, and maintain Power BI dashboards and reports for senior leadership;

· Translate complex datasets into clear, actionable insights;

· Build and maintain data models to support reporting and analytics needs;

· Analyze large datasets using SQL and PySpark within Microsoft Fabric;

· Develop and optimize ETL processes to integrate data from multiple systems;

· Document legacy data structures and ensure data lineage for migration and integration;

· Maintain enterprise budgeting and sales databases;

· Administer enterprise databases and data management systems;

· Implement and manage data access controls and security policies;

· Ensure proper role-based permissions across the organization;

· Support data integrity, consistency, and system performance;

· Develop, maintain, and optimize pricing models and price guides;

· Analyze market conditions, cost fluctuations, and competitive activity;

· Support pricing decisions across eCommerce, inside sales, and outside sales channels;

· Conduct test-and-learn analyses to refine pricing strategies;

· Analyze customer- and product-level sales data to identify trends and opportunities;

· Build customer and product segmentation models;

· Evaluate sales performance and explain variances to leadership;

· Partner with sales teams to improve conversion and retention rates;

· Develop forecasting models for customer demand and inventory planning;

· Create proactive alerts for potential stock-outs and sales opportunities;

· Collaborate with Marketing to define and track KPIs;

· Analyze performance across digital campaigns, promotions, trade shows, and sampling;

· Measure and optimize Marketing ROI (MROI);

· Provide strategic recommendations to improve marketing effectiveness and spend allocation.

Employment qualifications

- Bachelor’s degree in Computer Science, Computer Engineering, Mathematics, or a related field

- 2 years of work experience in data analysis and Power BI

- Experience in database design, development, and administration

- Strong background in data analysis, business intelligence, and data modeling

- Experience with pricing analytics and commercial data analysis is an asset

- Experience with database management systems and data tools

- Proficiency in database architecture, data modeling, and data management systems

- Experience developing dashboards and reports (BI tools)

- Knowledge of data governance, data security, and access controls

- Experience with scripting (e.g., stored procedures, triggers) is an asset

- Strong analytical and problem-solving skills

- Ability to translate complex data into clear business insights

- Excellent communication skills for presenting to senior leadership

- Strong attention to detail and organizational skills

- Ability to work collaboratively across departments

Location: 6155 Belgrave Rd - Unit 3, Mississauga, ON L5R 4G8

Application

To apply send your resume to our e-mail address: atucker@richardspackaging.com

Thank you for your application, we will contact those individuals who closely meet the job requirements for an interview.

Browse Current Job Opportunities Across Canada

Browse Current Job Opportunities Across Canada

Senior Commercial Analyst (Data & BI)

Senior Commercial Analyst (Data & BI)