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 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 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.