Data Analytics Architect

Richards Packaging, Inc.; Mississauga; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive base salary & variable pay

Comprehensive healthcare benefits

Paramedical services

Mental health coverage

Orthotics and footwear coverage

Emergency travel insurance

Weekday day shift with work/life focus

Collaborative open concept office

Job summary

Richards Packaging Inc. is seeking a Data Analytics Architect to design and maintain enterprise analytics across sales, marketing, pricing, procurement, inventory, and performance initiatives.

You will leverage Microsoft Fabric, Power BI, PySpark, and SQL to deliver insights that improve decision-making and profitability in a fast-paced environment. Reporting to the VP of Sales & Marketing, you will build data pipelines, lakehouses, dashboards, and KPI scorecards, partner with Finance,

Qualifications

• Bachelor's degree in a related field (CS/IT/Data Analytics/Business/Supply Chain/Finance).
• Minimum 3 years of experience in data analytics, BI, data engineering, procurement analytics, or related role.
• Strong expertise with Microsoft Fabric, Power BI, DAX, SQL, and Azure data services.
• Proficiency in Python (PySpark) and advanced data transformation and modeling techniques.
• Experience designing and implementing data pipelines, lakehouse architectures, and enterprise reporting solutions.
• Hands-on experience developing Power BI dashboards, KPI reporting, and business performance analytics.
• Experience with ERP platforms such as Dynamics 365 Business Central or similar systems.

Responsibilities

• Architect and develop scalable analytics solutions leveraging Microsoft Fabric, Power BI, and Azure technologies.
• Design and implement secure data extraction and integration processes from Dynamics 365 Business Central and other business systems.
• Build and maintain Microsoft Fabric Lakehouse environments, data pipelines, and data models using PySpark and SQL.
• Develop advanced business logic and calculations related to pricing, margin analysis, inventory costing, forecasting, and financial reporting.
• Analyze sales, purchasing, supplier performance, inventory, and operational data to identify trends, risks, and opportunities for improvement.
• Design, develop, and automate Power BI dashboards, reports, and KPI scorecards that provide actionable insights to business leaders.
• Monitor and report on key business metrics including profitability, supplier performance, inventory turns, spend analysis, forecast accuracy, and sales performance.
• Collaborate with Sales, Marketing, Purchasing, Operations, and Finance stakeholders to translate business requirements into analytical solutions.
• Support continuous improvement initiatives through automation, reporting enhancements, and data-driven recommendations.

Skills

Microsoft Fabric

Power BI

DAX

SQL

Azure

Python (PySpark)

Data modeling

ERP (Dynamics 365 BC)

Excel

React.js

Power BI Embedded

Education

Bachelor's degree in Computer Science / IT / Data Analytics / Business / Supply Chain / Finance

Tools

Dynamics 365 Business Central

Power BI Embedded

Azure Data Services

Job description

Description

Richards Packaging inc., a part of Richards Group, is one of North America's most established providers of glass and plastic packaging solutions. Founded in 1912, we've grown into a leading distributor serving the food and beverage, healthcare, cosmetics and industrial markets. With a broad portfolio of bottles, jars, closures, dispensing systems, and customer packaging options, Richards Packaging is known for its reliability, product breath, and exceptional customer service across its North American network.

Why Join Richards:

• Generous compensation package including a competitive base salary and variable compensation
• Fantastic comprehensive healthcare benefits
• Paramedical services granting access to different practitioners
• Mental health coverage
• Orthotic and footwear coverage for custom boots or shoes
• Emergency travel insurance ensuring peace of mind while you travel
• Monday-Friday day shift operations with work/life balance at the forefront
• Collaborative, open concept office
• And so much more!

About the Role:

Reporting to the VP of Sales & Marketing, the Data Analytics Architect will be responsible for developing and maintaining enterprise analytics solutions that support sales, marketing, pricing, procurement, inventory management, and business performance initiatives. The successful candidate will leverage advanced data engineering, business intelligence, and analytics capabilities to deliver actionable insights, improve decision-making, optimize profitability, and support supply chain performance. This role requires strong experience with Microsoft Fabric, Power BI, data modeling, and business analytics within a fast-paced environment.

This posting is for an open vacancy.

The successful applicant will:

• Architect and develop scalable analytics solutions leveraging Microsoft Fabric, Power BI, and Azure technologies.
• Design and implement secure data extraction and integration processes from Dynamics 365 Business Central and other business systems.
• Build and maintain Microsoft Fabric Lakehouse environments, data pipelines, and data models using PySpark and SQL.
• Develop advanced business logic and calculations related to pricing, margin analysis, inventory costing, forecasting, and financial reporting.
• Analyze sales, purchasing, supplier performance, inventory, and operational data to identify trends, risks, and opportunities for improvement.
• Design, develop, and automate Power BI dashboards, reports, and KPI scorecards that provide actionable insights to business leaders.
• Monitor and report on key business metrics including profitability, supplier performance, inventory turns, spend analysis, forecast accuracy, and sales performance.
• Support global sourcing and procurement activities through supplier analytics, spend analysis, and cost optimization initiatives.
• Develop user-friendly analytics tools and applications that support pricing decisions, business planning, and operational reporting.
• Ensure data quality, integrity, security, and performance across all reporting and analytics platforms.
• Collaborate with Sales, Marketing, Purchasing, Operations, and Finance stakeholders to translate business requirements into effective analytical solutions.
• Support continuous improvement initiatives through automation, reporting enhancements, and data-driven recommendations.

We are seeking a candidate with the following experience and attributes:

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Business, Supply Chain Management, Finance, or a related field.
• Minimum 3 years of experience in data analytics, business intelligence, data engineering, procurement analytics, or a related role.
• Strong expertise with Microsoft Fabric, Power BI, DAX, SQL, and Azure data services.
• Proficiency in Python (PySpark) and advanced data transformation and modeling techniques.
• Experience designing and implementing data pipelines, lakehouse architectures, and enterprise reporting solutions.
• Hands-on experience developing Power BI dashboards, KPI reporting, and business performance analytics.
• Experience working with ERP platforms such as Dynamics 365 Business Central, Microsoft Dynamics, or similar systems.
• Strong understanding of pricing analysis, inventory management, procurement, supplier performance, forecasting, and financial reporting.
• Advanced proficiency in Microsoft Excel, including Pivot Tables and Power Query.
• Experience with React.js, Node.js, and Power BI Embedded is considered an asset.
• Strong analytical, problem-solving, communication, and stakeholder management skills.
• Ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment.

Richards Packaging Inc. is an equal-opportunity employer and is committed to creating an inclusive employee experience for all. We firmly believe that our work is at its best when everyone feels free to be their most authentic self. If you require accommodation, please let us know how we can further support you during the recruitment process.