Senior Analytics Engineer

Trustpilot, Inc.; City of Edinburgh; On-site; GBP 50,000 - 70,000; Full time

Job summary

Join a leading company as an Analytics Engineer to bridge business and technology. You will maintain the data warehouse and business intelligence tools, develop data pipelines, and collaborate cross-functionally to optimize data solutions. Enjoy competitive pay, flexible options, and rich benefits that support your career growth and personal well-being.

Benefits

Flexible working options

Competitive compensation package + bonus

25 days holiday per year

Paid volunteering days

Learning and development opportunities

Pension and life insurance

Health cash plan

Full access to Headspace app

Season ticket loan

Cycle-to-work scheme

Qualifications

• Experience in cloud data warehouses and modern data stacks.
• Strong SQL skills for data manipulation and querying.
• Ability to collaborate across technical and non-technical teams.

Responsibilities

• Maintain and evolve data warehouse and BI tools for reliable data access.
• Design and monitor robust data pipelines and models using modern tech.
• Collaborate with analysts and data scientists for predictive analytics.

Skills

SQL

Data manipulation

Data pipeline development

Data warehouse

Data quality

Documentation

Stakeholder management

Education

Degree in Computer Science or related field

Tools

GCP

Airflow

dbt

Looker

Segment

Hightouch

Job description

Our vision is to be the universal symbol of trust, bringing consumers and businesses together through reviews. We are well on our way—but there’s still an exciting journey ahead. Join us at the heart of trust.

As an Analytics Engineer at Trustpilot, you'll be a crucial bridge between our business and technical teams, directly influencing Analytics, Data Science, Data Engineering, and Product. You'll leverage our cutting-edge modern data stack to expand and enhance our data warehouse, empowering data-driven decisions across the organisation. This role offers the exciting opportunity to shape our data landscape and contribute to innovative analytics solutions.

What you’ll be doing:

