Data Modeller

Join Barclays as a Data Modeller and play a key role in designing robust, scalable, and high-quality data structures that power critical banking and analytics solutions. You will be responsible for translating business requirements into well-structured conceptual, logical, and physical data models that support enterprise-wide data initiatives. In this role, you will apply strong expertise in data modelling techniques to ensure clarity, consistency, and performance across relational databases. Advanced SQL skills are essential, enabling you to define, manage, and access complex data structures effectively.

You will also leverage industry-standard modelling tools such as erwin, ER/Studio, and SAP PowerDesigner to create and maintain accurate, optimized models aligned with architectural standards. Highly valued experience includes working with cloud-based data platforms such as Snowflake, Databricks, and Redshift, as well as familiarity with NoSQL modelling and big data technologies. An understanding of data governance, regulatory compliance, and data integration processes will help ensure models meet quality, security, and enterprise data management standards.

Success in this role requires adaptability, a commitment to continuous learning, and the ability to collaborate effectively with architects, engineers, analysts, and business stakeholders. Strong attention to detail is critical to ensuring data accuracy, integrity, and performance across systems.

To be successful as a Data Modeller, you should have:

• Proficiency in conceptual, logical, and physical data modelling techniques.
• Advanced SQL skills for managing and accessing relational databases.
• Experience with industry-standard data modelling tools (e.g., erwin, ER/Studio, SAP PowerDesigner).

Other highly valued skills include:

• Experience with cloud-based data platforms (e.g., Snowflake, Databricks, Redshift, etc.).
• Knowledge of NoSQL database modelling and big data technologies.
• Understanding of data governance, compliance, and data integration processes.

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 is based in Glasgow with a hybrid working model of working a minimum of 2 days per week in the office.

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.