Data Modelling (Erwin/Visual Paradigm)/ Consultant Specialist

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:

• Collaborate with architects, developers, project managers to deliver suitable solution which can cope with the business need.
• Understand the Business Requirements and translate business requirements into conceptual, logical and physical Data models.
• Ability to design logical and physical data models based on business requirements
• Knowledge of banking industry data models/best practices
• Knowledge of DWH concepts like Surrogate Keys, SCD types, Normalization.
• Should have experience of working on Data modelling tools like Visual Paradigm, ERWin, IBM Infosphere Data Architect.
• Analyze and understand the Datasets and guide the team in creating Source to Target Mapping and Data Dictionaries, capturing all relevant details
• Optimize the Data Models and work with the Data Engineers to define the Ingestion logic, ingestion frequency and data consumption patterns
• Collaborate with Business Stakeholders, Data Owners, Business Analysts, Architects to design and develop next generation data platform
• Closely monitor the Project progress and provide regular updates to the leadership teams on the milestones, impediments etc
• Guide /mentor team members, and review artifacts