Founder & CTO @Preplaced
Get great tips for the Accenture interview process & preparation! Connect 1:1 with a mentor at Preplaced and become an Accenture data analyst. Learn more.
Most companies and major businesses in all industries now rely on using data to make key business decisions.
These companies are therefore on a hiring spree.
As per our estimates, data analyst job/internship has become one of the top career choices in 2023 alone!
The average annual salary of a data analyst ranges from Rs.5.3 lakhs (for fresher) to Rs.8.2 Lakhs (for senior analysts).
Glassdoor reports that the national average salary for a Data Analyst is Rs.5 Lakhs.
So, wouldn’t it be nice to land your dream job as a Data Analyst in one of the big companies?
That is where we are going to help you :)
Recently, we reached out to Akash Dongre, a prior Senior Data Analyst at Accenture.
In our discussion, he shared some valuable insights into what a Data Analyst does.
He also explained the Accenture interview process for Data Analyst and how to prepare for Data Analyst Accenture interview.
He concluded by providing some key tips and suggestions for job seekers to follow.
So, let’s get to it.
Data Analysts, to put it simply, make sense of raw data and help in making them presentable in a way that they can be used to make data-driven decisions.
This role requires the amalgamation of advanced technical, logical, and leadership skills.
According to Akash, a typical data analyst role at any company involves:
👉 Designing and maintaining data systems and databases.
👉 Capturing data with ETL tools.
👉 Interpretation of data sets using statistical tools, finding out patterns and trends for predictive analytics efforts.
👉 Making use of SaaS, Python, and R programming to mine relevant data from primary and secondary resources.
👉 Making use of Data Visualisation tools like Spotfire, Tableau and Power BI to present data in a comprehensible way.
Akash explains that the prerequisites for Data Analyst roles differ from company to company.
Anyone pursuing a degree in Data Analytics or passing out from other disciplines must possess some rudimentary training of a few programming languages, data mining tools, and testing systems.
He further adds that a typical Data Analyst role requires a candidate to have:
☑️ Bachelor's Degree in a quantitative discipline (Economics, Engineering, Computer Science, Math, Statistics).
☑️ 1-2 years experience in analytics or management consulting.
☑️ Proficiency in using SQL and querying relational databases.
☑️ Experience in at least one statistical programming language (SAS, R, Python)
☑️ Experience in at least one data visualisation tool.
☑️ Experience with project management.
☑️ Knowledge of spreadsheet tools like Google Sheets and Excel.
Akash explains that the Data Analyst Accenture interviews consist of three rounds provided, it is not a project-specific hiring or managerial acquisition.
The main three rounds (along with the resume sorting round) are:
Your resume and cover letter land right in the hands of the recruiter who then matches the said resume with the posted job description and matches the prerequisites with the candidate’s qualifications.
If your resume fits the role, you will be scheduled for an initial screening interview and the Accenture team will directly contact you.
If the resume was not the right fit, you will be notified by email directly.
The Accenture Recruitment team keeps your details for any future opportunities at the company.
One of the Senior Recruitment Specialists at Accenture Toronto has clarified about-What happens to a resume after you click “Submit”
🔹 Relevant work experience i.e. experience (ideally 1-2 years) that corresponds with the role you have applied for
🔹 Number of projects you have managed or been a part of previously
🔹 Statistical Knowledge (helps to have a strong stats-maths background)
🔹 Proficiency in SQL, R and Python
🔹 Whether the resume is concise and to the point
🔹 Educational Background (helps to be from STEM background)
Check out these this Ultimate Resume Writing Guide with Do's and Dont's
This round comprises three different sections in the form of analytical aptitude, verbal ability, and attention to detail.
Akash adds that each candidate gets 55 questions to answer in 60 minutes.
These questions test your command of English, logical reasoning, and analytical aspects to the fullest.
Candidates clearing this round proceed to the second round- The Technical Interview.
According to Akash, there is no fixed pattern as to which questions can be asked by the panel.
You will be questioned about each of the hard skills mentioned in your resume along with a few puzzles.
The technical aspects will also be tested with a few functional problems like performing a Bubble sort, Binary Search, or an Insertion Sort.
Candidates with CS educational background will be expected to write codes during the interview.
The line of questions in this round is mostly based on key programming concepts for C++, Java, Python, and SQL.
Therefore, you should be prepared with Data Structures and Algorithms, Operating Systems, and a programming language of your choice.
Candidates who can back their skills and answer most of the tricky puzzle questions with aplomb proceed to the next round.
Also Read: Top 9 Skills for Aspiring Data Analysts
In this round, your soft skills will be assessed by the interviewers.
They will ask you questions about your current company and role (if any) or will ask you to say something about yourself (the usual “Tell me about yourself” prompt).
This is the round where you will need to explain your experience at the previous company and why you want to join Accenture.
The key tip here is to describe projects in a descriptive manner highlighting your role in the smooth completion of the same.
Basically, in this round, the panel will delve deep into your resume so, it is important to be able to back everything you have added there.
For a fresher, it helps to have a few internships and projects under your belt before you apply for a job at Accenture.
Then, this round becomes much more about your projects and your industry know-how and level of expertise in the programming languages.
Here are some of the common questions asked at Accenture:
✪ Tell me about yourself
✪ Why Accenture?
✪ How do you see yourself five years from now?
✪ What are your strengths and weaknesses?
✪ Questions from resume- regarding hard skills and portfolio
✪ Questions from Internship/prior projects
Though some mistakes are usually trivial nature, they can have a lasting impression on the recruiter.
Some of these mistakes listed below can give you a better idea of what exactly not to do :)
Akash explains that many candidates often list projects and skills in languages like CSS, HTML, and testing systems that are not considered relevant to an interviewer for a Data Analyst role.
Despite the importance of the aforementioned technologies in the market, the world of data analytics demands proficiency in R Programming, Python, and SQL and, projects involving the use of the same as well.
Many candidates end up listing many programming languages and other hard skills just to get to the interview round.
Some candidates also list AI and Machine Learning to leverage the boom of the said technologies, to land the interview.
This doesn’t work because, in the technical round of the interview, each candidate is bombarded with tricky questions about each technology or language they have listed.
So, at one point during the interview, your frailties will catch up to you.
In many Data Analyst Accenture interviews, the candidates know what an “element” in a programming language like R does but, they can’t explain the correct definition and the work done by an “element”.
In most cases, candidates actually know the answer but they are not able to communicate the thought process behind it, properly.
This is due to either a lack of clarity in your concepts or a lack of practice before the interview.
Either way, going over your materials for data analyst interviews should help.
Upskilling with a few additional courses should also help you learn new languages and technologies with ease.
Checkout this guide on Ace Your Communication Skills for Technical Interviews: 7 Steps
With virtual hiring, a 4-5 pages-long resume doesn’t work as there are many submissions to Accenture from all over the country.
A clean and concise resume is the way to go.
There you should be listing all of the hard skills you possess that match the job description and its requirements.
Moreover, you need to keep working on improving your cover letters all the time.
Akash explains that nowadays, many services offer industry-specific practice interviews or mock interviews as known in common parlance.
The mentors you choose for the mock interview sessions will bombard you with all the questions that will be asked in your actual Data Analyst interviews.
Moreover, in these sorts of interviews, real interview challenges and rounds will be simulated by the people who have gone through the same and are now employed as a Data Analyst at your dream company.
Before mock interviews, candidates used to prepare the top questions but ended up getting confused during the actual interview.
In a comprehensive research by Macrothink Institute, there was a severe lack of confidence reported in interview candidates.
Giving mock interviews regularly can help solve this problem.
🔹 You should be able to read and understand data on your own
🔹 You should know what exactly a data analyst role entails
🔹 Master SQL and a few programming languages as much as you can
🔹 You should attain proficiency in data mining and visualisation tools
🔹 Develop lots of projects
🔹 Keep learning and keep yourself updated with the latest trends in Data Analytics
🔹 Upskill by learning new programming languages all the time
The Accenture interview process takes up to 2-4 weeks.
It includes several rounds, such as verbal ability, technical interviews, and HR discussions.
The duration can vary depending on the role and location.
The difficulty of an Accenture interview depends on your background, experience, and the role you're applying for.
Data analyst interviews may involve technical questions and data analysis scenarios, so it's essential to prepare and showcase your skills and knowledge.
The HR interview at Accenture usually lasts about 30 minutes to an hour.
It focuses on assessing your cultural fit, behavioural competencies, and your motivation to work at Accenture.
It's crucial to be concise and clear in your responses.
Common data analyst interview questions at Accenture include:
📍Research the company: Understand Accenture's core values, services, and recent projects.
📍Tailor your resume: Highlight your skills and experiences related to data analysis.
📍Practise your technical skills: Be prepared to answer questions about data analysis tools and methodologies.
📍Use the STAR method: When answering behavioural questions, structure your responses with Situation, Task, Action, and Result.
📍Be ready for case studies: You might be given a data analysis scenario to solve during the interview.
📍Ask questions: At the end of the interview, have a few thoughtful questions to ask the interviewer about the role or the company.
And, always remember...
Akash has been working at Sandisk since the start of 2021 as a Senior Analyst.
He completed his graduation from SVCE Indore in 2015.
He started his work life as a Data Reporting Analyst for IQVIA (formerly Qunitiles and IMS health) and worked there for more than 2 years.
He then joined Tata Consultancy Service (TCS) in the same designation and worked there for 2 & a half years.
At TCS he was a part of multiple projects and gained expertise in Tibco Spotfire, Python and Tableau.
He has been eager to make use of his 5 years of experience in this field to mentor young Data Analysts to land their dream jobs.
You can also Connect with him 1:1 and have him as your success mentor and become an Accenture Data Analyst.