Data Analyst

Overview

Detail-oriented Data Analyst role focused on analyzing large datasets, generating reports and supporting business teams with data insights.

What you'll do

• 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.

What you'll need

• Microsoft Excel: expertise required in advanced Excel formulas and functions, including VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIF and COUNTIF.
• 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.

Nice to have

• 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.

Details

• Location: Royapettah, Tamil Nadu, India.