Richards Packaging Inc., a Richards Group company, is one of North America’smost established providers of glass and plastic packaging solutions. Founded in1912, we’ve grown into a leading distributor serving the food and beverage,healthcare, cosmetics, and industrial markets.

With a broad portfolio ofbottles, jars, closures, dispensing systems, and custom packaging options,Richards Packaging is known for its reliability, product breadth, andexceptional customer service across its North American network.

About the Role:

Reporting to the VP of Sales and Marketing, the Data Solutions Architect will beresponsible for creating an integrated pricing and margin management solution byextracting data from Dynamics 365 Business Central, developing sophisticatedcalculations and data models within Microsoft Fabric, and delivering insightsthrough Power BI and custom-built dashboards.

You will work closely with Salesand Marketing stakeholders to create tools that support pricing decisions,competitive intelligence, and business growth.

The position is for an open vacancy.

The successful applicant will:

- Architect and develop a scalable regional B2B Pricing Engine leveraging Microsoft Fabric and Azure technologies.
- Design and implement secure data extraction processes from Dynamics 365 Business Central using OData APIs and Azure Entra ID service principles.
- Build and maintain Microsoft Fabric Lakehouse environments and data pipelines using PySpark and advanced SQL.
- Develop complex business logic including FIFO inventory costing, freight accruals, margin calculations, and financial analytics.
- Create data models that support forecasting, segmentation, pricing optimization, and business performance analysis.
- Design and develop intuitive dashboards and applications that serve as both a Pricing Configurator and Competitor Bounty data entry tool for the sales team.




- Develop advanced Power BI reporting solutions and DAX measures to support energetic financial and operational insights.
- Build modern user interfaces using React.js and Node.js, while integrating Power BI Embedded capabilities where appropriate.
- Ensure data quality, performance, scalability, and security across all data and reporting solutions.
- Collaborate with business stakeholders to understand requirements and translate them into effective technical solutions.

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

- Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or a related field.
- Minimum three years of experience in data engineering, data architecture, business intelligence, analytics, or a related role.
- Proven experience designing and implementing data pipelines, lakehouse architectures, and enterprise reporting solutions.
- Strong expertise with Microsoft Fabric, Azure data services, and modern cloud-based data platforms.
- Advanced proficiency in Python (PySpark) and SQL, including the development of complex data transformations and inventory costing logic.
- Expert-level knowledge of Power BI and DAX, particularly in financial modeling, margin analysis, and layered business calculations.
- Experience developing front-end applications using React.js and Node.js.
- Knowledge of Power BI Embedded SDK is considered a strong asset.
- Familiarity with Dynamics 365 Business Central data structures, tables, and integrations is highly desirable.
- Strong analytical, problem-solving, and communication skills.
- Ability to manage projects independently and deliver solutions in a fast‑paced environment.

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

#J-18808-Ljbffr

📌 Data Solutions Architect (4-Month Contract) (Mississauga)
🏢 Socket.dev
📍 Mississauga