Are you looking for an exciting opportunity to join a dynamic and growing team in a fast paced and challenging area? This is a unique opportunity for you to work in the Data Modelling team to partner with the Business.

As an Associate within the Data Product Metadata Management team, you will manage, develop, and maintain the Asset and Wealth Management (AWM) Core Logical Data Model and the AWM Business Glossary. Your role is pivotal in creating data products that uphold and provide access to core enterprise-level data. You will understand, analyze, capture, and maintain business data requirements using data models, ensuring consistency and linking the Business Glossary for impact assessment and metadata lineage. You will integrate data models from Firmwide, other Line of Business (LOB), and development teams into AWM LOB models, providing review feedback. You will document a central data portal detailing AWM data modeling standards, ensuring its relevance and currency. You will manage the linkage between the logical data model, business glossary, and physical artifacts for traceability and consistency. You will load and version models into a central Metadata repository. You will assist Data Product owners and development teams in adopting the AWM Core Logical Data Model for application logical models and data offering models. You will help development teams map their data implementations to the logical data model for documentation, lineage to business glossary, and application model creation. Lastly, you will maintain data integrity rules, assisting data analysts in capturing business rules and translating them into clear requirement specifications and structured language data models.

Job responsibilities

Understanding, analyzing, capturing and maintaining business data requirements using data models. Ensuring these models are consistent and that the Business Glossary is linked and maintained in a manner that allows impact assessment and lineage of metadata Maintaining business data requirements in specific, normalized and extensible logical data models Review, adopt and integrate data models from Firmwide, other LOB and development teams into AWM LOB models. Provide review feedback to Firmwide and application teams Document a central data portal that details all the AWM data modelling standards. Keeping this information up to date and relevant is key Managing the linkage between the logical data model, business glossary and any physical artifacts to ensure traceability and consistency of terms and definitions Loading and versioning of the models into a central Metadata repository Assist Data Product owners and development teams to adopt and reuse AWM Core Logical Data Model in producing application logical models and data offering models Assist development teams to map their data implementations to the logical data model for documentation, lineage to business glossary and application model creation Maintain data integrity rules. Assisting data analysts with capturing business rules and translating into clear requirement specifications and then into the data model expressed in a structured language is a task the data modeler is responsible for

Required qualifications, capabilities and skills

Bachelor’s degree or equivalent preferably with a major in one of the following subjects: Finance, Commerce, Computer Science, Information Technology Minimum of 3 years of modelling experience having had exposure to conceptual, logical, canonical or semantic modelling, knowledge of data model design patterns and experience of logical data modelling within Financial Services industry Proficient with a data modelling tool such as Erwin, PowerDesigner or MagicDraw; ER (Entity Relationship) modelling to a competent level to be able to coach others in business requirements capture A good understanding of financial and business data such as: instrument data, instrument pricing data, party & account data, positions & transactions, fund data, investment performance data, index & benchmark data, market vendor data for buy-side researchers and portfolio managers Effective with minimal supervision, works under own initiative and executes with end-to-end focus; Influences and drives key aspects of the business / function Excellent communication skills with the ability to be comfortable in a confrontational situation; team player with relationship building skills

Preferred qualifications, capabilities and skills

A good understanding of different modelling notations (UML, ORM, etc.)  Metadata management, Metadata Repository, Data dictionary usage and associated tools An understanding of what constitutes best practice data governance and data quality controls including data mining, data transfer and data profiling technologies Business Analysis experience within banking and financial services industry, preferably in the Asset and Wealth Management space Working knowledge of business intelligence and analytics tools such as Alteryx, Tableau, Qlik, etc.