Data Modeler III

Job Description

Data Modeler III:
On behalf of our client, Procom is searching for a Data Modeler III for a permanent role. This position is a hybrid position with 3 days onsite at our client’s Calgary office.

Data Modeler III - Job Description:
SCM Data, Innovation & Analytics is seeking a Data Modeler III with strong Databricks expertise to design, build, and operationalize scalable Supply Chain data products. The role involves turning complex SCM data into actionable insights through advanced analytics, data pipeline development, and product delivery.

Data Modeler III - Responsibilities:
• Develop analytics solutions to address Supply Chain business problems, leveraging knowledge of oil & gas operations, procurement, supplier performance, and spend analytics.
• Design, build, test, and optimize scalable ETL/ELT pipelines in Databricks using Python, PySpark, SQL, and pipeline orchestration patterns.
• Transform and model data from ERP and enterprise platforms, including Oracle Cloud, SAP, ADW, Microsoft Dataflow, and Dataverse.
• Build and evaluate machine learning, statistical, and AI-assisted solutions, including classification, forecasting, anomaly detection, and text analytics.
• Use Databricks platform capabilities to accelerate development while maintaining enterprise standards.
• Maintain documentation, including idea assessments, requirements, design documents, and weekly status reports.
• Communicate technical knowledge, requirements, design, and product details to internal business stakeholders in clear and plain language.

Data Modeler III - Mandatory Skills:
• 5-7 years of relevant SCM or product development experience.
• Advanced proficiency in data science, including statistical analysis, predictive analysis, and machine learning.
• Advanced proficiency in Python and PySpark with Databricks for large-scale data processing.
• Hands-on experience in developing solutions using Microsoft Power Platform.
• In-depth knowledge of SAP and Oracle Cloud.
• Proficiency in SQL for data transformation.
• Experience with Alteryx for data preparation and workflow automation.

Data Modeler III – Nice-to-Have Skills:
• Experience in the oil and gas sector.
• Knowledge of SCM Procure-to-Pay / Source-to-Pay processes.
• Skilled in agile/waterfall methodologies.
• Proficiency in stakeholder engagement and project documentation.
• Hands-on knowledge with prompt engineering.

Data Modeler III – Assignment Length:
12 months 

Data Modeler III - Start Date:
ASAP.

Data Modeler III - Assignment Location:
Calgary, Alberta, Canada. This is a hybrid position with 3 days in office.