Databricks Data Modeler

Client: TCS | Engagement: Full-time | Work mode: ONSITE | Experience: 6-8 | Publisher job id: JOB-000587

Role Overview

The SCM Data, Innovation & analytics team is seeking a Data Modeler with strong Databricks expertise. This role involves designing, building, and operationalizing scalable Supply Chain data products to deliver measurable business value. It combines advanced analytics, data pipeline development, and product delivery to transform complex SCM data into trusted, governed, and actionable insights.

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

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

Databricks

Python

PySpark

SQL

ETL/ELT pipeline development

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)

Supply Chain domain knowledge (oil & gas operations, procurement, supplier performance, spend analytics)

Qualifications

• 6-8 years of experience

• Preferred Skills:

• SaaS SCM Oracle Supply Chain Planning Cloud