Data Modeller

Job Description

Purpose of the role

To design, implement, and maintain conceptual, Logical and Physical data models that meet business data/process and technology requirements, by using designs and data strategies across a wide selection of platforms. 

Accountabilities

• Analysis and documentation of business requirements to translate them into data models aligned with organisational goals.
• Development and maintenance of data dictionaries and glossaries to define data elements and their usage.
• Analysis and monitoring of data usage patterns to identify opportunities for data optimisation and improvement, in partnership with the Data Base Administrator.
• Strategic architecture definition and product selection.
• Production of logical designs in relevant subject area (technical, data, operational), showing for example: processes, objects, data flows, inputs, stored data and outputs. Identifying common components.
• Implementation of architectures and Identification, ownership and resolution of design related issues.
• Definition and documentation of data architectures standards, principles and strategies.

Vice President Expectations

• To contribute or set strategy, drive requirements and make recommendations for change. Plan resources, budgets, and policies; manage and maintain policies/ processes; deliver continuous improvements and escalate breaches of policies/procedures..
• If managing a team, they define jobs and responsibilities, planning for the department’s future needs and operations, counselling employees on performance and contributing to employee pay decisions/changes. They may also lead a number of specialists to influence the operations of a department, in alignment with strategic as well as tactical priorities, while balancing short and long term goals and ensuring that budgets and schedules meet corporate requirements..
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others..
• OR for an individual contributor, they will be a subject matter expert within own discipline and will guide technical direction. They will lead collaborative, multi-year assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will train, guide and coach less experienced specialists and provide information affecting long term profits, organisational risks and strategic decisions..
• Advise key stakeholders, including functional leadership teams and senior management on functional and cross functional areas of impact and alignment.
• Manage and mitigate risks through assessment, in support of the control and governance agenda.
• Demonstrate leadership and accountability for managing risk and strengthening controls in relation to the work your team does.
• Demonstrate comprehensive understanding of the organisation functions to contribute to achieving the goals of the business.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategies.
• Create solutions based on sophisticated analytical thought comparing and selecting complex alternatives. In-depth analysis with interpretative thinking will be required to define problems and develop innovative solutions.
• Adopt and include the outcomes of extensive research in problem solving processes.
• Seek out, build and maintain trusting relationships and partnerships with internal and external stakeholders in order to accomplish key business objectives, using influencing and negotiating skills to achieve outcomes.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.

Join us as a Data Modeller at Barclays, where you will design, implement, and maintain conceptual, Logical and Physical data models that meet business data/process and technology requirements, by using designs and data strategies across a wide selection of platforms.

To be successful as Data Modeller you should have:

• Experienced in Conceptual, Logical and Physical Data Modelling - different types of tables, meaning, concepts, should be able to explain real-world scenarios with use-cases.

• Excellent SQL Skills, Ability to do data cleansing/quality checks and data profiling.

• Good understanding of Data Flow from Source to Target, Data Lineage, ETL concepts and Data Transformation.

Some other highly valued skills may include:

• Good understand Data Warehousing, Data Marts, Data Lake concepts, Medallion Architecture, exposure to Cloud Data Platforms (Preferably AWS).

• Good understanding of Requirements, Stakeholder Management, ability to understand Business Functionality.

• Data Governance, Metadata Management, Reporting Layer concepts.

You may be assessed on the key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking, and digital and technology, as well as job-specific technical skills.

This role will be based in Glasgow.