Data Analyst

Unique Enterprises; Mumbai; On-site; INR 200,000 - 320,000; Full time

Job summary

Unique Enterprises is seeking a data governance and analytics-focused professional to manage workforce data from vendors, validate rules, and handle bulk uploads. The role emphasizes accuracy, dashboarding, and reporting using Excel and Power BI.

You will track KYC transactions, ensure data quality, and contribute to MIS for informed decision-making. Strong analytical skills and attention to detail are essential for success.

Qualifications

• Expertise in Excel advanced features, formulas, and data models.
• Experience with VLOOKUP/XLOOKUP, Pivot Tables and Power Query for data preparation.
• Ability to build dashboards and perform data visualization in Power BI.
• Proficiency in SQL for data extraction and validation, with good query writing.
• Strong attention to detail and analytical problem-solving skills.

Responsibilities

• Collect workforce data from vendors in prescribed formats.
• Validate data against predefined business rules.
• Manage bulk uploads & data templates.
• Track KYC transactions: pending, successful, rejected, failed.
• Prepare reporting & MIS for management.
• Ensure data quality & governance across datasets.

Skills

Advanced MS Excel

VLOOKUP/XLOOKUP

Pivot Tables

Power Query

SQL

Power BI

Attention to detail

Analytical skills

Problem-solving

Job description

Job Responsibilities

• Collect workforce data from vendors in prescribed formats
• Validate data against predefined business rules
• Manage bulk uploads & data templates
• Track pending, successful, rejected, and failed KYC transactions
• Reporting & MIS
• Data Quality & Governance

Required Candidate profile

• Advanced MS Excel
• VLOOKUP/XLOOKUP, Pivot Tables, Power Query preferred
• Basic SQL preferred
• Dashboarding/Power BI preferred
• Strong attention to detail
• Good analytical and problem-solving skills