Intermediate - Data Modeler

Randstad Canada; Calgary; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

Randstad Canada is seeking a skilled Data Modeler to influence supply chain analytics within the oil and gas sector in Calgary. This 1-year contract offers a hybrid work setup and strategic data product development using Databricks, PySpark, and the Microsoft Power Platform.

The role targets 5–7 years of relevant experience, with deep SQL, Python, and cloud data integration skills. Collaboration with a data and innovation team will drive enterprise analytics, reporting, and model development.

Qualifications

• Bachelor's degree in SCM, Data Science, Engineering, or a related field.
• 5–7 years of relevant supply chain data science or product development experience.
• Advanced proficiency in Python, PySpark, Databricks, and SQL for large-scale processing.
• Hands-on experience with Microsoft Power Platform tools including Copilot Studio, Dataflows, and Dataverse.
• Knowledge of SAP and Oracle Cloud SCM modules and oil & gas Procure-to-Pay processes.

Responsibilities

• Develop analytics solutions addressing supply chain problems within oil and gas contexts.
• Design, build, test, and optimize ETL/ELT pipelines in Databricks using Python, PySpark, and SQL.
• Transform and model data from Oracle Cloud, SAP, and Dataverse.
• Build ML, statistical, and AI-assisted models for classification, forecasting, and anomaly detection.
• Leverage Databricks features like Unity Catalog, workflows, and SQL warehouses to maintain standards.
• Analyze unstructured SCM data (PO descriptions, feedback) to extract insights.
• Maintain project documentation including architecture designs and weekly status updates.

Skills

Python

PySpark

SQL

Databricks

Power Platform

SAP

Oracle Cloud SCM

Education

Bachelor's degree in SCM / Data Science / Engineering

Tools

Copilot Studio

Dataflows

Dataverse

Unity Catalog

Oracle Cloud

SAP SCM

Job description

Are you a skilled Data Modeler looking to make a direct impact on supply chain operations in the oil and gas sector? Our Calgary client is seeking a Data Modeler for a 1-year contract, working in a hybrid environment.

Advantages

• Gain valuable enterprise experience within the oil and gas sector.
• Enjoy a flexible hybrid work setup balancing office collaboration and home focus.
• Build cutting edge data products using Databricks, PySpark, and Microsoft Power Platform.
• Work on high impact analytics solutions addressing supply chain, procurement, and spend priorities.
• Collaborate with an experienced data and innovation team dedicated to strategy and modern analytics.

Responsibilities

• Develop analytics solutions that address supply chain business problems using oil and gas operational context.
• Design, build, test, and optimize scalable ETL and ELT pipelines in Databricks using Python, PySpark, and SQL.
• Transform and model structured and unstructured data from enterprise platforms including Oracle Cloud, SAP, and Dataverse.
• Build machine learning, statistical, and AI-assisted models for classification, forecasting, and anomaly detection.
• Utilize Databricks platform capabilities like Unity Catalog, workflows, and SQL warehouses to maintain enterprise standards.
• Analyze unstructured SCM data such as purchase order descriptions and customer feedback to extract insights.
• Maintain project documentation including idea assessments, architecture designs, and weekly status updates.

Qualifications

• Bachelor's degree in Commerce (SCM), Data Science, Engineering, or a related field.
• 5 to 7 years of relevant supply chain data science or product development experience.
• Demonstrates advanced proficiency in Python, PySpark, Databricks, and SQL for large scale processing.
• Possesses hands‑on experience with Microsoft Power Platform tools including Copilot Studio, Dataflows, and Dataverse.
• Brings knowledge of SAP and Oracle Cloud SCM modules along with oil and gas Procure-to-Pay processes.

Summary

If you are ready to take your supply chain data expertise to the next level, we want to hear from you.

Randstad Canada Diversity & Inclusion Statements

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity‑seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [e-mail] to ensure their ability to fully participate in the interview process.