749 Data Modeling jobs in Bengaluru

Job Title: Databricks SQL Engineer (with Pharma/Life Sciences background)

About the Role:

We are seeking a highly skilled Databricks SQL Engineer with Pharma background to join our Data Engineering team. The ideal candidate will have strong expertise in Databricks, Pyspark, SQL, Spark SQL, Delta Lake, and data lakehouse architectures, and will be responsible for building scalable and efficient data models, queries, and pipelines that power analytical insights and business decisions.

Key Responsibilities:

• Design, develop, and optimize SQL-based data models and queries in Databricks for large-scale datasets.
• Work with Delta Lake, Unity Catalog, and Databricks Notebooks to manage and secure data assets.
• Implement and maintain ETL/ELT pipelines using Databricks workflows and SQL.
• Develop documentation and data dictionaries to promote self-service analytics.
• Ensure data quality and consistency through testing, validation, and monitoring.
• Optimize data lakehouse architecture for cost and performance, leveraging Spark SQL best practices.
• Support CI/CD practices for deploying notebooks and SQL jobs to production.

Required Qualifications:

• 5+ years of experience working with Databricks SQL, Pyspark, Spark SQL, or similar distributed SQL engines.
• Experience in the Pharma Domain
• Strong experience with Delta Lake, structured streaming, and data lakehouse paradigms.
• Proficiency in SQL development, query tuning, and working with large datasets.
• Experience with version control tools (Git) and collaborative development practices.
• Experience working in cloud environments (AWS, Azure, or GCP), preferably with Azure Databricks or Databricks on AWS.
• Understanding of data governance, access control, and tools like Unity Catalog or Purview.
• Familiarity with CI/CD for data pipelines and automation tools like Databricks Repos, Terraform, or dbx.
• Exposure to Python or PySpark for scripting and data manipulation.

Responsibilities

• Design and implement dimensional data models (star/snowflake schemas) optimized for reporting and analytics.
• Collaborate with business stakeholders to translate reporting requirements into logical and physical data models.
• Maintain and evolve enterprise data models across domains.

Required Skills

• Deep understanding of data warehousing principles and Kimball/Inmon methodologies.
• Expertise in SQL, Databricks SQL, and data cataloging tools.
• Ability to work with source system SMEs to understand data lineage and semantics.

Reporting Relevance

Ensures data structures are optimized for Power BI, Tableau, or other BI tools, enabling performant and intuitive reporting.

Job Description

We are looking for an experienced Senior SAP HANA Modeling Consultant with strong hands-on experience in SAP Analytics Cloud (SAC) and SAP Datasphere. The ideal candidate will have deep expertise in designing, developing, and optimizing analytical data models and reports in a cloud or hybrid environment.

Key Responsibilities:

Design and develop SAP HANA Calculation Views (Graphical & SQL Script).

Build complex data models for reporting and analytics using SAC and Datasphere.

Integrate data from S/4HANA, BW/4HANA, and other sources into HANA and Datasphere.

Create dashboards, visualizations, and stories in SAP Analytics Cloud (SAC).

Optimize query performance and data processing in large datasets.

Collaborate with business users to understand analytical requirements and translate them into technical solutions.

Work with BTP services, Data Warehouse Cloud, and integration with SAC live connections.

Required Skills & Experience:

5–12 years of total experience in SAP HANA and SAC.

Strong experience in HANA Modeling, SQL Script, and Calculation Views.

Hands-on experience with SAP Datasphere / Data Warehouse Cloud.

Knowledge of BTP, OData services, and integration scenarios.

Good understanding of data modeling best practices and performance tuning.

Strong analytical, communication, and client-facing skills.

Location : Bangalore / Hyderabad / Pune / Chennai (On-site)

Notice Period : Immediate to 30 days preferred

We are seeking a highly skilled Data Modeler with deep experience in the CPG (preferably) domain to join our data engineering team. You will be responsible for designing scalable and business-aligned data models to support analytical and operational use cases across functions like Sales, Trade, Supply Chain, Marketing, and Finance. This role requires close collaboration with both business stakeholders and technical teams to ensure data structures accurately reflect business processes and drive actionable insights

