2,330 Olap jobs in India

Role & responsibilities

Senior Data Modeler

Primary Skills:

• Data Modeling (Fact/Dimension tables, Slowly Changing Dimensions - Type 2, Partitioning)
• Medallion Architecture
• Erwin Data Modeler

Domain Expertise:

• Experience in modeling data for large-scale Call Center environments, including:

• IVR (Interactive Voice Response)

• CALLS

• Chat interactions

• Preferred experience with platforms such as CISCO, Genesys, or Google CES

Role Overview:

We are seeking a seasoned Data Modeler with deep expertise in designing scalable and efficient data models for enterprise-level call center systems. The ideal candidate will have hands-on experience with medallion architecture and Erwin, and a strong understanding of how to model complex call center data flows.

Responsibilities:

• Design and implement robust data models to support analytics and reporting for call center operations
• Collaborate with data engineers and business stakeholders to translate requirements into scalable data solutions
• Optimize data structures for performance and maintainability
• Ensure data integrity and consistency across systems

Preferred Qualifications:

• 7+ years of experience in data modeling
• Strong understanding of call center metrics and workflows
• Familiarity with cloud data platforms (e.g., Azure, AWS, GCP) is a plus

GDT WPB DF Data Expert JD:

Mandatory Skills
Strong Data Analysis and/or Data Modeling experience of 8-12 years.
Strong financial domain and data analysis skills with experience covering activities like requirement gathering, elicitation skills, gap analysis, data analysis, effort estimation, reviews, ability to translate the high-level functional data or business requirements into technical solution, database designing and data mapping.
Comprehensive understanding of the Data Modeling conceptual, logical, and physical, create and deliver high-quality data models, by following agreed data governance and standards.Maintain quality metadata and data related artefacts which should be accurate, complete, consistent, unambiguous, reliable, accessible, traceable, and valid.
Should be an individual contributor with good understanding of the SDLC & Agile methodologies.
A team player with self-starter approach, having a sense of ownership, should be a problem solver with solution-seeking approach and an ability to work in fast paced and continuously changing environment.
Excellent communication & stakeholder management skills and should be capable of building rapport and relationships.
Act as a liaison between business and technical teams to bridge any gaps and assist the business teams & technical teams to successfully deliver the projects.
Other Skills and Tools SQL, MS Office tools, GCP Big Query, Erwin, Visual Paradigm preferable.
Responsibilities
Support the delivery of complex transformation program development within data portfolio.
Work within agile multi-skilled teams to create world class products to serve our customers needs.
Perform the elicitation and analysis of business change, functional and non functional requirements across a range of stakeholders, work with cross asset IT teams to interface those requirements and finally deliver a working reconciliation solution.
Own and produce relevant analysis and modeling artefacts that enable development teams to develop working products.
Understand the user journey end to end which goes beyond the system.
Provide advanced business knowledge and technical support for requirements development.
Create/enhance logical and physical data models by adhering to the agreed standards, to fulfil both business as well as technical requirements and expectations.
Undertake the metadata analysis which includes but not limited to naming of the logical entity and attributes and physical table and columns, definitions and appropriate data type and length etc.
Create and maintain the data models.

GDT WPB DF Data Expert JD:

Mandatory Skills
Strong Data Analysis and/or Data Modeling experience of 8-12 years.
Strong financial domain and data analysis skills with experience covering activities like requirement gathering, elicitation skills, gap analysis, data analysis, effort estimation, reviews, ability to translate the high-level functional data or business requirements into technical solution, database designing and data mapping.
Comprehensive understanding of the Data Modeling conceptual, logical, and physical, create and deliver high-quality data models, by following agreed data governance and standards.Maintain quality metadata and data related artefacts which should be accurate, complete, consistent, unambiguous, reliable, accessible, traceable, and valid.
Should be an individual contributor with good understanding of the SDLC & Agile methodologies.
A team player with self-starter approach, having a sense of ownership, should be a problem solver with solution-seeking approach and an ability to work in fast paced and continuously changing environment.
Excellent communication & stakeholder management skills and should be capable of building rapport and relationships.
Act as a liaison between business and technical teams to bridge any gaps and assist the business teams & technical teams to successfully deliver the projects.
Other Skills and Tools SQL, MS Office tools, GCP Big Query, Erwin, Visual Paradigm preferable.
Responsibilities
Support the delivery of complex transformation program development within data portfolio.
Work within agile multi-skilled teams to create world class products to serve our customers needs.
Perform the elicitation and analysis of business change, functional and non functional requirements across a range of stakeholders, work with cross asset IT teams to interface those requirements and finally deliver a working reconciliation solution.
Own and produce relevant analysis and modeling artefacts that enable development teams to develop working products.
Understand the user journey end to end which goes beyond the system.
Provide advanced business knowledge and technical support for requirements development.
Create/enhance logical and physical data models by adhering to the agreed standards, to fulfil both business as well as technical requirements and expectations.
Undertake the metadata analysis which includes but not limited to naming of the logical entity and attributes and physical table and columns, definitions and appropriate data type and length etc.
Create and maintain the data models.

