Business Analyst

Bicester Village; Barcelona; Presencial; EUR 50.000 - 70.000; Jornada completa

Descripción de la vacante

A leading luxury shopping destination in Barcelona is seeking a Data Analyst to transform guest data into actionable insights. In this role, you will analyze historical data, run segmentation analyses, and build KPI reports to enhance business strategies. The ideal candidate will have strong analytical skills, experience in data analytics, and proficiency in SQL and Power BI, alongside a competitive benefits package including generous annual leave and health coverage.

Servicios

25 days annual leave

Private medical and dental cover

Generous employee referral bonus

Discounts throughout our villages

Formación

• Strong experience in data analytics or related fields.
• Proficient in SQL for database manipulation.
• Ability to translate complex data into actionable insights.

Responsabilidades

• Analyze historical data and present findings to inform strategy.
• Run segmentation analysis to identify key driver segments.
• Build and maintain KPI reporting for Membership and PCS programmes.
• Provide training and support to other analysts.

Conocimientos

Analytical skills

SQL proficiency

Microsoft Office proficiency

Communication skills

Python knowledge

Power BI skills

Ability to work independently

Interpersonal skills

Educación

Degree education or equivalent

Herramientas

SQL

Power BI

Excel

Salesforce

Descripción del empleo

Something Extraordinary Every Day™

Shape how we understand and grow guest value.

Join our team at La Roca Village to turn guest data into insight, action, and measurable impact. In this key role, you’ll transform complex datasets into clear narratives and opportunities that drive loyalty and value across our Membership and Private Client Services programmes.

You’ll partner closely with Marketing, Retail and PCS to embed data-led decisions in campaigns and experiences—fueling smarter targeting, better journeys, and continuous improvement in our performance metrics. (Membership & PCS context)

About the role

Guest Data & Insight Execution

• Analyze historical data and present findings that inform strategy and forecast future trends.
• Run segmentation analysis on our database to identify key driver segments and opportunities to enhance customer lifetime value through targeted communications and initiatives.
• Identify high‑value guest segments within the Membership programme to help grow the Private Client Services programme.
• Assess effectiveness of initiatives by performing ad hoc analysis, including program rewards and A / B tests on email and other communications.
• Summarize insights into clear, cohesive stories and articulate recommendations for business decisions.
• Codify best practices from A / B tests and loyalty initiatives to optimize performance.

Analytics & Reporting

• Structure and execute analysis, then build and maintain regular KPI reporting for Membership and PCS programmes.
• Develop dashboards for business leaders to monitor performance in real time.
• Support Finance and Village teams in budgeting, forecasting and KPI setting exercises.
• Build and maintain commercial models for the Membership programme.
• Provide training and support to other analysts on reporting tools and best practices, particularly within Guest Knowledge & Engagement and PCS teams.

Data Management & Collaboration

• Support data migration of Private Client Services guest data into the Membership database through product ownership and testing.
• Work with Coniq (our physical and digital touchpoint platform) and internal champions to deliver guest reporting as required.

This is a key role to transform guest data into actionable insights that drive loyalty and measurable impact. If you’re passionate about analytics and creating value through data, we’d love to hear from you.

Role requirements

Ideal experience and skills :

• Degree education or equivalent qualifications is preferred
• Experience in data analytics, strategy, management consulting, investment banking or equivalent
• Computer literate and high proficiency in Microsoft Office
• Demonstrate a competent working knowledge of using SQL to design and manipulate databases, using intermediate / advanced Excel and Power BI and Power BI DAX skills to handle large data sets
• Good working knowledge of Python is also preferred and experience using Salesforce would be advantageous
• Ability to structure large analytical problems, break them down and execute analysis
• Detailed understanding of guest intelligence and impact it has on business strategy
• Demonstrable experience of adding value to consumer insights function
• Highly analytical and meticulous
• Ability to translate data into information for non‑analysts
• Ability to clearly explain information and impact to others
• Good interpersonal and communication skills
• Able to work well with all levels across the business
• Ability to both work as a team and work independently with minimal supervision
• Fluent in English and local Village language, any other European language would be beneficial

There’s no one quite like us

The Bicester Collection are the worlds’ leading luxury shopping destinations, and we are committed to creating magical and memorable experiences for our guests. Taking the name of the founding Village, The Bicester Collection distinguishes the 11 Villages in Europe and China as one collection of destinations for our guests, our brand partners, our travel and tourism partners, our corporate and financial media, and our internal teams.

What we do for you

The key to our success is the quality and commitment of our people. In return for your dedication and hard work, you’ll receive a generous salary and along with a competitive benefits package including 25 days annual leave, along with extra leave on your birthday and if you are getting married or moving, you will receive discounts throughout our villages, a very generous employee referral bonus, access to private medical and dental cover, along with many more benefits!

Come and live your story with us

The key to our success is the quality and commitment of our people. We are diverse in background, age, experience and leadership style. We believe that an inclusive workforce makes magic happen. We have huge ambition for what we can achieve together, and we want to have fun!