DATA ANALYST INTERN (EXCEL, SQL, POWER BI)

Medi Nex Workforce; India; Remote; INR 142,000 - 170,000; Full time

Job summary

Medinex Workforce in India is offering a DATA ANALYST INTERN role focused on Excel, SQL and Power BI. This remote internship targets final-year students or fresh graduates who want hands-on experience with live recruitment data and reporting workflows.

You will clean data in Excel, write SQL queries, build Power BI dashboards, and generate weekly metrics. The program runs 1 to 3 months with a monthly stipend of up to INR 14,000.

Qualifications

• Good Excel skills (formulas, pivot tables, lookups, charts).
• Basic SQL (SELECT, JOIN, GROUP BY, filters).
• Basic familiarity with Power BI, Tableau or Looker Studio.

Responsibilities

• Clean exported files in Excel and remove duplicates, blanks and wrong entries.
• Write SQL queries to pull candidate, client and placement data.
• Build dashboards in Power BI for the recruitment and operations teams.
• Calculate weekly metrics such as submission rate, interview rate and joining rate.
• Compare this week with last week and explain what changed in simple words.
• Check every report against the source data before it goes to managers.
• Keep short notes on how each report is built so teammates can repeat it.
• Share progress in a short daily check-in and a weekly review.

Skills

Excel

SQL

Power BI

Tools

Tableau

Looker Studio

Job description

Job Title: DATA ANALYST INTERN (EXCEL, SQL, POWER BI)

Company: Medinex Workforce

Location: India

Workplace Type: Remote

Employment Type: Full-time internship

Duration: 1 to 3 months

Stipend: Up to INR 14,000 per month

Role at a glance

Every week Medinex Workforce asks the same kinds of questions. How many profiles did we submit? Which sourcing channel produced the most joiners? Which clients take the longest to close a role? Answers sit in spreadsheets and databases, and someone has to read them properly. This internship puts you in that seat. You will work with real recruitment data and learn how an analyst moves from a raw export to a clear recommendation.

What you will work on

• Clean exported files in Excel and remove duplicates, blanks and wrong entries
• Write SQL queries to pull candidate, client and placement data
• Build dashboards in Power BI for the recruitment and operations teams
• Calculate weekly metrics such as submission rate, interview rate and joining rate
• Compare this week with last week and explain what changed in simple words
• Check every report against the source data before it goes to managers
• Keep short notes on how each report is built so teammates can repeat it
• Share progress in a short daily check-in and a weekly review

What we expect from you

• Good Excel skills (formulas, pivot tables, lookups, charts)
• Basic SQL (SELECT, JOIN, GROUP BY, filters)
• Basic familiarity with Power BI, Tableau or Looker Studio, even from practice files
• Clear written English so your findings are easy to follow
• A careful habit of double-checking your work
• A laptop and stable internet connection

Helpful but not required

• Python with Pandas
• A practice dashboard, Kaggle notebook or college project
• Interest in recruitment or healthcare data

Who can apply

• Final-year students and recent graduates from any stream, including B.Tech, BCA, B.Sc, B.Com, BBA, MCA and MBA
• Self-taught learners who can show a project or certificate
• Freshers, with no prior experience needed
• Candidates who can work full-time for the internship period

What you gain

• Hands-on practice with live reporting tasks
• Regular feedback from experienced team members
• Dashboards and reports you can show in interviews
• Internship completion certificate
• The freedom to work from your own city anywhere in India

Work schedule

Full-time, Monday to Saturday or as assigned by your reporting manager.

Medinex Workforce is an equal opportunity employer. We welcome applicants of every gender, background and community.