Key Responsibilities

• Design and develop conceptual, logical, and physical data models aligned with CPG business requirements.
• Collaborate with stakeholders to gather and interpret data requirements across domains such as Retail Execution, Customer 360, Trade Promotion, and Supply Chain.
• Translate KPIs and business rules into structured models supporting reporting, data warehousing, and advanced analytics.
• Apply industry-standard modelling techniques like dimensional modelling (star/snowflake), 3NF, and data vault.
• Document models through ER diagrams, data dictionaries, and metadata to support governance and knowledge sharing.
• Work with data engineering teams to implement models on cloud platforms such as Snowflake, Databricks, or Azure Synapse.
• Ensure modelling standards and best practices are followed for consistency and scalability across teams.
• Support BI and analytics teams by building models that enable effective selfservice analytics and reporting.
• Align models with data quality, lineage, and compliance frameworks (e.G., GS1 standards for product data).
• Continuously optimize data models based on evolving business needs and system performance.

Required Skills and Experience

• BE/BS/MTech/MS in Computer Science or equivalent work experience.
• 5+ years of experience in data modelling with exposure to CPG domain preferred.
• Proficient in dimensional modelling, 3NF, and data vault methodologies.
• Hands-on experience with data modelling tools such as ER/Studio, Erwin, or dbt.
• Strong understanding of SQL and data warehousing principles.
• Experience working with modern cloud data platforms (Snowflake, Azure Synapse, Databricks).
• Excellent communication skills to bridge business and technical teams.
• Experience collaborating with cross-functional stakeholders like engineers, BI developers, and analysts.
• Ability to guide teams and promote modelling best practices in cloud-based data environments.
• Cloud certifications (e.G., Azure Data Engineer Associate, AWS Big Data Specialty, Google Data Engineer).
• Experience with data governance and catalog tools like Unity Catalog, Azure Purview, or Collibra.
• Knowledge of MDM concepts and tools, especially within the CPG context.
• Familiarity with GS1 standards and product hierarchy management.
• Exposure to Agile or SAFe delivery frameworks.
• Certifications in data architecture or modelling (e.G., CDMP).
• Prior experience leading data teams of 10–20+ members.
• Strong ability to balance strategic thinking with hands-on implementation.

Hi All,

Greetings for the day!

We are hiring for one of our renowned IT Global MNC Clients.

PFB the job details 

Job Title : data Modeling Techniques and Methodologies

Job Location : Bangalore /Mumbai/Chennai /Hyderabad/Kolkata

Total Exp = 6+yrs

Role: SAP Data Engineer (DataSphere/BW/HANA/Data Modeling)

Client NBCUniversal

Location: Remote in India

Duration: 12-month contract with extensions

Job Description:

Provide state-of-the-art technical support for the SAP Datasphere, BW4 Systems maintenance and enhancements, including integration to other systems. This includes participating in project implementation, design, and development activities to support the successful business adoption of the new solution, and the ongoing production support and enhancement post go-live. This role requires a strong understanding of Financial/HR Reporting/BPC and proven experience in designing and delivering high-quality solutions through technical development that meet overall business requirements.

Candidates' Core Skillset Must Be:

• DataSphere
• S4 Hana
• SAC
• BW Data Modeling

Plusses:

• SAP ABAP, HANA/AMDP/CDS, SOAP/OData/Rest API’s etc.

Role: SAP Data Engineer (DataSphere/BW/HANA/Data Modeling)

Client NBCUniversal

Location: Remote in India

Duration: 12-month contract with extensions

Job Description:

Provide state-of-the-art technical support for the SAP Datasphere, BW4 Systems maintenance and enhancements, including integration to other systems. This includes participating in project implementation, design, and development activities to support the successful business adoption of the new solution, and the ongoing production support and enhancement post go-live. This role requires a strong understanding of Financial/HR Reporting/BPC and proven experience in designing and delivering high-quality solutions through technical development that meet overall business requirements.

Candidates' Core Skillset Must Be:

• DataSphere
• S4 Hana
• SAC
• BW Data Modeling

Plusses:

• SAP ABAP, HANA/AMDP/CDS, SOAP/OData/Rest API’s etc.