Senior Data Analyst - CSA

PivotRoots; Mumbai; On-site; INR 600,000 - 800,000; Full time

Job summary

PivotRoots in Mumbai is seeking a Data Analyst to take ownership of end-to-end analysis workflows, ensuring data accuracy and delivering insights through polished Power BI dashboards.

The ideal candidate has over 3 years of experience in data roles, strong SQL skills, and is adept at translating business questions into structured analytical frameworks. We are committed to equal opportunities for all employees.

Qualifications

• 3+ years of hands-on experience in a data or analytics role.
• Strong SQL proficiency across any platform.
• 3+ years of experience building dashboards in Power BI.

Responsibilities

• Own end-to-end analysis workflows and insight delivery.
• Write optimized SQL queries for segmentation and analysis.
• Build and enhance Power BI dashboards for reporting.

Skills

SQL proficiency

Power BI dashboard development

Analytical mindset

Problem-solving skills

Communication skills

Tools

Python

CLM tools (Moengage)

Job description

Responsibilities

• Own end-to-end analysis workflows — from data extraction and transformation to insight delivery
• Write clean, optimized SQL queries for segmentation, funnel analysis, and custom business logic
• Build, maintain, and enhance Power BI dashboards for client-facing and internal reporting
• Translate ambiguous business questions into structured analytical frameworks
• Collaborate with client stakeholders to understand reporting needs and iterate on solutions
• Ensure data accuracy, governance, and documentation across all deliverables
• Present findings clearly to both technical and non-technical audiences

Required Skills & Qualifications

• 3+ years of hands‑on experience in a data or analytics role
• Strong SQL proficiency across any platform (T‑SQL, Big Query, MySQL, PostgreSQL, Snowflake, etc.) — including complex joins, CTEs, window functions, and custom segmentation logic
• 3+ years of experience building dashboards and reports in Power BI — including DAX, data modelling, and visual design
• Strong analytical mindset with the ability to frame problems, identify patterns, and extract meaningful insights
• Excellent problem‑solving skills and comfort working with large, messy datasets
• Clear communication skills — able to explain findings and logic to business stakeholders

Good to Have

• Python knowledge (pandas, NumPy, or basic scripting for automation) — added advantage
• Familiarity with CLM tools (Moengage), marketing or digital analytics data sources (GA4, etc.)

Contract Type: Permanent

Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.