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
Responsibilities
Job Description – Data Modeller
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.
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 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.
Key Competencies
- Data modelling and architecture
- Business and data requirements analysis
- Data governance and metadata management
- SQL and database design
- Data warehousing and analytics
- Stakeholder management
- 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.
