Product Data Analyst

DailyRounds / Marrow; Alliance (OH); On-site; USD 9,423 - 13,611; Full time

Job summary

DailyRounds is seeking a Product Data Analyst in Bengaluru to partner with product, engineering, marketing and business teams to build trusted metrics and self-serve analytics, answering ad-hoc and recurring questions with efficient SQL on ClickHouse.

You will own KPI dashboards, translate stakeholder requests into scalable queries, and automate reporting while ensuring a single source of truth for key product metrics.

Qualifications

• 2-3 years of experience as a Product Analyst or Data Analyst in a product-driven environment.
• Strong SQL expertise with hands-on experience in CTEs, Window Functions, query optimization, and complex analytical queries.
• Experience working with columnar databases such as ClickHouse, BigQuery, Redshift, or similar.
• Hands-on experience building BI dashboards using Superset, Tableau, Power BI, or Looker (including RBAC configuration), with an understanding of product analytics concepts such as funnels, cohorts, retention, engagement, and feature adoption.

Responsibilities

• As a Product Data Analyst, you'll be the go-to data partner for our Product organization, collaborating with PMs, Engineers, Marketing, and Business teams to build trusted metrics and enable self-serve analytics.
• Be the primary point of contact for data requests across Product, Marketing, and Business teams, managing priorities and delivering timely insights.
• Write efficient, complex SQL queries on ClickHouse to answer both ad-hoc and recurring business questions.
• Translate stakeholder requests into scalable queries, dashboards, and self-serve analytics.
• Automate reporting and data workflows to improve efficiency and enable self-serve analytics.
• Present insights clearly to technical and non-technical stakeholders to enable data-driven decisions.
• Own KPI dashboards providing real-time views of product and business performance.

Skills

SQL

BI Dashboards

Data Analysis

Stakeholder Management

Tools

ClickHouse

BigQuery

Redshift

Superset

Tableau

Power BI

Looker

Job description

Product Data Analyst

Location: Bengaluru

Why do we exist?

Doctors need to constantly learn and keep themselves updated about the latest practices in their field. Case-based learning (clinical cases) is considered to be the best way to go about doing that. The traditional methods for case discussions are medical conferences and medical journals, but the cost and time doctors need to spend on these, often make it difficult. Also, on average, a medical doctor takes 30 key decisions per day which range from what drug to prescribe, when to do a surgery, what device to use, to when to discharge a patient.

Who are we?

DailyRounds is a healthcare startup focused on organizing "Knowledge of practice of Medicine" and building a community of Doctors (and healthcare professionals). We hold the largest IP (intellectual property) in clinical medicine in India. We hope to put this IP, network, and our best efforts to help Doctors improve how they diagnose and treat. We are a diverse team of 300 people based in Bangalore. We are product-driven. We believe businesses should scale and be profitable. We stay away from fads and focus on what makes business sense, what can scale, and what can make a positive impact (in that order). In April 2019 M3 India, the Indian subsidiary of Japanese Healthtech company M3 (one of the largest healthcare networks globally, listed on the Tokyo Stock Exchange), picked up a majority stake in DailyRounds to foray into case-based problem-solving, community platform and medical test preparation business in India.

What would you be doing here?

• As a Product Data Analyst, you'll be the go-to data partner for our Product organization. You'll collaborate closely with Product Managers, Engineers, Marketing, and Business teams to build trusted metrics, enable self-serve analytics, and uncover insights that drive product decisions.
• Be the primary point of contact for data requests across Product, Marketing, and Business teams, managing priorities and delivering timely insights.
• Write efficient, complex SQL queries on ClickHouse to answer both ad-hoc and recurring business questions.
• Translate ambiguous stakeholder requests into scalable queries, intuitive dashboards, and self-serve analytics.
• Automate reporting and data workflows to improve efficiency and enable self-serve analytics.
• Present insights clearly to both technical and non-technical stakeholders, enabling data-driven decisions.
• Own KPI dashboards that provide an accurate, real-time view of product and business performance.
• Maintain a single source of truth for key product metrics, ensuring consistency, reliability, and accuracy across teams.
• Set up scheduled reports, alerts, and role-based access (RBAC) so the right stakeholders have access to the right data at the right time.
• Partner with Product Managers to define success metrics and measure the impact of new features.
• Perform deep dives into user adoption, engagement, retention, cohorts, and conversion funnels to uncover meaningful insights.
• Identify trends, anomalies, and opportunities that influence product strategy and improve user experience.

The best-fit candidate would have:

• 2-3 years of experience as a Product Analyst or Data Analyst in a product-driven environment.
• Strong SQL expertise with hands-on experience in CTEs, Window Functions, query optimization, and complex analytical queries.
• Experience working with columnar databases such as ClickHouse, BigQuery, Redshift, or similar.
• Hands-on experience building BI dashboards using Superset, Tableau, Power BI, or Looker (including RBAC configuration), with a strong understanding of product analytics concepts such as funnels, cohorts, retention, engagement, and feature adoption.
• Experience working with event analytics platforms such as Mixpanel, CleverTap, or similar.
• Experience automating recurring reports and building scalable data workflows.
• Strong stakeholder management and communication skills, with the ability to influence decisions through clear, data-driven storytelling.
• A proactive, ownership-driven mindset with a passion for solving product problems through data.