Data Modeler

Capco; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Capco is seeking an experienced Data Modeller in Mumbai to design, develop, and maintain enterprise data models for business, analytics, and technology requirements.

You will work with stakeholders, data architects, data engineers, and application teams to translate complex requirements into scalable, well-governed data models across data warehouses, lakes, and analytics platforms.

Qualifications

• Experience in data modelling, architecture, or data management roles.
• Proficient in conceptual, logical, and physical data models.
• Strong SQL knowledge and data analysis skills.
• Experience with Snowflake, Databricks, Oracle, SQL Server, or PostgreSQL.
• Experience with one cloud platform (Azure, AWS, or GCP).
• Familiarity with data governance and metadata management.

Responsibilities

• Design conceptual, logical, and physical data models aligned with business needs.
• Translate business requirements into 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 and dimensional models.
• Collaborate with data architects/engineers for scalable, performant models.
• Conduct source-to-target mapping and data transformation analysis.
• Maintain data dictionaries, metadata, and standards.
• Support data governance with data ownership and lineage.
• Review and optimize existing data models.

Skills

Data Modelling

Data Architecture

Data Management

SQL

ETL/ELT

Data Warehousing

Cloud Platforms

Jira/Confluence

Data Governance

Dimensional Modelling

Education

Bachelor in CS/IT/Data Engineering

Data Management/cloud certifications advantageous

Tools

ERwin

ER/Studio

PowerDesigner

Sparx Enterprise Architect

Collibra

Job description

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

Responsibilities

Role Overview

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 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.
• 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 methodologies and tools such as Jira and Confluence.
• Understanding of data privacy, regulatory, and information-security requirements.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related discipline, or equivalent professional experience.
• Relevant certifications in data management, cloud platforms, or data architecture are advantageous.
• Data modelling and architecture
• Business and data requirements analysis
• Data governance and metadata management
• SQL and database design
• Data warehousing and analytics
• Problem solving and attention to detail
• Technical documentation and communication

If you are keen to join us, you will be part of an organization that values your contributions, recognizes your potential, and provides ample opportunities for growth. For more information, visit www.capco.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube.