Data Engineer

Integrated Resources, Inc ( IRI ); Houston (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

Integrated Resources, Inc (IRI) is seeking a Data Modeler with strong Databricks expertise to design, build, and operate scalable supply chain data products that deliver measurable business value. The role blends advanced analytics, data pipeline development, and product delivery to turn complex SCM data into trusted, governed insights.

The ideal candidate will have 5–7 years in SCM or product development, deep Python/PySpark experience with Databricks, SQL proficiency, and hands-on work with

Qualifications

• 5–7 years of SCM or product development experience.
• Advanced proficiency in Python and PySpark with Databricks.
• Experience analyzing unstructured data for insights.
• Hands-on knowledge with Microsoft Power Platform for automation.
• Familiarity with SAP and Oracle Cloud in SCM is a plus.
• Strong SQL for data transformation.
• Knowledge of Alteryx for data preparation is a plus.

Responsibilities

• Develop analytics solutions addressing SCM problems leveraging domain knowledge.
• Design, build, test, and optimize scalable ETL/ELT pipelines in Databricks.
• Transform and model data from ERP and enterprise platforms (Oracle Cloud, SAP, etc.).
• Build and evaluate ML, statistical, and AI‑assisted solutions.
• Utilize Databricks notebooks, jobs, and workflows to accelerate development.
• Maintain documentation including assessments, requirements, and status reports.
• Explain technical requirements and product details to stakeholders clearly.

Skills

Python

PySpark

Databricks

SQL

Machine Learning

Data Visualization

Prompt Engineering

Power Platform

Education

Bachelor’s degree in SCM, Data Science, Engineering, or related field

Tools

Databricks

Power Platform

Oracle Cloud

SAP

Alteryx

Dataverse

Job description

SCM Data, Innovation & analytics is seeking a Data modeler with strong Databricks expertise to design, build, and operationalize scalable Supply Chain data products that deliver measurable business value for Supply Chain. The role combines advanced analytics, data pipeline development, and product delivery to turn complex SCM data into trusted, governed, and actionable insights.

Specific Accountability

• Develop analytics solutions that address 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.
• Use Databricks platform capabilities such as notebooks, jobs, workflows, Unity Catalog, SQL warehouses, Genie Code, and Lakeflow/Lakeflow Designer where approved to accelerate development while maintaining enterprise standards.
• Maintain documentations, 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.

Skills and Qualifications

• Experience: 5–7 years of relevant SCM or product development experience.
  • Advanced proficiency in data science, including statistical analysis, predictive analysis, text-based sentiment analysis, machine learning, and data visualization.
  • Advanced proficiency in analyzing unstructured data such as PO line descriptions, customer feedbacks to extract insights
  • Advanced proficiency in Python and PySpark in conjunction with Databricks for large-scale data processing.
  • Hands‑on knowledge with prompt engineering
  • Hands‑on experience in developing solutions using Microsoft Power Platform (Copilot Studio, Dataflow, Dataverse, Power Automate, and Model‑driven Apps) for workflow automation and low‑code development.
  • In‑depth knowledge of SAP and Oracle Cloud (SCM, A/P, Projects, Finance).
  • Proficiency in SQL for data transformation is an asset.
  • Experience with Alteryx for data preparation and workflow automation is an asset
• Industry Knowledge: Oil and gas sector, SCM Procure-to-Pay / Source‑to‑Pay processes and value drivers.
• Project Management: Skilled in agile/waterfall methodologies, stakeholder engagement, Project documentation (Power Point, Excel, Visio, etc)

• Education:

Bachelor’s degree in Commerce (SCM), Data Science, Engineering, or related field