Data Modeler III

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.

Responsibilities:

• 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.

Required Skills/Knowledge/Experience:

• 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:

• Bachelors degree in Commerce (SCM), Data Science, Engineering, or related field

Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!

#ASTIT

Job Type: Contract

Pay: $52.00 - $54.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Vision insurance

Application Question(s):

• Are you a U.S. Citizen or Permanent Resident?
• How many years of experience/proficiency do you have in data science, including statistical analysis, predictive analysis, text-based sentiment analysis, machine learning, and data visualization?

Experience:

• physical data modeling: 5 years (Required)
• managing metadata: 5 years (Required)
• Python and PySpark in conjunction with Databricks: 5 years (Required)
• SAP and Oracle Cloud (SCM, A/P, Projects, Finance): 5 years (Required)

Work Location: Hybrid remote in Houston, TX 77079