Data Modeler III

Data Modeler III Contract Duration: Contract through 08/09/2027 (High potential for extension) Location: Houston, TX (Hybrid – Onsite Monday, Tuesday, and Thursday) Position Overview: SCM Data, Innovation & Analytics is seeking an experienced Data Modeler with strong Databricks expertise to design, build, and operationalize scalable Supply Chain data products that deliver measurable business value. This role combines advanced analytics, data pipeline development, and product delivery to transform complex SCM data into trusted, governed, and actionable insights. The ideal candidate will have experience in Supply Chain Management (SCM), data modeling, Databricks, and analytics, with a strong understanding of Procure-to-Pay (P2P) and Source-to-Pay (S2P) processes within the oil & gas industry. Key Responsibilities: • Develop analytics solutions that address Supply Chain business challenges, 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 orchestration patterns. • Create and support reliable Silver and Gold data products to ensure high-quality, governed data delivery. • 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, 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 where approved. • Maintain comprehensive project documentation, including idea assessments, requirements, design documents, and weekly status reports. • Communicate technical concepts, requirements, design decisions, and product details to business stakeholders in clear and simple language. • Collaborate with cross-functional teams to deliver data products that align with enterprise standards and business objectives. Required Skills & Qualifications: • Experience: 5–7 years of relevant SCM, analytics, or product development experience. • Advanced proficiency in data science, including statistical analysis, predictive analytics, machine learning, text-based sentiment analysis, and data visualization. • Strong experience analyzing unstructured data, such as PO line descriptions and customer feedback, to extract actionable insights. • Advanced proficiency in Python and PySpark for large-scale data processing in Databricks. • Hands-on experience with Databricks notebooks, jobs, workflows, Unity Catalog, SQL Warehouses, and Lakeflow/Lakeflow Designer. • Strong knowledge of prompt engineering and AI-assisted solution development. • Hands-on experience developing solutions using Microsoft Power Platform, including Copilot Studio, Dataflow, Dataverse, Power Automate, and Model-driven Apps. • In-depth knowledge of SAP and Oracle Cloud modules related to SCM, Accounts Payable, Projects, and Finance. • Proficiency in SQL for data transformation and querying. • Experience with Alteryx for data preparation and workflow automation is a plus. • Strong understanding of SCM Procure-to-Pay (P2P) and Source-to-Pay (S2P) processes and value drivers. • Experience working in the oil & gas industry is highly preferred. • Skilled in Agile and Waterfall project methodologies, stakeholder engagement, and project documentation using PowerPoint, Excel, Visio, and related tools. Education: Bachelor’s degree in Commerce (SCM), Data Science, Engineering, or a related field. Preferred Qualifications: • Experience building scalable enterprise data products in Databricks. • Familiarity with data governance and enterprise data standards. • Ability to translate complex technical solutions into business-friendly insights. • Strong analytical, problem-solving, and communication skills.