Agency :
PivotRootsJob Description :
We are looking for a sharp, hands-on Senior Analyst to join our growing analytics team embedded at a client office in Bangalore. You will work at the intersection of data, insight, and storytelling — turning raw data into business decisions through rigorous analysis and compelling visualizations.- 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
Core Requirements
- 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.
Contract Type :
PermanentHere 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.
Skills Required
- 3+ years of hands-on experience in a data or analytics role
- Strong SQL proficiency (T-SQL, BigQuery, MySQL, PostgreSQL, Snowflake) including complex joins, CTEs, window functions, and segmentation logic
- 3+ years building dashboards and reports in Power BI including DAX, data modelling, and visual design
- Strong analytical mindset; ability to frame problems, identify patterns, and extract insights from large, messy datasets
- Excellent problem-solving skills and attention to data accuracy, governance, and documentation
- Clear communication skills; able to present findings to technical and non-technical stakeholders
- Python knowledge (pandas, NumPy, or basic scripting for automation)
- Familiarity with CLM tools (Moengage) and marketing/digital analytics data sources (GA4)
What We Do
Fearless. Fast. Smart. Focused. We are on a relentless quest to be Chicago's most creative company by reinvigorating iconic American brands through cultural relevance. We are passionate makers, digital disruptors, artists who don't color inside the lines. We work smarter. Push harder. Break things. Make things. And we're always looking forward.
Why Work With Us
Our agency gets out of bed in the morning to undertake what we call 'meaningful disruption' in an industry that is in need of serious transformation. We are not looking for the same, boring solutions that are chock-full of brand and marketing rhetoric but seek people that want to change the advertising game.
