Data Modelling, Data Analysis/Consultant Specialist

HSBC Holdings plc; Pune District; Hybrid; INR 1,800,000 - 3,000,000; Full time

Job summary

HSBC Software Development India in Pune seeks an experienced Consultant Specialist to lead data modelling and analysis for complex transformation initiatives, focusing on reconciliation, controls, and data integrity. You will elicit and document data requirements, create conceptual, logical, and physical models, and produce artefacts.

Collaboration with IT and business teams is essential. Proven 8+ years in data analysis and modelling, strong SQL skills, and experience with tools like BigQuery

Qualifications

• 8+ years of strong data analysis and/or data modeling experience in financial domain.
• Ability to translate high-level business requirements into technical solutions.
• Excellent communication and stakeholder management capabilities.

Responsibilities

• Deliver data modelling and analysis for complex transformation initiatives.
• Elicit, analyze, and document functional and non-functional data requirements.
• Create and maintain conceptual, logical, and physical data models.
• Produce modelling artefacts: ER models, data dictionaries, data mappings.
• Perform data profiling, gap and impact analysis; support estimation and delivery planning.
• Define and govern metadata to ensure quality and traceability.
• Partner with IT and business to resolve data issues; support QA/UAT with testable requirements.

Skills

Data modelling

SQL

Data Analysis

Requirements elicitation

Data governance

Data mapping

Data profiling

Stakeholder management

Education

Bachelor's in CS/Engineering

Master's preferred

Tools

BigQuery

Erwin

Visual Paradigm

Jira

Confluence

Version control

Job description

Location: Pune, MH, IN, 411006

Brand: HSBC

Area of Interest: Technology

Role Workstyle: Hybrid Worker

Date: 11 Sept 2026

Some careers shine brighter than others.

If you're looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.

HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.

We are currently seeking an experienced professional to join our team in the role of Consultant Specialist

In this role, you will:

• Deliver data modelling and analysis for complex transformation initiatives, with a focus on reconciliation, controls, and data integrity outcomes.
• Elicit, analyze, and document functional/non-functional data requirements, translating business needs into implementable technical specifications.
• Create and maintain conceptual, logical, and physical data models aligned to standards, naming conventions, and data governance.
• Produce and manage key modelling artefacts: ER models, data dictionaries/metadata, source-to-target mappings, interface specs, validation rules.
• Perform data profiling, gap and impact analysis; contribute to estimation and delivery planning with squads.
• Define and govern metadata (entities, attributes, keys/constraints, relationships) to ensure quality, traceability, and reusability across the portfolio.
• Partner across IT and business teams to resolve data issues and align definitions end-to-end; support QA/UAT with testable requirements, reconciliation checks, and acceptance criteria, using advanced SQL and relevant tooling (e.g., BigQuery, Erwin, Visual Paradigm, Jira/Confluence, version control).

To be successful in this role, you should meet the following requirements:

• Bachelor’s degree in computer science, Engineering, or a related field; Master’s degree preferred.
• Strong Data Analysis and/or Data Modeling experience of 8+ years
• Strong financial domain and data analysis skills with experience covering activities like requirement gathering, elicitation skills, gap analysis, data analysis, effort estimation, reviews, ability to translate the high-level functional data or business requirements into technical solution, database designing and data mapping
• Excellent communication & stakeholder management skills and should be capable of building rapport and relationships
• Act as a liaison between business and technical teams to bridge any gaps and assist the business teams & technical teams to successfully deliver the projects
• Strong dimensional/relational modelling skills. Excellent analytical problem-solving with advanced SQL and BI/visualization
• Ability to influence and drive changes within a complex organizational structure.
• Strong analytical skills to assess engineering practices and recommend improvements.

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by - HSBC Software Development India