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
10 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.