Barclays Data Analyst candidates report SQL assessments, practical technical discussions, and behavioral interviews that probe projects, communication, and banking context.
$105K
Avg. Base Comp
$120K
Avg. Total Comp
3 rounds
Typical Rounds
2-4 weeks
Process Length
Barclays Data Analyst interview preparation should center on timed SQL reasoning and clear project storytelling. One candidate described an online assessment with five SQL questions and multiple-choice questions, emphasizing joins, aggregates, and the distinction between WHERE and HAVING. Another described a pen-and-paper SQL and data-structures-and-algorithms screen, followed by a technical discussion containing Python and SQL questions. That account explicitly reported an initial screening followed by three rounds, so treat it as one candidate’s path rather than a universal round count.
Behavioral preparation also matters in the available reports. A final conversation was described as largely behavioral, covering projects, production issues, teamwork, and fast-paced work, with a few basic SQL-function questions. A separate account described a phone stage on motivation, work eligibility, and commuting, then later competency discussions about statistics, skewness and bias, time-series work, leadership, stress, and difficult situations. It also included banking-oriented discussion such as DCF and valuation multiples.
Build concise examples that connect your own analysis to a decision, technical choice, or outcome. For SQL, practice producing complete queries under time pressure rather than only naming concepts. Evidence is limited and the reported paths differ, so expect the emphasis to vary by team and role.
Synthesized from 4 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.
The SQL screening was the main thing to prepare for. My process began with an online assessment containing five SQL questions plus multiple-choice questions on core subjects. The SQL portion focused on fairly standard, medium-level work: writing queries with joins, aggregates, and clauses such as WHERE and HAVING.
After clearing the assessment, I had an HR interview. It was straightforward and included the usual “tell me about yourself” question. The overall process did not feel unusually difficult, but the SQL questions required comfort applying basic concepts rather than just recognizing definitions. I ultimately did not receive an offer. My biggest takeaway is to be ready to explain your background clearly while practicing SQL joins, aggregation logic, and when to use WHERE versus HAVING under assessment-style time pressure.
Prep tip from this candidate
Practice medium SQL queries using joins and aggregates, especially deciding between WHERE and HAVING, and prepare a concise answer for “tell me about yourself” tied to your resume and projects.
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 | |
| Safe Deployments | |
| Blob Indexing | |
| 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 | |
| Compute Deviation | |
| Subscription Overlap |
Synthesized from candidate reports. Individual experiences may vary.
Candidates report either an online assessment or an initial screening. One online assessment included five SQL questions plus multiple-choice questions; another report described an initial screen based on CGPA. A separate phone stage covered motivation, commuting availability, and work authorization.
One candidate reported an in-person pen-and-paper DSA and SQL screen with a strings problem and a sorting variant. That same account later included Python and SQL questions, while another candidate was asked about statistics, skewness and bias, and a time-series project.
Candidates report behavioral discussions on projects, teamwork, production issues, leadership, stress, and difficult situations. One final conversation with a hiring manager and director mixed these prompts with basic SQL functions; another account also described banking questions such as DCF and valuation multiples.
