Data Modeller

capco; India; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Capco is seeking an experienced Data Modeller to design, develop, and maintain enterprise data models that support business, analytics, and technology requirements. The successful candidate will work closely with business stakeholders, data architects, data engineers, and application teams to translate complex business requirements into scalable and well-governed data models.

The role involves designing conceptual, logical, and physical data models, aligning them with data governance, and

Qualifications

• Strong experience in Data Modelling, Data Architecture, or Data Management roles.
• Hands-on experience developing conceptual, logical, and physical data models.
• Strong SQL knowledge and ability to analyze complex datasets and database structures.
• Experience with data platforms such as Snowflake, Databricks, Oracle, SQL Server, or PostgreSQL.
• Experience with cloud platforms Azure, AWS, GCP (preferred).
• Knowledge of metadata management, data lineage, master/reference data, and data governance principles.
• Ability to translate business terminology and processes into structured data definitions and models.

Responsibilities

• Design and maintain conceptual, logical, and physical data models aligned with business and technology requirements.
• Translate business requirements and data requirements into clear and scalable data structures.
• Develop data models for data warehouses, data lakes, operational systems, and analytics platforms.
• Define entities, attributes, relationships, hierarchies, keys, and data domains.
• Apply modelling techniques including relational modelling, dimensional modelling (Star/Snowflake).
• Work with Data Architects and Data Engineers to ensure models are optimized for scalability, performance, integration, and maintainability.
• Establish and maintain data dictionaries, metadata, naming standards, and modelling documentation.
• Support data governance initiatives by defining data standards, ownership, lineage, and quality requirements.
• Review existing data models and identify opportunities for simplification and optimization.
• Conduct data model reviews with stakeholders and incorporate feedback.
• Support database design and implementation across cloud and on-premise environments.

Skills

Data Modelling

Data Architecture

SQL Proficiency

Data Governance

Stakeholder Management

Analytical Thinking

Tools

ERwin

ER/Studio

PowerDesigner

Sparx Enterprise Architect

Job description

Job Title: Data Modeller

About Us

"Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount . With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery."

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

Job Title: Data Modeller

Location: Bangalore, Pune,Mumbai

Job Description - Data Modeller

We are looking for an experienced Data Modeller to design, develop, and maintain enterprise data models that support business, analytics, and technology requirements. The successful candidate will work closely with business stakeholders, data architects, data engineers, and application teams to translate complex business requirements into scalable and well-governed data models.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models aligned with business and technology requirements.
• Translate business requirements and data requirements into clear and scalable data structures.
• Develop data models for data warehouses, data lakes, operational systems, and analytics platforms .
• Define entities, attributes, relationships, hierarchies, keys, and data domains.
• Apply appropriate modelling techniques, including relational modelling, dimensional modelling (Star/Snowflake), and normalized/denormalized models .
• Work with Data Architects and Data Engineers to ensure models are optimized for scalability, performance, integration, and maintainability.
• Perform source-system analysis and support source-to-target mapping and data transformation requirements.
• Establish and maintain data dictionaries, metadata, naming standards, and modelling documentation .
• Support data governance initiatives by defining data standards, business definitions, ownership, lineage, and quality requirements.
• Review existing data models and identify opportunities for simplification, standardization, and optimization.
• Conduct data model reviews with technical and business stakeholders and incorporate feedback.
• Support database design and implementation activities across cloud and on-premise environments.
• Collaborate with engineering teams during development, testing, migration, and production implementation.
• Ensure data models comply with organizational architecture, security, privacy, and governance standards.

Required Skills & Experience

• Strong experience in Data Modelling, Data Architecture, or Data Management roles.
• Hands-on experience developing conceptual, logical, and physical data models.
• Strong understanding of relational database concepts, normalization, dimensional modelling, and database design.
• Experience with data modelling tools such as ERwin, ER/Studio, PowerDesigner, Sparx Enterprise Architect, or similar tools.
• Strong SQL knowledge and ability to analyze complex datasets and database structures.
• Experience with modern data platforms and technologies such as Snowflake, Databricks, Oracle, SQL Server, or PostgreSQL.
• Experience in working with one of the cloud platforms Azure, AWS, GCP(preferred)
• Understanding of data warehousing, ETL/ELT, data integration, and data lake/lakehouse architectures.
• Knowledge of metadata management, data lineage, master/reference data, and data governance principles.
• Ability to translate business terminology and processes into structured data definitions and models.
• Strong analytical, problem-solving, documentation, and stakeholder-management skills.

Desirable Skills

• Experience within banking, financial services, insurance, or other regulated industries (Preferred Private Banking)
• Familiarity with Data Vault, canonical data models, and industry-standard data models.
• Experience working with data cataloguing and governance platforms such as Collibra, Alation, Informatica, or Microsoft Purview.
• Knowledge of cloud-native data architectures and modern data engineering practices.
• Familiarity with Agile delivery meth