Data Modeller

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

Job summary

Capco is seeking an experienced Data Modeller in Mumbai to design, develop, and maintain enterprise data models that support business analytics, data governance, and technology needs.

The role involves collaborating with data architects, engineers, and business stakeholders to translate complex requirements into scalable, well-governed models for data warehouses, data lakes, and analytics platforms.

Qualifications

• Bachelor's degree or equivalent in a related field.
• Strong experience in data modelling, architecture, or management.
• Hands-on with conceptual, logical, and physical models.
• Solid understanding of relational, dimensional modelling, and DB design.
• Experience with Snowflake, Databricks, Oracle, SQL Server, or PostgreSQL.
• Proficiency in cloud platforms like Azure, AWS, or GCP.
• Knowledge of metadata, data lineage, and governance principles.
• Familiarity with data vaults and canonical data models.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Translate business requirements into scalable data structures.
• Develop models for data warehouses, data lakes, and analytics platforms.
• Define entities, attributes, relationships, keys, and data domains.
• Collaborate with architects and engineers for scalable, secure models.
• Support source-to-target mapping and data transformation requirements.
• Maintain data dictionaries, metadata, naming standards, and documentation.
• Ensure models comply with governance, security, and architecture standards.

Skills

Data Modelling

Data Architecture

SQL

Cloud Platforms

Data Governance

Data Management

Analytical Thinking

Education

Bachelor's degree in CS/IT/Data Engineering

Tools

ERwin

ER/Studio

PowerDesigner

Sparx Enterprise Architect

Job description

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 acrossbanking, 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 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.
• 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

Ifyouarekeentojoinus,youwillbepartofanorganizationthatvaluesyourcontributions,recognizesyourpotential,andprovidesampleopportunitiesforgrowth.Formoreinformation,visitwww.capco.com .FollowusonTwitter,Facebook,LinkedIn,andYouTube.