About Evernorth:

Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention, and treatment of illness and disease more accessible to millions of people.

Data Modeling Advisor
Position Summary:

The Health Services Data Design and Metadata Management team is hiring an Architecture Senior Advisor to work across all projects. The work involves understanding and driving data design best practices, including data modeling, mapping, and analysis, and helping others to apply them across strategic data assets. The data models are wide-ranging and must include the appropriate metadata to support and improve our data intelligence. Data design centers around standard health care data (eligibility, claim, clinical, and provider data) across structured and unstructured data platforms.

Job Description & Responsibilities:

• Perform data analysis, data modeling, and data mapping following industry and Evernorth data design standards for analytics/data warehouses and operational data stores across various DBMS types, including Teradata, Oracle, Cloud, and Hadoop, Databricks and datalake.
• Perform data analysis, profiling and validation, contributing to data quality efforts to understand data characteristics and ensure data correctness/condition for use.
• Participate in and coordinate data model metadata development processes to support ongoing development efforts (data dictionary, NSM, and FET files), maintenance of data model/data mapping metadata, and linking of our data design metadata to business terms, data models, mapping documents, ETL jobs, and data model governance operations (policies, standards, best practices).
• Facilitate and actively participate in data model/data mapping reviews and audits, fostering collaborative working relationships and partnerships with multidisciplinary teams.
• Provide guidance, mentoring, and training as needed in data modeling, data lineage, ddl code, and the associated toolsets (Erwin Data Modeler, Erwin Web Portal, Erwin model mart, Erwin Data Intelligence Suite, Alation). Assist with the creation, documentation, and maintenance of Evernorth data design standards and best practices involving data modeling, data mapping, and metadata capture including data sensitivity, data quality rules, and reference data usage. Develop and facilitate strong partnerships and working relationships with Data Governance, delivery, and other data partners. Continuously improve operational processes for data design metadata management for global and strategic data.
• Interact with Business stakeholders and IT in defining and managing data design. Coordination, collaboration, and innovation with Solution Verticals, Data Lake teams, IT & Business Portfolios to ensure alignment of data design metadata and related information with ongoing programs (cyber risk and security) and development efforts.

Experience Required:

• 11 to 13 years' experience with data modeling (logical / physical data model, canonical structures, etc.) and SQL code;

Experience Desired:

• Subject matter expertise level experience preferred
• Experience executing data model / data lineage governance across business and technical data.
• Experience utilizing data model / lineage / mapping / analysis management tools for business, technical and operational metadata (Erwin Data Modeler, Erwin Web Portal, Erwin Model Mart, Erwin Data Intelligence Suite, Alation
• Experience working in an Agile delivery environment (Jira, Confluence, SharePoint, Git, etc.)

Education and Training Required:

• Advanced degree in Computer Science or a related discipline and at least six, typically eight or more years experience in all phases of data modeling, data warehousing, data mining, data entity analysis, logical data base design and relational data base definition, or an equivalent combination of education and work experience.

Primary Skills:

• Physical Data Modeling, Data Warehousing, Metadata, Reference Data, Data Mapping
• Data Mining, Teradata, Data Quality, Excellent Communication Skills, Data Analysis, Oracle
• Data Governance, Database Management System, Jira, DDL, Data Integration, Microsoft, SharePoint, Database Modeling, Confluence, Agile, Marketing Analysis, SharePoint, Operations, Topo, Data Lineage, Data Warehouses, Documentation
• Big Data, Web Portal, Maintenance, Erwin, SQL, Unstructured Data, Audit, Git, Pharmacy
• DBMS, Databricks, AWS

Job Title: Architect - Data Modeling

Location: Bengaluru, Chennai, Hyderabad, Pune and Delhi NCR

Role & Responsibilities:

As an Architect, you will work to solve some of the most complex and captivating data management problems that would enable them as a data-driven organization; Seamlessly switch between roles of an Individual Contributor, team member, and Data Modeling Architect as demanded by each project to define, design, and deliver actionable insights.

On a typical day, you might

· Engage the clients & understand the business requirements to translate those into data models.

· Analyze customer problems, propose solutions from a data structural perspective, and estimate and deliver proposed solutions.

· Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) by applying best practices to provide business insights.

· Use the Data Modelling tool to create appropriate data models

· Create and maintain the Source to Target Data Mapping document that includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.

· Gather and publish Data Dictionaries.

· Ideate, design, and guide the teams in building automations and accelerators

· Involve in maintaining data models as well as capturing data models from existing databases and recording descriptive information.

· Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.

· Use version control to maintain versions of data models.

· Collaborate with Data Engineers to design and develop data extraction and integration code modules.

· Partner with the data engineers & testing practitioners to strategize ingestion logic, consumption patterns & testing.

· Ideate to design & develop the next-gen data platform by collaborating with cross-functional stakeholders.

· Work with the client to define, establish and implement the right modelling approach as per the requirement

· Help define the standards and best practices

· Involve in monitoring the project progress to keep the leadership teams informed on the milestones, impediments, etc.

· Coach team members, and review code artifacts.

· Contribute to proposals and RFPs

Skills & Experience:

· 10+ years of experience in Data space exp into Data Modeling (Dimensional, Relational, Physical etc)

· Decent SQL knowledge

· Able to suggest modeling approaches for a given problem.

· Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)

· Real-time experience working in OLAP & OLTP database models (Dimensional models).

· Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality.

· Eye to analyze data & comfortable with following agile methodology.

· Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)

· Enthuse to coach team members & collaborate with various stakeholders across the organization and take complete ownership of deliverables.

· Experience in contributing to proposals and RFPs

· Good experience in stakeholder management

· Decent communication and experience in leading the team

· Good to have hands-on experience or knowledge of Data Marts & Data Vaults

Warm Greeting from SP Staffing Services

We have an urgent opening from our client for the position below.

Data Modeling / C2H/ F2F Interview

Exp: 5 to 9 Yrs

Notice Period: Immediate

Location: Bangalore

JD:

Mandatory Skills PGS: Data Engineering

Alternate Skills

Good to have (Not Mandatory)

Detailed Job Description "
• Minimum 5 years of experience in SQL Server or other DBMS Development.

• Strong Experience in development of SSIS or other ETL tools and Automation Jobs.

• Strong Experience in Data Modeling & Design of DB Objects.

• Strong data analysis skills & problem solving skills.

• Familiarity with Agile methodologies and tools like Jira.

• Experience using GitHub for version control and collaboration.

• Working closely with data analysts, data scientists, and other stakeholders to understand data requirements, provide data access, and support their analytical and reporting needs.

Good to Have (not mandatory)

• Experience or knowledge MongoDB.

• Experience or knowledge Snowflake DB.

• Exposure to AI Projects.

• Exposure to DevOps tools and practices"

If you are interested, please share your updated resume with or

Role & responsibilities

• 10+ years of experience in Data space.
• Decent SQL knowledge
• Able to suggest modeling approaches for a given problem.
• Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)
• Real-time experience working in OLAP & OLTP database models (Dimensional models).
• Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality.
• Eye to analyze data & comfortable with following agile methodology.
• Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)
• Enthuse to coach team members & collaborate with various stakeholders across the organization and take complete ownership of deliverables.
• Experience in contributing to proposals and RFPs
• Good experience in stakeholder management
• Decent communication and experience in leading the team

Curious about the role? What your typical day would look like?

As an Architect, you will work to solve some of the most complex and captivating data management problems that would enable them as a data-driven organization; Seamlessly switch between roles of an Individual Contributor, team member, and Data Modeling Architect as demanded by each project to define, design, and deliver actionable insights.

On a typical day, you might

• Engage the clients & understand the business requirements to translate those into data models.

• Analyze customer problems, propose solutions from a data structural perspective, and estimate and deliver proposed solutions.

