As a mid-level 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.