Data Modelling, Data Analysis/Consultant Specialist
HSBC · Pune, India +1 · 29d ago
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.
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