Data Analyst – Excel and Tableau Intern

Job Summary

EY is seeking a highly motivated and detail-oriented Data Analyst Intern with strong skills in Microsoft Excel and Tableau. This internship offers an incredible opportunity to gain real-world experience in data analytics, visualization, and business intelligence within one of the world’s leading professional services organizations. The ideal candidate will assist in gathering, processing, analyzing, and visualizing data to help drive strategic business decisions across multiple domains.

Key Responsibilities

  • Collect, clean, and organize data from various internal and external sources.
  • Use Excel to perform data analysis, create pivot tables, charts, and dashboards for reporting purposes.
  • Design and develop Tableau dashboards to visualize insights effectively and support data-driven decisions.
  • Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
  • Assist in preparing regular analytical reports and presentations for stakeholders.
  • Identify trends, patterns, and insights in complex datasets to support business objectives.
  • Ensure data accuracy, consistency, and completeness throughout the analysis process.
  • Support senior analysts and consultants in data modeling and predictive analytics initiatives.

Required Skills and Qualifications

  • Bachelor’s or Master’s degree in Data Analytics, Statistics, Computer Science, Information Systems, Economics, or related fields.
  • Proficiency in Microsoft Excel (advanced formulas, pivot tables, data validation, VLOOKUP, charts).
  • Hands-on experience with Tableau for data visualization and dashboard creation.
  • Basic understanding of SQL and database management concepts is an advantage.
  • Strong analytical, problem-solving, and critical-thinking abilities.
  • Excellent communication and presentation skills.
  • Attention to detail with a high degree of accuracy in data handling.
  • Ability to work independently and in a team-oriented environment.

Experience

  • Fresh graduates or students currently pursuing a degree in a related field are encouraged to apply.
  • Prior internship or coursework experience in data analytics, reporting, or business intelligence will be an added advantage.

Working Hours

  • Flexible working hours, typically Monday to Friday.
  • Option for remote or hybrid working, depending on project requirements.
  • Approximately 20–30 hours per week, based on academic schedule and internship duration.

Knowledge, Skills, and Abilities

  • Strong understanding of data analytics concepts and visualization principles.
  • Ability to handle large datasets and perform detailed quantitative analysis.
  • Knowledge of business metrics, KPIs, and performance dashboards.
  • Aptitude for learning new analytical tools and technologies quickly.
  • Team player with a proactive and collaborative work approach.

Benefits

  • Opportunity to gain hands-on experience at a globally recognized professional services firm.
  • Mentorship and guidance from experienced EY professionals in the analytics and consulting domains.
  • Access to training programs, workshops, and online learning platforms.
  • Certificate of Internship upon successful completion.
  • Potential for a full-time offer based on performance and organizational requirements.
  • Exposure to real-world business projects and client engagements.

Why Join EY

At EY, you will be part of a culture that encourages innovation, integrity, and inclusivity. You will work alongside talented professionals who are passionate about turning data into actionable insights. EY provides a supportive learning environment that helps you build analytical and professional skills essential for a successful career in data analytics. Joining EY means becoming part of a global network committed to building a better working world through technology and data-driven excellence.

How to Apply

Interested candidates can apply by submitting their updated resume and a cover letter highlighting relevant skills and experience through the EY Careers Portal or official recruitment email. Only shortlisted candidates will be contacted for the next steps in the selection process, which may include an Excel and Tableau assessment followed by an interview with the analytics team.

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...