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.