Junior Data Analyst

Advertising, subscriptions and transaction fees each bring in a significant share of revenue. Traffic during holiday peaks can reach ten times normal levels, and the platform is built for it.

Role overview

We need a Junior Data Analyst. This is a contract position based in Ahmedabad, Gujarat. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. Hybrid. You will need to be in Ahmedabad at least two days per week.

Responsibilities

• Investigate data quality issues and work with data engineering to fix them at the source.
• Prepare weekly and monthly KPI reports for department leads.
• Write SQL queries against the data warehouse to pull and join data for analysis.
• Field ad hoc requests through a ticket queue and prioritise them with your manager.
• Create forecasts and simple models in Excel or Google Sheets.
• Define metric logic with stakeholders and document it.
• Support A/B test readouts with basic statistical checks.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.

Minimum qualifications

• 1+ years of experience in a data or reporting analyst role.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Habit of checking your own numbers before anyone else sees them.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Clear written and verbal communication with non-technical stakeholders.
• Experience with at least one BI tool such as Tableau, Power BI or Looker.
• Basic statistics: averages vs. medians, distributions, significance.

Preferred qualifications

• Industry background in retail, healthcare or logistics.
• Dbt or Snowflake.
• Python (pandas) or R for analysis.
• Google Analytics 4 or Adobe Analytics.

₹6.5-8.5 LPA

What you get

• Flexible hours.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Cliffcast Apps.