Data Modeler (HSBC UK)

• Experience as a Data Modeler, Data Architect, or Data Analyst with a strong focus on data modeling
• Proven experience in conceptual, logical, and physical data modeling
• Hands-on experience with erwin Data Modeler and/or SAP PowerDesigner
• Strong understanding of relational database design principles and normalization techniques
• Strong SQL skills and understanding of database structures
• Understanding of data governance, data quality, and data lineage concepts
• Fluent English communication skills

Nice to have:

• Experience modeling data for BI and analytics platforms such as Tableau, QlikView, Qlik Sense, or Apache Superset
• Experience in data warehouse design (Kimball, Inmon, Data Vault)
• Knowledge of semantic layer design and analytical data modeling
• Experience with large-scale data transformation or migration programs
• Familiarity with cloud data platforms (Azure, AWS, GCP)
• Experience working with ETL/ELT processes and modern data architectures
• Understanding of master data management (MDM) concepts
• Experience with metadata management and enterprise architecture tools

• Create and maintain conceptual, logical, and physical data models
• Design enterprise-scale data models for analytics, reporting, and operational systems
• Analyze and document existing data structures, relationships, and business rules
• Collaborate with business stakeholders, BI teams, and data engineers to translate business requirements into data models
• Create and maintain data dictionaries, metadata repositories, and model documentation