Data Analytics Architect

Clarion Medical Technologies Inc.; Mississauga; On-site; CAD 110,000 - 170,000; Full time

Job summary

Richards Packaging Inc. is seeking a Data Analytics Architect to develop analytics solutions across sales, marketing, pricing, procurement, and supply chain. You will build BI capabilities with Fabric, Power BI, and Azure, and model data from Dynamics 365 BC and other systems.

The role emphasizes data quality, secure pipelines, and actionable insights to improve profitability and performance in a fast-paced environment.

Qualifications

• Bachelor’s degree in a related field.
• Minimum 3 years in data analytics, BI, data engineering or procurement analytics.
• Strong expertise with Microsoft Fabric, Power BI, DAX, SQL and Azure data services.
• Proficiency in Python (PySpark) and data pipeline design.
• Experience with ERP like Dynamics 365 BC and enterprise reporting.

Responsibilities

• Architect and develop scalable analytics solutions using Fabric, Power BI and Azure.
• Design secure data extraction and integration from Dynamics 365 and other systems.
• Build Fabric Lakehouse environments, pipelines and data models.
• Develop pricing, margin, inventory, forecasting and financial reports.
• Create Power BI dashboards, KPI scorecards and reports for leaders.
• Collaborate with Sales, Marketing, Purchasing, Operations and Finance.
• Ensure data quality, security and performance across platforms.
• Support continuous improvement through automation and data-driven recommendations.

Skills

Data analytics

Business intelligence

Stakeholder management

Analytical problem solving

Communication

Education

Bachelor's degree in Computer Science, Information Technology, Data Analytics, Business, Supply Chain Management, Finance, or a related field

Tools

Microsoft Fabric

Power BI

DAX

SQL

Azure data services

Python (PySpark)

Dynamics 365 Business Central

Excel

Power BI Embedded

React.js

Node.js

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 Director of Sourcing and Purchasing, 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.