Pnc Data and Business Analytics interview typically runs 2 rounds: initial interview, then follow-up interview. The process took about 2 interviews and was experience-focused.
$84K
Avg. Base Comp
$115K
Avg. Total Comp
2
Typical Rounds
1-2 weeks
Process Length
Our candidates report that PNC’s Data and Business Analytics interviews lean heavily on whether you can turn a vague business goal into measurable progress. The recurring theme is not technical trickery, but ownership under ambiguity: one candidate described being tested on how they handle an end goal without much direction, with the interviewer probing the actions they would take and the metrics they’d watch. That tells us PNC is looking for analysts who can operate like problem-solvers, not just task executors.
We also see a strong emphasis on motivation and fit for the move itself. Multiple questions centered on why the candidate wanted to leave their current role and what they expected from future roles, which suggests the team is listening for a coherent career story rather than a rehearsed pitch. In practice, that means candidates who can connect past work to the kind of business impact PNC needs tend to land better than those who speak only in job titles and responsibilities.
The lone behavioral question we saw — strengths and weaknesses — fits the same pattern: they want self-awareness, but in a way that ties back to execution. The best responses in this process are concrete, metric-aware, and grounded in real examples. If we had to name the hidden bar here, it’s this: can you show that you’ll make good decisions when the path is unclear, and can you explain how you know those decisions worked?
Synthesized from 1 candidate report by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Pnc process.
They asked me about my past experience, why I decided to move forward, and what automation experience I had in the past. They also asked how Power BI reports are made and asked certain SQL questions. This was the first round of the interview, and one of the surprise questions was asking about the business insight I have into WMT.
Questions asked: Since this was the first round, I didn't get too far into the questions.
Table: Orders +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | customerId | int | +-------------+------+ id is the primary key (column with unique values) for this table. customerId is a foreign key (reference columns) of the ID from the Customers table. Each row of this table indicates the ID of an order and the ID of the customer who ordered it.
Write a solution to find all customers who never order anything.
Return the result table in any order.
Example 1: Input: Customers table: +----+-------+ | id | name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Orders table: +----+------------+ | id | customerId | +----+------------+ | 1 | 3 | | 2 | 1 | +----+------------+ Output: +-----------+ | Customers | +-----------+ | Henry | | Max | +-----------+
This was one of the SQL questions asked. The second one:
Write a solution to find the daily active user count for a period of 30 days ending 2019-07-27 inclusively. A user was active on a given day if they made at least one activity that day.
Return the result table in any order.
Note: Any activity from ('open_session', 'end_session', 'scroll_down', 'send_message') is considered valid activity for a user to be considered active on a day.
Example 1: Input: Activity table: +---------+------------+---------------+---------------+ | user_id | session_id | activity_date | activity_type | +---------+------------+---------------+---------------+ | 1 | 1 | 2019-07-20 | open_session | | 1 | 1 | 2019-07-20 | scroll_down | | 1 | 1 | 2019-07-20 | end_session | | 2 | 4 | 2019-07-20 | open_session | | 2 | 4 | 2019-07-21 | send_message | | 2 | 4 | 2019-07-21 | end_session | | 3 | 2 | 2019-07-21 | open_session | | 3 | 2 | 2019-07-21 | send_message | | 3 | 2 | 2019-07-21 | end_session | | 4 | 3 | 2019-06-25 | open_session | | 4 | 3 | 2019-06-25 | end_session | +---------+------------+---------------+---------------+ Output: +------------+--------------+ | day | active_users | +------------+--------------+ | 2019-07-20 | 2 | | 2019-07-21 | 2 | +------------+--------------+ Explanation: Note that we do not care about days with zero active users.
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 Pnc
Write a query that returns all neighborhoods that have 0 users.
| Question | |
|---|---|
| Hurdles In Data Projects | |
| Your Strengths and Weaknesses | |
| 2nd Highest Salary | |
| Cumulative Distribution | |
| Rolling Bank Transactions | |
| 500 Cards | |
| Find the Missing Number | |
| Bagging vs Boosting | |
| Employee Salaries | |
| Subscription Overlap | |
| Button AB Test | |
| Prime to N | |
| Comments Histogram | |
| Closest SAT Scores | |
| Size of Joins | |
| Google Maps Improvement | |
| P-value to a Layman | |
| Total Spent on Products | |
| Top Three Salaries | |
| Monthly Customer Report | |
| Paired Products | |
| Top 3 Users | |
| Third Purchase | |
| Slacking Employees Salaries | |
| Experiment Validity | |
| New Partner Card | |
| Minimum Change | |
| Over 100 Dollars | |
| Recurring Character |
Synthesized from candidate reports. Individual experiences may vary.
The first conversation appears to be a general screening focused on your background and motivation for the move. Candidates are asked about past experience, why they want to leave their current role, and what they expect in future roles.
A second interview goes deeper into how you approach business problems with limited direction. The discussion centers on how you would handle an end goal for a project, what metrics you would focus on, and how you think through the steps needed to get there.
Close preparation with examples that show ownership, communication, and how you work with cross-functional partners or technical peers. The available candidate evidence is sparse, so this stage is framed as a practical preparation bucket rather than a claim that every candidate saw a separate formal round. Where the source evidence blended final steps together, this stage captures the final evaluation themes without adding unsupported company-specific claims.
