Barclays Data Analyst candidates report an SQL-heavy screen, often with Python or basic DSA, followed by behavioral, manager and HR conversations. The format varies by team and entry route.
$108K
Avg. Base Comp
$125K
Avg. Total Comp
2-5 rounds
Typical Rounds
Not reported
Process Length
Candidates who interviewed for Data Analyst roles at Barclays describe SQL as the technical core, with behavioral questions carrying real weight. One reports an online assessment with five SQL questions on joins, aggregates and WHERE versus HAVING, followed by an HR interview. Another reports an in-person pen-and-paper screen at roughly LeetCode-medium difficulty, with a strings question and a sorting variant. A later round for that candidate included two Python and three SQL questions.
The format varies. One candidate describes five rounds, including SQL, DBMS, a graph lowest-cost-path problem, a live scenario about ticket prioritization under urgent client demands, a manager round and a final HR discussion. AML and KYC reportedly came up in that process. Another reports a campus process with two in-person rounds: SQL and Python plus a situational SQL question, then behavioral questions on saying no to a colleague and resolving conflict. A third describes a HackerRank test at easy-to-medium difficulty and an assessment centre where both interviews returned to large datasets, data reliability and privacy. It ended with a hard system design question, and that candidate still received an offer.
Outcomes in these reports were mixed: three candidates received or accepted offers, while two reported no offer or a rejection. Prepare SQL joins, aggregation and clause choice, basic Python, and two or three detailed stories about data quality, pressure and teamwork. Be ready to talk through the resume projects you list. Some candidates also mention slow or uneven recruiter communication, so plan for waiting between stages.
Synthesized from 20 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Barclays process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Barclays
Select the 2nd highest salary in the engineering department
| Question | |
|---|---|
| Attribution Rules | |
| Find the Missing Number | |
| Bagging vs Boosting | |
| Sort Strings | |
| Compute Variance | |
| Prime Numbers Identification | |
| Digital Marketing Metrics | |
| Bias vs. Variance Tradeoff | |
| Data Preparation for Imbalanced Data | |
| Overfit Avoidance | |
| String Palindromes | |
| Blob Indexing | |
| Safe Deployments | |
| Why Do You Want to Work With Us | |
| Justify a Neural Network | |
| Your Strengths and Weaknesses | |
| A/B Test Power Size | |
| Dropbox Database | |
| Empty Neighborhoods | |
| Rolling Bank Transactions | |
| Employee Salaries | |
| Comments Histogram | |
| Closest SAT Scores | |
| Top Three Salaries | |
| Monthly Customer Report | |
| Slacking Employees Salaries | |
| Experiment Validity | |
| 500 Cards | |
| Compute Deviation |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report different entry points. One describes a CGPA-based screen, another an online assessment with five SQL questions plus multiple-choice, and another a HackerRank test with easy-to-medium LeetCode-style problems. Expect SQL fundamentals such as joins, aggregates and WHERE versus HAVING, and possibly basic DSA under time pressure.
A technical interview typically follows, and candidates report SQL as the main focus. One reports two Python and three SQL questions from two interviewers. Another reports SQL, DBMS, OOP and a graph problem. A third reports SQL, basic Python, a situational SQL question and a brief mention of Power BI. Be ready to explain your approach, not just write queries.
Some candidates describe a more applied stage. One was given a ticket-prioritization scenario involving urgent client issues. Another had an in-person assessment centre with two interviews about large datasets, data reliability and privacy, ending in a system design question. This stage may not appear in every process, so prepare concrete data-quality stories.
Candidates report manager-level rounds that lean behavioral: tell-me-about-a-time questions, production issues, stress, teamwork, conflict resolution and fast-paced work. In one report a hiring manager and director also asked a few basic SQL function questions. Prepare structured stories with clear outcomes.
Several candidates mention an HR conversation, either early or at the end. Topics reported include background, motivation for Barclays, availability, compensation and long-term commitment. Timing between stages may be slow, and some candidates describe communication delays.
