Junior Data Analyst

Rezo; Dadri; On-site; INR 300,000 - 600,000; Full time

Job summary

Rezo is seeking a meticulous Data Analyst to transform raw data into actionable insights, supporting day-to-day operations and executive reporting. You will query relational databases, build dynamic dashboards in Power BI, and perform ad-hoc analyses to drive critical business decisions.

Responsibilities include writing optimized SQL queries, maintaining dashboards, validating data quality, and collaborating with teammates to translate business needs into technical solutions.

Qualifications

• 1–2 years of experience in data analytics or BI role.
• Proficiency in writing SQL queries with joins, aggregations, conditional logic, and subqueries.
• Experience building Power BI reports and managing data relationships.
• Advanced Excel skills including PivotTables, XLOOKUP, and Power Query.
• Strong problem-solving and attention to detail.

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 to track KPIs and operational metrics.
• Operational Analysis: analyze operational datasets to ensure accurate reporting and track usage trends.
• Ad-Hoc Analysis: perform quick, data-driven deep dives using advanced Excel tools.
• Data Quality Collaboration: validate data accuracy before publishing reports and translate business requirements into technical data solutions.

Skills

Problem-Solving

Data analysis

Tools

SQL

Power BI

Excel

Job description

Job Summary

Role Summary 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 and executive reporting. You will query relational databases, build dynamic dashboards, and perform ad-hoc analyses to answer critical business questions.

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 to track key performance indicators (KPIs) and operational metrics.
• Operational Analysis: Analyze operational datasets - including call logs, messaging interaction volumes - to ensure accurate reporting and track usage trends.
• Ad-Hoc Analysis: Conduct quick, data-driven deep dives using Advanced Excel (PivotTables, Power Query, complex formulas) to resolve immediate operational queries.
• Data Quality Collaboration: Validate data accuracy before publishing reports and collaborate with team members to translate business requirements into technical data solutions.

Requirements

• Experience: 1 to 2 years in a data analyst or business intelligence role (or freshers 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 data models, 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.

Job Type

Full time

Job Opening

Junior Data Analyst