Junior Data Analyst

Rezo.ai.; Dadri; On-site; INR 400,000 - 600,000; Full time

Job summary

Rezo.ai is seeking a detail-oriented Data Analyst to transform raw data into actionable insights, support day-to-day data operations, and provide clear executive reporting. You will query relational databases, build dynamic dashboards in Power BI, and perform ad-hoc analyses to answer critical business questions.

The role emphasizes data quality, collaboration, and translating business requirements into technical data solutions.

Qualifications

• 1–2 years of experience in data analytics or BI roles.
• Strong SQL with joins, aggregations, window functions.
• Hands-on Power BI reporting and data modelling.
• Advanced Excel skills including XLOOKUP, PivotTables.
• Strong analytical mindset and attention to detail.

Responsibilities

• Write and optimize SQL queries to extract, clean, and aggregate data.
• Design and maintain Power BI dashboards for KPIs.
• Analyze operational data such as call logs and usage trends.
• Validate data quality and translate business needs into data solutions.

Skills

SQL

Power BI

Excel

Problem-solving

Tools

Power BI

Job description

We are seeking a detail-oriented Data Analyst to join our team. In this role, you will transform raw data into actionable insights, supporting day-to-day data operations andexecutive reporting. You will query relational databases, build dynamic dashboards, andperform ad-hoc analyses to answer critical business questions.

Key Responsibilities

• Database Management & SQL: Write, run, and optimize SQL queries to extract,aggregate, and clean data from relational databases.
• Dashboarding & BI: Design and maintain interactive Power BI dashboards totrack key performance indicators (KPIs) and operational metrics.
• Operational Analysis: Analyze operational datasets - including call logs,messaging interaction volumes - to ensure accurate reporting and track usagetrends.
• Data Quality & Collaboration: Validate data accuracy before publishing reportsand collaborate with team members to translate business requirements intotechnical data solutions.

Requirements

Required Skills & Qualifications

• Experience: 1 to 2 years in a data analyst or business intelligence role (orfreshers with strong technical project).
• SQL: Proficiency in writing queries using joins, aggregations, conditional logic,and subqueries/window functions.
• Power BI: Hands-on experience building reports, managing relationships in datamodels, and writing basic DAX measures.
• Excel: Advanced proficiency in Excel (XLOOKUP/INDEX MATCH, PivotTables,formatting, data manipulation).
• Problem-Solving: Strong analytical mindset with a high attention to detail.