Lead Data Analyst

Barclays; Glasgow; On-site; GBP 85,000 - 110,000; Full time

Job summary

Barclays in Glasgow seeks a Lead Data Analyst to drive data-driven transformation through advanced analytics, data modelling, and stakeholder collaboration across business, technology and product squads.

The role focuses on translating complex needs into scalable data solutions, building data pipelines, and delivering actionable insights via dashboards and reports. Strong banking domain knowledge is valuable for success.

Qualifications

• HHands-on data analysis and modelling capability as the key discriminator.
• Strong SQL proficiency for data profiling, reconciliation, investigation and root-cause analysis.
• Translate business and data requirements into BRDs/FRDs, epics, features and user stories with clear acceptance criteria.
• Experience with source-to-target mapping and transformation rules across complex data landscapes.
• Exposure to data platforms such as Snowflake or Databricks is desirable.

Responsibilities

• Investigation and analysis of data quality, lineage, controls, and authoritative source identification, documenting data sources, methodologies, and quality findings with recommendations for improvement.
• Designing and building data pipelines to automate data movement and processing.
• Apply advanced analytical techniques to large datasets to uncover trends and correlations, develop validated logical data models, and translate insights into actionable business recommendations that drive operational and process improvements, leveraging machine learning/AI.
• Translate analytical findings into actionable business recommendations, identifying opportunities for operational and process improvements.
• Design and create interactive dashboards and visual reports using applicable tools and automate reporting processes for regular and ad-hoc stakeholder needs.

Skills

SQL proficiency

Breadth of data modelling

Agile analysis

Stakeholder engagement

Data requirements translation

Tools

Snowflake

Databricks

Job description

Join our team as a Lead Data Analyst, where you will play a key role in enabling data-driven transformation across the bank. The ideal candidate will have strong experience in Agile analysis, stakeholder engagement and banking products, with the ability to translate complex business needs into scalable data solutions, uncover valuable insights through advanced analytics, and deliver meaningful outcomes through effective collaboration with business, technology and product teams.
To be successful as a Lead Data Analyst you must have the following essential skills:

• Strong banking/domain knowledge is valuable, but hands-on data analysis and modelling capability is the key discriminator.
• Demonstrable SQL proficiency for data profiling, reconciliation, investigation, and root-cause analysis.
• Able to translate business and data requirements into BRDs/FRDs, epics, capabilities, features, user stories and clear acceptance criteria..
• Experience with source-to-target mapping and transformation rules across complex data landscapes.

Some Other Highly Valued Skills May Include

• Practical experience defining Data Quality rules, identifying exceptions, and driving remediation
• Strong understanding of data lineage and authoritative source identification.
• Evidence of working hands-on with Data Products, shaping the underlying data rather than primarily managing the backlog.
• Comfortable with backlog refinement, feature mapping, PI/Agile ceremonies, Definition of Ready/Done, testing and defect triage.
• Exposure to modern data platforms such as Snowflake / Databricks / cloud data ecosystems is highly desirable.

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 located in our Glasgow office.
Purpose of the role To enable data-driven strategic and operational decision making through extracting actionable insights from large datasets, performing statistical and advanced analytics to uncover trends and patterns, and presenting findings through clear visualisations and reports.
Accountabilities

• Investigation and analysis of data issues related to quality, lineage, controls, and authoritative source identification, documenting data sources, methodologies, and quality findings with recommendations for improvement
• Designing and building data pipelines to automate data movement and processing.
• Apply advanced analytical techniques to large datasets to uncover trends and correlations, develop validated logical data models, and translate insights into actionable business recommendations that drive operational and process improvements, leveraging machine learning/AI.
• Through data-driven analysis, translate analytical findings into actionable business recommendations, identifying opportunities for operational and process improvements.
• Design and create interactive dashboards and visual reports using applicable tools and automate reporting processes for regular and ad-hoc stakeholder needs.

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 elevate 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.