• Maintain and evolve our data warehouse and business intelligence tool, providing reliable data access to users throughout Trustpilot
• Design, build, maintain, and rigorously monitor robust data pipelines and transformative models using our modern data stack, including GCP, Airflow, dbt, and potentially emerging technologies like real-time streaming platforms
• Develop and manage reverse ETL processes to seamlessly integrate data with our commercial systems, ensuring operational efficiency
• Maintain and optimise our Customer Data Platform (CDP, ensuring effective data collection, unification, and routing
• Administer and support our business intelligence tool, Looker, enabling users to provide insightful and user-friendly data visualisations
• Identify opportunities to optimise our data warehouse and development methodologies, with the goal of reduced complexity, improved performance, and cost efficiency
• Collaborate with Analysts and Data Scientists to prepare and model data for predictive analytics and AI/ML initiatives
• Implement and maintain data observability and quality monitoring solutions, including custom alerting, to ensure the reliability and integrity of our data assets
• Work closely with Engineering teams to understand their data needs, collaborate on data integration projects (e.g., web tracking via tracking plans), and build collaborative working relationships

Who you are:

• You advocate a "data as a product" mindset, with a focus on documentation, rigorous reviews, and data accuracy
• You are highly experienced in cloud data warehouses, modern data stacks, and best practices in data engineering
• Your proficiency in SQL includes a wealth of experience in data manipulation, querying, and optimisation
• You are curious, proactive, and interested in the impact of data and technology in business
• You advocate for test-driven development and understand the critical role of high-quality data
• Your communication and stakeholder management skills are highly skilled, allowing you to collaborate effectively across technical and non-technical teams
• You can explain complex technical concepts clearly and succinctly
• You thrive in cross-functional environments, working closely with Engineering, Data Science, and business teams
• Experience with CDP and event tracking platforms like Segment or Hightouch, particularly in event tracking governance
• Familiarity with observability tools, data quality monitoring, and data DevOps practices

What's in it for you?

• A range of flexible working options to dedicate time to what matters to you
• Competitive compensation package + bonus
• 25 days holiday per year, increasing to 28 days after 2 years of employment
• Two (paid) volunteering days a year to spend your time giving back to the causes that matter to you and your community
• Rich learning and development opportunities are supported through the Trustpilot Academy and Blinkist
• Pension and life insuranceHealth cash plan, online GP, 24/7 Employee Assistance Plan
• Full access to Headspace, a popular mindfulness app to promote positive mental health
• Paid parental leave
• Season ticket loan and a cycle-to-work scheme
• Central office location complete with all the snacks and refreshments you can ask for
• Regular opportunities to connect and get to know your fellow Trusties, including company-wide celebrations and events, ERG activities, and team socials
• Access to over 4,000 deals and discounts on things like travel, electronics, fashion, fitness, cinema discounts, and more.

About us

Trustpilot began in 2007 with a simple yet powerful idea that is more relevant today than ever — to be the universal symbol of trust, bringing consumers and businesses together through reviews. Trustpilot is open, independent, and impartial — we help consumers make the right choices and businesses to build trust, grow and improve.

Today, we have more than 300 million reviews and 64 million monthly active users on average across the globe, with 140 billion annual Trustbox impressions, and the numbers keep growing. We have more than 1,000 employees and we’re headquartered in Copenhagen, with operations in Amsterdam, Denver, Edinburgh, Hamburg, London, Melbourne, Milan and New York.

We’re driven by connection. It’s at the heart of what we do. Our culture keeps things fresh –– it’s built on the relationships we create. We talk, we laugh, we collaborate and we respect each other. We work across borders and cultures to be the universal symbol of trust in an ever-changing world. With vibrant office locations worldwide and over 50 nationalities, we’re proud to be an equal opportunity workplace with diverse perspectives and ideas.

Our purpose to help people and businesses help each other is a tall order, but we keep it real. We’re a great bunch of humans, doing awesome stuff, without fuss or pretense. A successful Trustpilot future is driven by you –– we give you the autonomy to shape a career you can be proud of. If you’re ready to grow, let’s go.

Join us at the heart of trust.

Trustpilot is committed to creating an inclusive environment where people from all backgrounds can thrive and where different viewpoints and experiences are valued and respected. Trustpilot will consider all applications for employment without regard to race, ethnicity, national origin, religious beliefs, gender identity or expression, sexual orientation, neurodiversity, disability, age, parental or veteran status. Together, we are the heart of trust.

Trustpilot is a global company and our data practices are designed to ensure that your personally identifiable information is appropriately protected. Please note that your personal information will be transferred, accessed, and stored globally as necessary for the uses and disclosures stated in our Privacy Policy.

Apply for this job

First Name *

Last Name *

Preferred First Name

Email *

Phone

Resume/CV

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Tell us who you are! Please select one. *

I am an employee at Trustpilot.

I am not an employee at Trustpilot.

Do you need visa sponsorship to work in this location? * Select...

LinkedIn Profile

What are your salary expectations? *

Please select the country you are applying from. * Select...

Demographic Questions

At Trustpilot, we want to be a place where everyone can feel a sense of belonging and do the best work of their lives. This is critical to our success.

We welcome your participation in the self-identification survey below, should you wish to share your demographic information with us. Your responses will only be used in an aggregated way for diversity, equity and inclusion reporting purposes and to help us identify improvements in our processes so our talent pool represents people from all backgrounds.

We won’t use your responses as part of the recruitment process. Your responses won’t be linked to your application and will be kept separately from your identifiable personal information. Any personal information will be removed.

Answering these questions is optional and voluntary. If you’d rather not answer any of the questions, please select "I don't wish to answer".

I describe my gender identity as * Select...

Do you identify as being transgender * Select...

I identify my ethnicity as being * Select...

My sexual orientation is * Select...

Do you consider yourself to be disabled and / or neurodivergent? * Select...

My religious / spiritual beliefs are * Select...

Are you a Parent or Carer? * Select...

Are you a veteran or active member of the Armed Forces? * Select...