₹11L – ₹25L a year estimatetypical for IT Jobs in India, 852 posts
Posted 1 year ago Last checked 1 hr ago
Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
You will
The candidate should have the ability to work with large datasets, perform data analysis, generate reports, and support business teams with…
Extract, analyze, and interpret data from databases and Excel files.
Develop and maintain operational and management reports.
Must-have skills
Data Structures & AlgorithmsMS ExcelMySQLPivot TablesReconciliationSQL
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Royapettah, Tamil Nadu, India Department: Data
Job Opening – Data Analyst
Department: Data & Analytics
Role: Data Analyst
Job Overview
We are looking for a detail-oriented Data Analyst with strong Excel skills and basic to intermediate knowledge of MySQL. The candidate should have the ability to work with large datasets, perform data analysis, generate reports, and support business teams with meaningful data insights.
Required Skills
Microsoft Excel – Expertise required
Advanced Excel formulas and functions.
VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, etc.
Pivot Tables and Pivot Charts.
Data cleaning, validation, formatting, and reconciliation.
Working with large datasets and preparing MIS reports.
Conditional formatting and basic Excel automation.
MySQL – Basic to Intermediate
Knowledge of SQL queries and database concepts.
SELECT, WHERE, GROUP BY, ORDER BY, JOINs, and aggregate functions.
Ability to write queries to extract and analyze data.
Understanding of table relationships and data structures.
Key Responsibilities
Extract, analyze, and interpret data from databases and Excel files.
Develop and maintain operational and management reports.
Perform data validation and reconciliation across multiple data sources.
Identify data discrepancies and support root-cause analysis.
Maintain accuracy and consistency across reports and datasets.
Support automation and process improvements in reporting activities.
Preferred Skills
Basic knowledge of SIGMA computing, Snowflake, Power BI, Tableau, or any BI reporting tool.
Exposure to healthcare or revenue cycle management (RCM) data is an advantage.
Basic understanding of data visualization and reporting concepts.
Key skills
Required
Data Structures & AlgorithmsMS ExcelMySQLPivot TablesReconciliationSQL
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
