Data Modeller/Architect

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.

We are looking for an experienced Data Modeller/Architect at Barclays to lead the design and evolution of Barclays’ enterprise data models. This is a critical leadership role requiring deep banking and/or investment banking experience to shape data strategy, ensure compliance and deliver high-value insights through robust data architecture.
 

To be successful as a Data Modeller/Architect, you should have experience with:

• ​Significant experience in data architecture or enterprise data modelling, ideally at a major bank or investment bank.

• An amazing understanding of banking products, risk frameworks, regulatory data requirements and financial markets data.

• Expertise in data modelling tools and frameworks, with experience scaling models across global functions.

• Proficiency in database systems (Oracle, SQL Server, PostgreSQL, MySQL; Snowflake/Redshift; MongoDB/Cassandra where appropriate).

• Excellent SQL and scripting skills (advanced SQL, PL/SQL or T-SQL, plus Python or Shell for automation).

• Experience with data warehousing & ETL (Inmon/Kimball methodologies, tools such as Informatica).

• Familiarity with cloud platforms (AWS: S3, Redshift, Glue, Data Lake implementation).
   

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 located at our Glasgow office.