• Create and maintain a Logical Data Model (LDM) and Physical Data Model (PDM) by applying best practices to provide business insights.

• Use the Data Modelling tool to create appropriate data models

• Create and maintain the Source to Target Data Mapping document that includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.

• Gather and publish Data Dictionaries.

• Ideate, design, and guide the teams in building automations and accelerators

• Involve in maintaining data models as well as capturing data models from existing databases and recording descriptive information.

• Contribute to building data warehouse & data marts (on Cloud) while performing data profiling and quality analysis.

• Use version control to maintain versions of data models.

• Collaborate with Data Engineers to design and develop data extraction and integration code modules.

• Partner with the data engineers & testing practitioners to strategize ingestion logic, consumption patterns & testing.

• Ideate to design & develop the next-gen data platform by collaborating with cross-functional stakeholders.

• Work with the client to define, establish and implement the right modelling approach as per the requirement

• Help define the standards and best practices

• Involve in monitoring the project progress to keep the leadership teams informed on the milestones, impediments, etc.

• Coach team members, and review code artifacts.

• Contribute to proposals and RFPs

Job Requirement

What do we expect?

• 10+ years of experience in Data space.

• Decent SQL knowledge

• Able to suggest modeling approaches for a given problem.

• Significant experience in one or more RDBMS (Oracle, DB2, and SQL Server)

• Real-time experience working in OLAP & OLTP database models (Dimensional models).

• Comprehensive understanding of Star schema, Snowflake schema, and Data Vault Modelling. Also, on any ETL tool, Data Governance, and Data quality.

• Eye to analyze data & comfortable with following agile methodology.

• Adept understanding of any of the cloud services is preferred (Azure, AWS & GCP)

• Enthuse to coach team members & collaborate with various stakeholders across the organization and take complete ownership of deliverables.

• Experience in contributing to proposals and RFPs

• Good experience in stakeholder management

• Decent communication and experience in leading the team

You are important to us, lets stay connected

Every individual comes with a different set of skills and qualities so even if you dont tick all the boxes for the role today, we urge you to apply as there might be a suitable/unique role for you tomorrow.

We are an equal-opportunity employer. Our diverse and inclusive culture and values guide us to listen, trust, respect, and encourage people to grow the way they desire.

Note: The designation will be commensurate with expertise and experience. Compensation packages are among the best in the industry.

Job Title: Data Modeler

Job Type: Full-time

Location: Hyderabad & Mumbai

Job Description:

About the Role

We are seeking an experienced Data Modeler with strong expertise in the Private Equity and Investment domain . The ideal candidate will have a proven track record of designing and implementing canonical data models , developing logical and physical models , and working within Databricks Medallion architecture . This role also involves data profiling and building data validations (source-to-target mappings) to ensure data quality, accuracy, and consistency across the enterprise. The Data Modeler will collaborate with cross-functional teams including data engineering, business stakeholders, and product owners.

Key Responsibilities

• Design and build canonical data models to support private equity and investment management business processes.
• Develop logical and physical data models that align with enterprise architecture and cloud strategy.
• Work within Azure Databricks Medallion architecture (Bronze/Silver/Gold layers) to design data flows and ensure consistency.
• Partner with data engineering teams to implement models and optimize for scalability and performance.
• Collaborate with business stakeholders, product owners, and analysts to gather requirements and translate them into data models.
• Ensure data standardization, lineage, and governance across applications and integrations.
• Document data models, business definitions, and metadata to support ongoing governance.
• Provide thought leadership on best practices for canonical modeling, financial data integration, and cloud data architecture .

Required Qualifications

• 5+ years of experience as a Data Modeler or in a similar data architecture role.
• Strong domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations).
• Proven experience creating canonical models and developing logical & physical data models .
• Hands-on experience with Azure Databricks and Medallion architecture (Bronze/Silver/Gold layers) .
• Proficiency in SQL, relational databases, dimensional modeling, and data integration patterns .
• Strong understanding of ETL/ELT pipelines and collaboration with data engineering teams.
• Excellent communication and stakeholder engagement skills to work across business and technical teams .

Must Have

• Experience with financial data standards and regulatory reporting frameworks.
• Private Equity domain knowledge and experience
• Familiarity with data governance, metadata, data cataloging
• Background in cloud-based data architecture and modern data platforms .