Data Modelling, Data Analysis/Consultant Specialist

HSBC; Hyderabad; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

HSBC Software Development India in Hyderabad seeks an experienced Consultant Specialist to join our data engineering team. You will deliver data modelling and analysis for complex transformation initiatives, work in agile squads, and translate business needs into technical specifications.

The role requires 8+ years of data analysis and modelling, strong SQL, and expertise with BigQuery, ERwin, Visual Paradigm; banking domain experience is a plus.

Qualifications

• Bachelor’s degree in computer science, engineering, or related field; Master’s degree preferred.
• 8+ years of strong data analysis and/or data modelling experience.
• Strong financial domain and data analysis skills including requirement gathering, elicitation, gap analysis, data mapping.
• Excellent communication and stakeholder management to build relationships.
• Liaise between business and technical teams to deliver projects.
• Strong dimensional/relational modelling and advanced SQL/BI visualization skills.
• Ability to influence changes within a complex organization.

Responsibilities

• Deliver data modelling and analysis for complex transformation initiatives, focusing on reconciliation, controls, and data integrity.
• Work in agile, multi-skilled squads to deliver scalable data products.
• Elicit, analyze, and document data requirements and translate them into technical specs.
• Create and maintain conceptual, logical, and physical data models with governance.
• Produce ER models, data dictionaries, source-to-target mappings, interface specs.
• Perform data profiling, gap and impact analysis, contribute to estimation and delivery planning.
• Define and govern metadata to ensure quality, traceability, and reusability.
• Partner with IT and business to resolve data issues and support QA/UAT with testable requirements.

Skills

Data modelling

Data analysis

SQL

Agile

BigQuery

Erwin

Visual Paradigm

Jira/Confluence

Version control

Education

Bachelor's degree in computer science or engineering

Master's degree preferred

Tools

BigQuery

Erwin

Visual Paradigm

Jira/Confluence

Version control

Job description

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.
• Work in agile, multi-skilled squads (Product, Architecture, Engineering, QA) to deliver scalable, reusable data products.
• 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.

You’ll achieve more when you join HSBC.

www.hsbc.com/careers

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