← Back to jobs

Prophecy Technologies Logo
SCM Data Modeler

Prophecy Technologies

 

Houston, TX, USA

Posted On: Just posted
Experience: 5+ years
Availability: Hybrid
Openings: 1
Category: Data Modeler
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Role Overview:

SCM Data, Innovation & analytics is seeking a Data Modeler with strong Databricks expertise to design, build, and operationalize scalable Supply Chain data products. This role focuses on delivering measurable business value by combining advanced analytics, data pipeline development, and product delivery to transform complex SCM data into trusted, governed, and actionable insights.

Key Responsibilities:

  • Develop analytics solutions addressing Supply Chain business problems, leveraging knowledge of oil & gas operations, procurement, supplier performance, spend analytics, and enterprise value drivers.
  • Design, build, test, and optimize scalable ETL/ELT pipelines in Databricks using Python, PySpark, SQL, notebooks, jobs, and pipeline orchestration patterns to support reliable Silver and Gold data products.
  • Transform and model data from ERP and enterprise platforms, including Oracle Cloud, SAP, ADW, Microsoft Dataflow, Dataverse, and other approved data sources.
  • Build and evaluate machine learning, statistical, and AI-assisted solutions where appropriate, including classification, forecasting, anomaly detection, text analytics, and natural language processing on structured and unstructured SCM data.
  • Utilize Databricks platform capabilities such as notebooks, jobs, workflows, Unity Catalog, SQL warehouses, Genie Code, and Lakeflow/Lakeflow Designer to accelerate development while maintaining enterprise standards.
  • Maintain comprehensive documentation, including idea assessments, requirements, design documents, and weekly status reports.
  • Articulate technical knowledge, requirements, design, and product details to internal business stakeholders in clear and plain language.

Required Skills:

  • Strong Databricks expertise
  • ETL/ELT pipeline development
  • Python, PySpark, SQL
  • Data modeling
  • Experience with ERP and enterprise platforms (Oracle Cloud, SAP, ADW, Microsoft Dataflow, Dataverse)
  • Machine learning, statistical, and AI-assisted solutions (classification, forecasting, anomaly detection, text analytics, natural language processing)
  • Databricks platform capabilities (notebooks, jobs, workflows, Unity Catalog, SQL warehouses, Genie Code, Lakeflow/Lakeflow Designer)


 

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs