Data Analyst

Acadia; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Acadia is seeking a data analytics professional to analyze data, build insights, and drive decision-making across client projects. You will write SQL to extract and validate data from large datasets, and support analytics workflows using Snowflake or BigQuery.

You will design automation with AI tools, communicate findings to stakeholders, and investigate root causes behind metric movements. Fluency in English and independence are essential.

Qualifications

• 2–5 years of analytics experience in agency/consulting/retail/e-commerce/tech.
• Strong SQL skills: joins, CTEs, window functions, debugging on large datasets.
• Advanced spreadsheet skills with high accuracy.
• Experience automating analytics with AI tools and validating results.
• Solid understanding of distributions, correlation vs causation, significance.

Responsibilities

• Analyze data and build insights to drive client project decisions.
• Write SQL to extract, transform, and validate data from large datasets.
• Support analytics workflows with Snowflake or BigQuery.
• Design automation using AI tools to streamline analysis.
• Communicate findings clearly to stakeholders with minimal supervision.
• Investigate root causes behind metric movements and trends.

Skills

SQL

Advanced spreadsheets

AI automation

Data analysis

English communication

Statistics

Independence

Curiosity

Tools

Snowflake

BigQuery

Tableau

Power BI

Python

Pandas

Job description

Batch: 2020/2021/2022/2023/2024.

About the role

• Analyze data and build insights that drive decision-making across client projects
• Write SQL to extract, transform, and validate data from large datasets
• Work with Snowflake or BigQuery to support analytics workflows
• Design and implement automation using AI tools to streamline analysis
• Communicate findings clearly to stakeholders and work with minimal supervision
• Investigate root causes behind metric movements and business trends

What we're looking for

• 2 to 5 years of direct analytics experience in agency, consulting, consumer, retail, e-commerce, or technology settings
• Proficiency in SQL including joins, common table expressions, window functions, query debugging, and handling of large datasets
• Advanced spreadsheet skills with meticulous attention to accuracy
• Practical experience building or automating solutions with AI tools, with the ability to explain your validation approach
• Strong grasp of statistical principles: distributions, the distinction between correlation and causation, statistical significance, and differentiating signal from noise
• Fluent English and capability to deliver work independently
• Demonstrated curiosity about the reasons underlying data changes, not just the changes themselves

Bonus skills

• Python or pandas for data manipulation
• Background in marketing measurement, multivariate testing, geo or A/B testing, incrementality analysis, or regression modeling
• Familiarity with consumer and marketing metrics such as ROAS, CPA, conversion rate, average order value, retention rate, or lifetime value
• Experience with AI-assisted coding platforms like Claude Code, Cursor, or Copilot
• Visualization tools including Tableau, Power BI, Looker, or ThoughtSpot