Get Started
Hunting for you, 24x7Get the iPhone app

Your hunt runs in your pocket, and tells you the moment a strong match opens.

Download on theApp Store
InsightEdge Analytics IndiaPosted 12 days ago

Junior Data Analyst - Excel & SQL Reporting

Bengaluru, IndiaEntry levelOn-siteFull-time₹360,000 – ₹540,000 a year
Who we'd reach at InsightEdge Analytics IndiaFound and reached by Power Apply
Best leadHiring manager

Leads the team this role joins

Founder

Decides on early hires

Head of talent

Runs hiring at the company

Power Apply

From your own Gmail and LinkedIn.

How this role compares

One of 8 open Junior Data Analyst roles we are tracking today.

Posted 12 days ago, with 6 of the others posted since and 1 still open from before.

Counted across the roles Frontrunner has open right now.

About the role

InsightEdge Analytics India is hiring a full-time, on-site junior data analyst in Bengaluru for candidates with zero to two years of analytics experience, with fresh graduates welcome if they have strong projects. The role sits between transactional databases and business teams, pulling data, checking its integrity and producing recurring performance reports. You will work alongside senior BI consultants on client delivery for technology and retail clients.

What you’ll do

  • Write and test SQL queries that pull commercial data from relational databases.
  • Clean, transform and validate raw transactional data using Excel Power Query and SQL.
  • Build and maintain daily, weekly and monthly performance reports in Excel and Google Sheets.
  • Spot discrepancies, missing values and reporting anomalies, and work with data engineers to resolve them.
  • Create dynamic charts, heatmaps and executive summary tables for department managers.
  • Document data dictionaries, query logic and standard operating procedures.

What they’re looking for

  • Zero to two years of practical analytics experience, with fresh graduates welcome if they have strong project portfolios.
  • Solid SQL, including SELECT, inner and left joins, GROUP BY, HAVING, subqueries and aggregate functions.
  • Advanced Excel, including pivot tables, XLOOKUP, nested IFs and conditional formatting.
  • A degree in computer science, IT, statistics, mathematics, engineering or commerce (B.Tech, BCA, B.Sc or B.Com).
  • Based in Bengaluru or willing to relocate for full-time on-site work on standard day shifts.

Nice to have

  • Basic familiarity with Power BI, Tableau or Python.

What’s on offer

  • Annual CTC of INR 360,000 to 540,000, which is INR 30,000 to 45,000 per month.
  • Performance bonuses twice a year.
  • Employee Provident Fund, comprehensive medical insurance and subsidized office cafeteria meals.
  • A career path into Senior Data Analyst and BI Developer roles.
  • Full-time, on-site work on standard day shifts.

Skills

Questions about this role

What salary is offered?

The listing states INR 360,000 to 540,000 per year, or 30,000 to 45,000 per month.

Are freshers accepted?

Yes, the listing encourages enthusiastic freshers with strong project portfolios to apply.

Is the role on-site?

Yes, it is full-time on-site in Bengaluru, and candidates willing to relocate are considered.

Which databases will I work with?

The listing names PostgreSQL, MySQL and MS SQL Server.