Professional Experience
- At least 5 years of data modelling experience, preferably within the financial services industry working on large scale data migration programmes
- Full project lifecycle implementation experience including familiarity of agile projects
Mandatory Skillset required for Data Modeller
- Market reference data, Financial and Investment background
- UML class diagrams
- tools: for example: Erwin, ER Studio, Sparx Enterprise Architect, Data Modelling
Candidates must be able to:
- Create a logical model diagram from a set of user stories
- Review a logical model against a set to user stories
- Check a logical mode for consistency, normalisation, and correctness
Data Modeler Data Management & Strategy
Importance of Role
LSEG is the leading provider of news and financial information in the world. On its own, the value of its data is significant, but usability and insights are significantly enhanced based on the way we organize and arrange our data in order to make it understandable and discoverable.
Our customers need to connect traditional market and reference data with alternative and unstructured data assets and aggregate these datasets for multiple use cases. The LSEG Data Model standardizes the concepts our data represents. The successful execution of a data and technology strategy that leverages these data models and this connected data provides better ideas through more insightful analysis, more accurate calculation of risk exposure, and eases regulatory reporting requirements. For these reasons, utilization of connected datasets results in a significant competitive advantage.
This role presents a rare opportunity for someone with a passion for data modelling to work within a team of data architects & modellers to produce an enterprise-wide data model. The role itself has a number of facets; business analysis to gain the necessary level of understanding for the data definition and usage, production of the data model and the forward engineering of the physical implementation. The role will be responsible for identifying data entities and describing the relationships between them, as a model, based on business context, process and existing systems clearly showing source to target mappings. Support both intra-system data design and embedding of metadata management behaviours. The role will also support the execution of governance related activities, including review forums and project delivery in adherence to standards.
Knowledge & Skills required
- Good understanding of financial reference and/or market reference data.
- Data modelling skills and a working knowledge of the difference between conceptual, logical and physical models.
- In-depth knowledge of database structures for reference data as well as methods of working for sourcing and capturing this data
- Understanding of UML and ERD for logical data models is essential for this role
- Understanding of RDBMS s and proficiency with SQL
- Experience of Sparx Systems Enterprise Architect, or other visual data modelling tools desirable but not essential
- Understanding of JSON and/or XML essential
Knowledge & Skills preferred, but not required
- Strong analytical skills with methodical and independent approach to problem solving
- Excellent verbal and written communication skills
- Eagerness to learn and collaborate with others, quick learner and able to work with little supervision
- Able to liaise across the organization, including News, Content Ops, Product Management, and Technology
- Stakeholder Management experience and skills - able to converse with all levels of stakeholders to understand and extract the required business requirements
- Excellent oral and written communication skills
- Collaborative approach
- Organize and facilitate meetings & workshops and record actions and decisions
- Exposure and understanding of different agile approaches and good working knowledge of analysis tools including Jira
- Working closely with subject matter experts & data architects, analyze the data requirements & produce the LSEG Data Model
- Identify problems and issues in the current architecture
- Participate in the generation of the physical implementation of the data model
- Execute governance related activities, participating in reviews & ensuring conformance to standards
Certifications / Education
- University degree strongly preferred
Behavioral Competencies
- Collaborating across boundaries
- Focusing on customers
- Championing innovation
Driving results
Data Modeler
