Senior Commercial Analyst (Data & BI)

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.