Data Solution Designer

Barclays; Greater London; On-site; GBP 80,000 - 120,000; Full time

Job summary

Barclays in London (Canary Wharf) seeks a Data Solution Designer to transform our data landscape, migrating from Teradata to AWS cloud-based solutions. This role blends business-facing insight with strong technical design of scalable data products, models, and DataOps capabilities for trusted data and improved usability.

You will work with data engineering, governance, architecture and stakeholders to deliver data assets and AI-enabled automation across the data lifecycle, enabling better

Qualifications

• Experience translating business requirements into scalable data and technology solutions using AI, automation and cloud technologies.
• Strong understanding of Data Product operating models and modern data strategies for trusted, reusable data assets.
• End-to-end data solution design with data analytics and reporting to support decision-making.

Responsibilities

• Design and develop data solutions that align with modern software engineering practices and automated delivery tooling.
• Apply cloud capabilities (elasticity, serverless, containerisation) to optimise workloads.
• Incorporate security principles and governance to meet resiliency expectations.
• Balance risks and controls while delivering business and technology value.
• Collaborate across data engineering, architecture, governance and business stakeholders.

Skills

Data architecture

AI implementation

Data analytics

Stakeholder engagement

AWS cloud

Power BI

Tableau

SQL

Tools

Power BI

Tableau

Excel

JIRA

Teradata

AWS

SQL

Job description

Join Barclays as a Data Solution Designer, where you will play a key role in the strategic transformation of our data landscape as we migrate from legacy Teradata platforms to modern AWS cloud-based solutions. This is a business-facing role with a strong technical foundation, focused on analysing data requirements, designing scalable data solutions, and driving AI-enabled automation across the data engineering lifecycle. Working closely with data engineering, architecture, governance, and business stakeholders, you will help define data models, data quality standards, metadata, and DataOps capabilities that improve data usability, trust, and efficiency. The ideal candidate will bring a strong data analytics background, coupled with a solid understanding of modern data architectures, cloud technologies, SQL and data querying concepts, and how systems and data platforms integrate within large-scale enterprise environments.

To be successful in this role, you will need the following:

• Experience in solution design and AI implementation, translating business requirements into scalable data and technology solutions using AI, automation and cloud technologies.
• Strong understanding of Data Product operating models and modern data strategies to enable scalable, trusted, and reusable data assets.
• Strong understanding of data architecture and end-to-end data solution design.
• Experience in data analytics and reporting, transforming complex datasets into actionable insights to support business decision-making.
• Strong stakeholder engagement and collaboration skills across business and technology teams.
• Experience in developing data visualisations and dashboards using Power BI and Tableau.
• Advanced proficiency in Excel and experience using JIRA.

Some Other Highly Valued Skills May Include

• Experience with SQL and data engineering platforms, enabling effective collaboration with technical teams and informed decision-making on data solutions.
• Experience in project or product management across the full lifecycle, including requirements gathering, prioritisation, planning, delivery and value realisation.
• Knowledge of Teradata and data warehouse technologies.
• Experience within Financial Services or a consulting environment, with an understanding of complex stakeholder landscapes, regulatory requirements and change delivery.

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.

The successful candidate will be based in London (Canary Wharf).

Purpose of the role

To design, develop, and implement solutions to complex business problems, collaborating with stakeholders to understand their needs and requirements, and design and implement solutions that meet those needs and create solutions that balance technology risks against business delivery, driving consistency.

Accountabilities

• Design and development of solutions as products that can evolve, meeting business requirements that align with modern software engineering practices and automated delivery tooling. This includes identification and implementation of the technologies and platforms.
• Targeted design activities that apply an appropriate workload placement strategy and maximise the benefit of cloud capabilities such as elasticity, serverless, containerisation, etc.
• Best practice designs incorporating security principles (such as defence in depth and reduction of blast radius) that meet the Bank's resiliency expectations.
• Solutions that appropriately balance risks and controls to deliver the agreed business and technology value.
• Adoption of standardised solutions where they fit. If no standard solutions fit, feed into their ongoing evolution where appropriate.
• Fault finding and performance issues support to operational support teams, leveraging available tooling.
• Solution design impact assessment in terms of risk, capacity and cost impact, inc. estimation of project change and ongoing run costs.
• Development of the requisite architecture inputs required to comply with the banks governance processes, including design artefacts required for architecture, privacy, security and records management governance processes.

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, appraisal of performance relative to objectives and determination of 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.
• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc.) to solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders 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.