Consumer Data Analyst – Acadia

Company: Acadia
Job Type: Full-Time
Location: India – 100% Remote
Experience: 2+ Years
Work Schedule: EST 4:00 AM – 1:00 PM | IST 2:30 PM – 11:30 PM
Job Function: Analytics / Data Analytics

About Acadia

Acadia is a modern digital agency focused on helping consumer brands achieve sustainable growth through technology, digital media, and analytics.

The company’s capabilities span Retail Media, Analytics & BI, Paid Media, SEO, CRO, and Social. Acadia has been recognized by Ad Age as Performance Marketing Agency of the Year (2024) and one of its Best Places to Work (2025).

Acadia operates around four core values: Candor, Community, Can-Do, and Curiosity.

About the Consumer Data Analyst Role

Acadia is hiring a Consumer Data Analyst to transform complex consumer data into actionable insights that support important business decisions.

In this role, you will work with national consumer brands to analyze questions around growth, customer behavior, market performance, and marketing effectiveness.

You will own analytical projects end to end — from finding and querying data to investigating results, validating findings, and communicating the business story.

The role involves working with large and imperfect datasets across sales, customers, media, and markets. You will also use AI tools such as Claude, ChatGPT, Copilot, or Claude Code to automate workflows, write and review code, improve analysis, and solve practical business problems.

You will collaborate with senior analysts and strategists across India, the United States, and Brazil, with opportunities for mentorship and exposure to sophisticated analytics projects.

Key Responsibilities

• Own analytics projects from business question to final insight.
• Translate business questions into data-driven recommendations.
• Write, optimize, debug, and document SQL queries for large datasets.
• Work with Snowflake and BigQuery databases.
• Use AI tools to automate recurring tasks, write and review code, perform QA, and develop useful analytical workflows.
• Support marketing measurement, market analysis, incrementality testing, and modeling initiatives.
• Investigate changes in data to understand the underlying drivers and business implications.
• Identify trends, anomalies, data-quality issues, and analytical risks.
• Create concise and compelling presentations using PowerPoint and Google Slides.
• Collaborate with Strategy, Account Management, Data Engineering, and Data Science teams.
• Communicate analytical findings clearly to both technical and business stakeholders.

Required Qualifications

• 2–5 years of hands-on analytics experience.
• Experience in agency, consulting, consumer, retail, e-commerce, or technology environments is preferred.
• Strong SQL skills, including:
  • Joins
  • CTEs
  • Window functions
  • Query debugging
  • Working with large datasets
• Experience with Snowflake or BigQuery is preferred.
• Hands-on experience using AI tools to build, automate, or improve a real workflow or solution.
• Ability to validate AI-generated outputs and apply analytical judgment.
• Strong understanding of:
  • Distributions
  • Correlation vs. causation
  • Statistical significance
  • Signal vs. noise
• Strong Excel skills.
• Excellent attention to detail.
• Strong written and verbal English communication skills.
• Ability to work independently and investigate the reasons behind changes in data.
• Strong curiosity and analytical problem-solving skills.

Good-to-Have Skills

• Python and pandas.
• Marketing measurement and analytics.
• Marketing Mix Modeling (MMM).
• Geographic or A/B testing.
• Incrementality testing.
• Regression analysis.
• Consumer and marketing metrics such as:
  • ROAS
  • CPA
  • Conversion rate
  • Average Order Value (AOV)
  • Retention
  • Lifetime Value (LTV)
• Experience with Claude Code, Cursor, Copilot, or similar AI coding tools.
• Experience with Tableau, Power BI, Looker, or ThoughtSpot.

Ideal Candidate Profile

Acadia is looking for someone who:

• Takes ownership rather than waiting for instructions.
• Looks for opportunities to automate repetitive work.
• Maintains a high standard for analytical quality.
• Questions unexpected numbers and investigates the underlying reasons.
• Communicates clearly, including when findings differ from expectations.
• Enjoys solving ambiguous analytical problems.
• Is comfortable experimenting with new technologies and workflows.
• Uses AI to extend analytical capabilities while maintaining human judgment and validation.

What Acadia Offers

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

Job Details

Category	Details
Company	Acadia
Position	Consumer Data Analyst
Job Type	Full-Time
Location	India – Remote
Experience	2–5 Years
Work Schedule	EST 4:00 AM – 1:00 PM / IST 2:30 PM – 11:30 PM
Department	Analytics
Key Skills	SQL, Snowflake, BigQuery, Excel, AI Tools, Data Analytics
Preferred Skills	Python, pandas, Tableau, Power BI, Looker, Marketing Analytics
Work Mode	100% Remote

How to Apply

Interested candidates can apply through the official application form.

Application: https://forms.gle/eVTon1ooempK1WHcA

The application process includes a short screening test covering analytical and technical skills relevant to the role.

Note: Acadia reviews applications submitted through the application form.