Data Modeller/Architect

Barclays Group; Glasgow; On-site; GBP 50,000 - 75,000; Full time

Job summary

A leading financial services company is seeking a Data Modeller/Architect to enhance its Data Architecture team in Glasgow. The successful candidate will design and maintain data models that support business objectives and ensure regulatory compliance. Ideal applicants will possess relevant experience in data modelling, proficiency in SQL, and familiarity with cloud technologies such as AWS.

Qualifications

• Solid experience in data modelling or data architecture, ideally within financial services.
• Proficiency with data modelling tools and advanced SQL skills.
• Experience with database systems and cloud platforms.

Responsibilities

• Design, implement, and maintain data models aligned with organisational goals.
• Monitor data usage patterns for opportunities of optimisation.
• Collaborate and engage in complex data analysis from multiple sources.

Skills

Data modelling

Data architecture

SQL programming

Data warehousing concepts

Cloud platforms (AWS)

Tools

Erwin

PowerDesigner

Informatica

Job description

We’re seeking an ambitious Data Modeller/Architect to join our growing Data Architecture team at Barclays. You’ll help design, implement and maintain conceptual, logical and physical data models that drive business value, regulatory compliance and operational efficiency across a wide range of platforms.

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

• Solid experience in data modelling or data architecture, ideally within financial services or large corporates.
• Proficiency with data modelling tools (e.g., Erwin, ER/Studio, PowerDesigner).
• Excellent knowledge of conceptual, logical, and physical modelling techniques.
• Experience with database systems (relational: Oracle, SQL Server, PostgreSQL, MySQL; columnar: Redshift, Snowflake; NoSQL: MongoDB, Cassandra).
• Advanced SQL skills (DDL, DML, performance tuning) and scripting experience (PL/SQL, T-SQL, Python or Shell).
• Knowledge of data warehousing concepts (Inmon/Kimball) and ETL tools (e.g., Informatica).
• Cloud platform experience, ideally AWS (S3, Redshift, Glue) and Data Lake implementation.

You may be assessed on critical skills relevant to success in the role, including 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.

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 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 architecture standards, principles and strategies.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, evaluate performance relative to objectives and determine reward outcomes.
• 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.
• For individual contributors, they will lead collaborative assignments and guide team members through structured assignments, identify the need for inclusion of other areas of expertise, and suggest new directions for assignments or projects, using cross-functional methodologies to meet outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and develop new policies/procedures to support control and governance.
• Take ownership of risk management and controls related to work.
• Perform work related to other areas, understanding how areas coordinate and contribute to organizational objectives.
• Collaborate with other work areas to stay aligned with business activity and strategy.
• Engage in complex data analysis from multiple sources to solve problems creatively and effectively.
• Communicate complex information effectively, including sensitive or difficult content.
• Influence stakeholders to achieve desired outcomes.

All colleagues are expected to demonstrate Barclays Values of Respect, Integrity, Service, Excellence, and Stewardship, and embody the Barclays Mindset to Empower, Challenge, and Drive.