All jobs
Acadia logo

Consumer Data Analyst

Acadia · Posted 1 month ago

  • India (Remote)
  • Remote
  • Full-time
  • 2-5 yrs

About the role

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.

Skills

SQL: Joins, CTEs, window functions, debugging, and large datasetsAnalytical thinking: Distributions, correlation vs. causation, significance, signal vs. noiseExcel skillsClear communication

Quark9 guide

How to land this Consumer Data Analyst role

Our notes for applicants, based on how data and AI hiring usually works and on 337 similar open jobs on Quark9.

Resume checklist for this job

Most companies screen resumes with an ATS before a person reads them. Make sure each skill you genuinely have appears in your resume in the same words the job uses.

Must have

  • SQL: Joins, CTEs, window functions, debugging, and large datasets
  • Analytical thinking: Distributions, correlation vs. causation, significance, signal vs. noise
  • Excel skills
  • Clear communication
  • Lead each project with the business result (revenue, cost, time saved), then the method
  • List the stack precisely: SQL dialect, Python libraries, BI tool, cloud platform
  • Link a portfolio or GitHub with one or two well-documented projects
Check your resume against this job free

What interviewers expect: early to mid level

Expect questions about work you owned end to end. Show what you delivered, the tools you used daily and one or two results with numbers.

How data and AI interviews usually run

  1. A screening call on your projects and the size of data you have worked with
  2. A SQL round, usually joins, window functions and aggregations on a sample schema
  3. A case or modelling round: frame a business problem, choose metrics, explain trade-offs
  4. A take-home or live exercise in Python, then a final round with the hiring manager

Questions worth preparing

  • Write a query for the second-highest salary in each department.
  • How would you measure whether a new feature improved retention?
  • Explain overfitting to a non-technical stakeholder and how you guard against it.
  • Walk through a project end to end: the question, the data, the method and the impact.

Every company runs its own process, so treat this as a likely shape, not a promise. Practise a mock interview on Quark9 and get scored feedback before the real one.

The market for Data Analyst roles right now

  • Most openings are in Bengaluru, Pune, Gurgaon, Hyderabad, and 2 of the 20 we looked at offer remote work.
  • The skills these jobs ask for most:
SQLData analysisMicrosoft ExcelPythonProject managementCommunicationBusiness analysisData analytics

From open jobs on Quark9 matching “Data Analyst”, updated every few minutes.

Similar jobs