Data Analyst

AFFORIS HEALTH TECHNOLOGIES; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

PlatinumRx is seeking a Data Analyst to join our on-site team in HSR Layout, Bengaluru, to turn operational and business data into decisions the company can act on.

You will write and optimize SQL queries, use Python (Pandas, NumX) for data wrangling, and build dashboards in Power BI or Looker Studio to support daily decisions. You’ll maintain advanced Excel workflows and automate recurring reporting with Apps Script or APIs, collaborating with a small, fast-moving team.

Qualifications

• 1–3 years of experience in a data analyst or similar analytics role.
• Strong SQL skills, comfortable writing and optimizing queries against large datasets.
• Working proficiency in Python for data wrangling (Pandas, NumX).
• Advanced Excel skills, including pivot tables, Power Query, and data visualization.
• Hands-on experience with at least one BI tool, Power BI, Metabase, Looker Studio, or Superset.
• Familiarity with Apps Script or API integrations for automation and also knowledge of Clickhouse.

Responsibilities

• Write and optimize SQL queries to extract and manipulate large datasets across our systems.
• Use Python (Pandas, NumX) for data wrangling, cleaning, and analysis that goes beyond what spreadsheets can handle.
• Build and maintain advanced Excel workflows, pivot tables, Power Query, and visualizations, for fast, ad hoc business requests.
• Build and maintain dashboards on a BI tool (Power BI, Metabase, Looker Studio, or Superset) that the business actually relies on day to day.
• Work with Apps Script or API integrations to automate recurring data pulls and reporting.

Skills

SQL

Python (Pandas)

Excel advanced

BI tools

APIs integration

ClickHouse

Tools

Power BI

Metabase

Looker Studio

Superset

Job description

PlatinumRx is on a mission to make chronic medications affordable for every Indian household. Through a unique model built around high-quality generic substitution, we deliver meaningful savings without compromising on care. We are Series A+ funded, growing at a rapid pace, with industry-leading CAC and retention metrics.

Role Overview

PlatinumRx is a health-tech startup helping chronic patients access branded medicine substitutes at a fraction of the usual cost. We're a small team, which means the work is real and the impact of what you build is visible almost immediately. We're looking for a Data Analyst to join us on-site in HSR Layout, Bengaluru, someone who can turn our operational and business data into decisions the rest of the company can act on.

Key Responsibilities :

• Write and optimize SQL queries to extract and manipulate large datasets across our systems.
• Use Python (Pandas, NumX) for data wrangling, cleaning, and analysis that goes beyond what spreadsheets can handle.
• Build and maintain advanced Excel workflows, pivot tables, Power Query, and visualizations, for fast, ad hoc business requests.
• Build and maintain dashboards on a BI tool (Power BI, Metabase, Looker Studio, or Superset) that the business actually relies on day to day.
• Work with Apps Script or API integrations to automate recurring data pulls and reporting.

What we are looking for:

• 1-3 years of experience in a data analyst or similar analytics role.
• Strong SQL skills, comfortable writing and optimizing queries against large datasets.
• Working proficiency in Python for data wrangling (Pandas, NumX.).
• Advanced Excel skills, including pivot tables, Power Query, and data visualization.
• Hands-on experience with at least one BI tool, Power BI, Metabase, Looker Studio, or Superset.
• Familiarity with Apps Script or API integrations for automation and also knowledge of Clickhouse.

Bonus Points:

• Familiarity with any RDBMS.
• Exposure to ETL pipelines or experimentation/A-B testing.