Data Modeller

Capco
Bengaluru, Pune, Mumbai
Full timeFunction: Data Analytics & Business IntelligenceEducation: bachelorsSkills: ["Analytical","Problem-solving","Documentation","Stakeholder-management","Attention to detail"]

Design, develop, and maintain enterprise data models that translate business and technology requirements into scalable, well-governed structures. Work with data architects, data engineers, and application teams to build conceptual/logical/physical models for data warehouses, data lakes, and analytics platforms. Define entities, relationships, hierarchies, keys, and domains; establish data dictionaries and metadata standards; support data governance, reviews, and source-to-target/data transformation mapping across cloud and on-prem environments.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Capco
Capco
3 days ago

Data Modeller

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 21 minutes agoStatus: Live

Job Summary

Design, develop, and maintain enterprise data models that translate business and technology requirements into scalable, well-governed structures. Work with data architects, data engineers, and application teams to build conceptual/logical/physical models for data warehouses, data lakes, and analytics platforms. Define entities, relationships, hierarchies, keys, and domains; establish data dictionaries and metadata standards; support data governance, reviews, and source-to-target/data transformation mapping across cloud and on-prem environments.
Location: Bengaluru, Pune, Mumbai
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence

Key Responsibilities

  • •Design and maintain conceptual, logical, and physical data models aligned with business and technology requirements.
  • •Translate business and data requirements into clear, scalable data structures and definitions.
  • •Develop data models for data warehouses, data lakes, operational systems, and analytics platforms.
  • •Define entities, attributes, relationships, hierarchies, keys, and data domains using modelling techniques (relational, dimensional, normalized/denormalized).
  • •Support data governance by establishing data dictionaries, metadata standards, lineage/ownership/quality concepts, and performing model reviews with stakeholders.

Key Requirements

  • •Strong experience in data modelling, data architecture, or data management roles.
  • •Hands-on development of conceptual, logical, and physical data models.
  • •Strong knowledge of relational database concepts, normalization, dimensional modelling, and database design.
  • •Experience with SQL to analyze complex datasets and database structures.
  • •Proficiency with data modelling tools (e.g., ERwin, ER/Studio, PowerDesigner, Sparx Enterprise Architect) and modern data platforms (e.g., Snowflake, Databricks, Oracle, SQL Server, PostgreSQL).
Experience:BankingFinancial servicesInsuranceRegulated industries
Education:Bachelor's in Computer Science, Information Technology, Data Engineering, or related discipline
Skills:AnalyticalProblem-solvingDocumentationStakeholder-managementAttention to detail
Languages:English
Tech Stack:SQLERwinER/StudioPowerDesignerSparx Enterprise ArchitectSnowflakeDatabricksOracleSQL ServerPostgreSQLAzureAWSGCPData warehousesData lakesData lakehouse architecturesETLELTCollibraAlation

Company Brief

Capco
Global management and technology consultancy specializing in financial services. Capco advises banks, insurers, and capital markets firms on digital transformation, risk and compliance, technology implementation, and operational improvement, combining industry expertise with advisory and engineering capabilities.
Industry: Management Consulting
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: London, United Kingdom
Founded: 1998
Glassdoor
Glassdoor: 3.7
WebsiteLinkedIn