At a Glance
- Tasks: Join Trustpilot as a Senior Analytics Engineer, bridging business and tech teams to enhance data-driven decisions.
- Company: Trustpilot is a global leader in consumer reviews, fostering trust between businesses and consumers since 2007.
- Benefits: Enjoy flexible working, competitive pay, 25+ days holiday, volunteering days, and wellness perks like Headspace access.
- Why this job: Shape innovative analytics solutions in a vibrant, collaborative culture that values diverse perspectives and personal growth.
- Qualifications: Experience with cloud data warehouses, SQL proficiency, and a passion for data-driven impact are essential.
- Other info: Join a diverse team across multiple global locations, committed to creating an inclusive environment.
The predicted salary is between 48000 - 84000 £ per year.
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 will be a crucial bridge between our business and technical teams, directly influencing Analytics, Data Science, Data Engineering, and Product. You will 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 insurance.
- Health 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 table tennis, a gaming corner, coffee bars and 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.
- Independent financial advice and free standard professional mortgage broker advice.
- Talent acceleration programs: Fast-track your career with our tailored development programs designed to support growth at whatever stage of your career.
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.
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.
Senior Analytics Engineer employer: Trustpilot
Contact Detail:
Trustpilot Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Analytics Engineer
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as GCP, Airflow, and dbt. Having hands-on experience or projects showcasing your skills with these technologies can set you apart from other candidates.
✨Tip Number 2
Network with current or former employees of Trustpilot on platforms like LinkedIn. Engaging in conversations about their experiences can provide valuable insights into the company culture and expectations for the role.
✨Tip Number 3
Prepare to discuss your previous projects that involved data warehousing and analytics. Be ready to explain your thought process, challenges faced, and how you overcame them, as this will demonstrate your problem-solving skills.
✨Tip Number 4
Showcase your communication skills by preparing to explain complex technical concepts in simple terms. This is crucial for the role, as you'll need to bridge the gap between technical and non-technical teams.
We think you need these skills to ace Senior Analytics Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in analytics engineering, particularly with cloud data warehouses and modern data stacks. Emphasise your skills in SQL, data manipulation, and any specific tools mentioned in the job description, such as GCP, Airflow, and dbt.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data and how it drives business decisions. Mention specific projects or experiences that demonstrate your ability to bridge technical and non-technical teams, as well as your advocacy for a 'data as a product' mindset.
Showcase Relevant Projects: If you have worked on projects involving data pipelines, reverse ETL processes, or data observability, be sure to include these in your application. Highlight your role in these projects and the impact they had on the organisation's data landscape.
Prepare for Technical Questions: Anticipate technical questions related to data engineering best practices, SQL queries, and data quality monitoring. Be ready to discuss your approach to problem-solving and how you ensure data accuracy and reliability in your work.
How to prepare for a job interview at Trustpilot
✨Understand the Data Stack
Familiarise yourself with the modern data stack mentioned in the job description, particularly GCP, Airflow, and dbt. Be prepared to discuss how you've used these tools in previous roles and how they can be leveraged to enhance Trustpilot's data warehouse.
✨Showcase Your SQL Skills
Since proficiency in SQL is crucial for this role, come ready to demonstrate your skills. Prepare examples of complex queries you've written, focusing on data manipulation and optimisation, and be ready to explain your thought process.
✨Communicate Clearly
As the role requires collaboration across technical and non-technical teams, practice explaining complex technical concepts in simple terms. This will showcase your communication skills and ability to bridge gaps between different stakeholders.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities and your approach to data quality and observability. Think of past experiences where you identified and resolved data issues, and be ready to share those stories.