BUSINESS ANALYST

Macadam; Barcelona; Hybrid; EUR 60,000 - 85,000; Full time

Benefits offered by this job

Meal vouchers

Private healthcare (Alan)

Wellness allowance (Wellhub)

Hybrid working culture

4 extra Macadam holiday days

Job summary

Macadam is seeking a senior, data-driven Business Analyst to join our Analytics & Data team in Barcelona. You’ll blend product and data analysis to turn insights into decisions across product, marketing and business strategy.

Fluency in SQL and a product mindset are essential; experience with mobile apps or gaming is a plus. You’ll own end-to-end analyses, build dashboards, design experiments with the team, and help shape data-informed decisions that impact millions of users.

Qualifications

• 5+ years as a Business Analyst or a similar role in consumer apps.
• Excellent SQL and data-analysis skills for large datasets.
• Solid experimentation skills: design, size, interpret A/B tests.
• Strong product-analytics focus: funnels, cohorts, retention, KPIs.
• Ability to own end-to-end projects and present clear recommendations.
• Fluent in English and able to turn analyses into actionable insights.

Responsibilities

• Analyze user behavior, product usage, and business performance to provide actionable insights and own complex analyses behind engagement features.
• Build dashboards and reports for cross-functional teams using SQL, spreadsheets, and BI tools.
• Collaborate with product, marketing and engineering to design and measure experiments and scale A/B testing.
• Deep-dive into trends, funnels, and cohorts to identify growth opportunities.
• Build models like LTV, churn, user personas, and segmentation to inform monetization.
• Lead unique projects, from concept to delivery, and communicate impact clearly.
• Define and track key metrics and review event tracking with product owners.
• Contribute to data hygiene, standardization, and documentation across teams.
• Improve data access via views, tables, and documentation; support AI tooling adoption.

Skills

SQL

Data analysis

A/B testing

Product analytics

Storytelling with data

Leadership

English fluency

Tools

Mixpanel

Metabase

Firebase

BigQuery

Job description

WHO WE ARE

Macadam is a movement powered by over 15 million users who walk every day with us. We’re here to make walking more rewarding, engaging, and consistent - not just a habit, but something people genuinely enjoy.

Rooted in thoughtful design, our approach helps people stick with healthier routines by making them feel simple, motivating, and fun. As we grow, we’re focused on deepening our impact: supporting our community with smarter tools, richer experiences, and more reasons to keep moving.

If you’re passionate about building products that improve lives at scale, we’d love to meet you.

THE ROLE

We’re looking for a senior, data-driven Business Analyst to join our Analytics & Data team. We call it Business Analyst, but it’s more than that: part product analyst, part data analyst, with a real slice of data science. You’ll play a key role in turning data into insights that drive product, marketing, and business decisions.

If you’re fluent in SQL, love solving business problems with data and want to own your projects end to end, this role is for you. A product-oriented mindset is essential - and experience in mobile apps or gaming is a strong plus.

Location: Barcelona

WHAT YOU’LL DO

• Analyze user behavior, product usage, and business performance to provide actionable insights, and own the complex analyses behind our engagement features.

• Build dashboards and reports for cross-functional teams using SQL, spreadsheets, and BI tools.

• Work closely with product, marketing, and engineering to design and measure experiments, supporting our data scientist in scaling A/B testing across the company.

• Deep-dive into trends, funnels, and cohorts to uncover growth opportunities.

• Build models that drive decisions: LTV, churn, user personas and segmentation for monetization.

• Take on unique projects, like the matchmaking model behind our user leagues.

• Define and track key metrics (KPIs) and review event tracking with product owners, building a data-informed culture across teams.

• Contribute to data hygiene, standardization, and documentation.

• Help maintain and improve data accessibility across teams (via views, tables, documentation).

• Use AI tools every day (Claude, MCP and our data skills) to work faster and automate recurring work.

WHAT YOU’LL BRING

• 5+ years as a Business Analyst, Product/Data Analyst or similar, ideally in consumer apps.

• Excellent SQL and comfort working with large datasets.

• Solid experimentation skills: you know how to design an A/B test, size it, read it and spot when it’s lying.

• Strong product analytics: funnels, cohorts, retention and business KPIs.

• Real ownership: you can lead a project end to end, ask others for what you need, prioritize by impact and ship without chasing perfection.

• The ability to turn complex analyses into clear stories and recommendations.

• Comfort with variety: one day an LTV model, the next an event review.

• Fluent English.

NICE TO HAVE

• Python.

• Experience in mobile apps, mobile gaming or LiveOps, or marketplaces.

• LTV, churn or fraud modelling.

• Mixpanel, Metabase, Firebase, BigQuery or similar tools.

WHAT’S IN IT FOR YOU

• Ownership from day one: you’ll lead projects, not wait for tickets.

• Real influence on product, growth and monetization decisions for millions of users.

• A broad scope: product analytics, LTV, churn, segmentation and experimentation, all in one role.

• An AI-first team that wants everyone to make the most of the tools.

• A profitable, self-funded company in a growth phase, where your work is visible.

• Meal vouchers, private healthcare (Alan) and a wellness allowance (Wellhub).

• Hybrid working culture with international flexibility.

• 4 extra Macadam holiday days.

• Offices in the heart of Barcelona, Friday team lunches, company events and offsites.

WHY MACADAM?

We don't just talk about change, we walk it. Our principles:

Make it happen: take ownership, drive outcomes that matter.

Build together, win together: support and challenge each other to go further.

Trust the data: decide clearly, act confidently, measure what counts.

Build for people: design with empathy, simplicity, real humans in mind.

Think bigger: set the bar high, push boundaries, imagine better ways.

Want to see what we're about? Check out our website, Linkedin, Notion and Instagram page.

Macadam is an equal opportunity employer, committed to a diverse and inclusive team.