Consumer Data Analyst

Analytics | India | 100% Remote | Full-Time | 2+ Years Experience

Core Hours: EST: 4:00 AM to 1:00 PM | IST: 2:30 PM to 11:30 PM

Apply here: https://forms.gle/eVTon1ooempK1WHcA

About Acadia

Acadia is a modern digital agency obsessed with client growth. Named Ad Age's Performance Marketing Agency of the Year (2024) and one of Ad Age's Best Places to Work (2025), we combine technology, digital media, and analytics to help consumer brands grow. Our capabilities span Retail Media, Analytics & BI, Paid Media, SEO, CRO, and Social. We work by four values: Candor, Community, Can-Do, and Curiosity.

The Role

We're looking for a Consumer Data Analyst to turn complex consumer data into answers that shape real business decisions. You'll work with national consumer brands on questions like what is driving growth, where customers are changing, which markets are performing, and whether marketing is actually working. You'll own the analysis end to end: find the data → write the SQL → investigate → validate → tell the story.

This is a hands-on role. You'll work directly with large, imperfect datasets across sales, customers, media, and markets, and you'll be expected to question the numbers, spot what others miss, and improve how we work. AI is a core part of the role. We want someone who has already used tools like Claude, ChatGPT, Copilot, or Claude Code to build something useful, automate work, write code, or solve a real problem. You don't need to be an AI engineer. You do need to know how to experiment, validate the output, and turn useful ideas into working solutions.

You'll work with senior analysts and strategists across India, the US, and Brazil, with regular mentorship and exposure to sophisticated analytics problems.

What You Will Do

• Own analysis end to end: Turn business questions into data-driven answers.
• Write strong SQL: Query, join, optimize, debug, and document large datasets in Snowflake and BigQuery.
• Build with AI: Automate recurring work, write and review code, QA analysis, and build useful workflows or tools.
• Support measurement: Contribute to marketing measurement, market analysis, incrementality testing, and modelling.
• Find the story: Go beyond what changed to understand why and what it means.
• Communicate clearly: Turn analysis into concise PowerPoint and Google Slides narratives.
• Raise issues early: Spot data problems, anomalies, and analytical risks before they become problems.
• Work across teams: Partner with Strategy, Account Management, Data Engineering, and Data Science globally.

What We Are Looking For

• Must-have
• 2-5 years of hands-on analytics experience, ideally in agency, consulting, consumer, retail, e-commerce, or technology.
• Strong SQL: Joins, CTEs, window functions, debugging, and large datasets. Snowflake or BigQuery preferred.
• Hands-on AI experience: You've built or automated something using an AI tool and can explain how you validated it.
• Sound analytical thinking: You understand distributions, correlation vs. causation, significance, and signal vs. noise.
• Strong Excel skills and high attention to detail.
• Clear English communication and the ability to work independently.
• Curiosity to understand why the numbers changed, not just report what changed.

Good to have

• Python / pandas.
• Marketing measurement, MMM, geo or A/B testing, incrementality, or regression.
• Consumer or marketing metrics such as ROAS, CPA, conversion, AOV, retention, or LTV.
• Claude Code, Cursor, Copilot, or similar AI coding tools.
• Tableau, Power BI, Looker, or ThoughtSpot.
• You Will Thrive Here If You
• Take ownership instead of waiting for instructions.
• Would rather automate a task than do it twice.
• Have a high bar for quality.
• Are comfortable challenging a number and investigating why it looks wrong.
• Communicate clearly, especially when the answer isn't what someone expected.
• Enjoy solving ambiguous problems and experimenting with new tools.
• See AI as a way to extend your analytical capabilities, not replace judgment.

What We Offer

• 100% remote work from home.
• Work From Home and Wellness benefits.
• Regular mentorship and opportunities for accelerated growth.
• Access to leading AI tools and time to experiment and build with them.
• Exposure to complex problems across national consumer brands.
• Global collaboration across India, US, and Brazil.

How to Apply

Apply through https://forms.gle/eVTon1ooempK1WHcA.

The application includes a short screening test focused on the analytical and technical skills relevant to this role. We only review applications submitted through the application form.