Analytics Engineer (m/f/d)

appinio
London, EnglandPosted Mid levelSalary not listed
<div class="content-intro"><p><strong>Allow us to introduce ourselves</strong></p> <p>Hello there! We’re Appinio, a global market research company that combines an AI-powered insights platform with expert consultancy. On a mission to make the world a little more fact-based, we help companies understand how consumers think and make smarter decisions.</p> <p>We started out in Hamburg back in 2014, but we’re now humbled to call the world our playground, with over <strong>260 employees</strong> spread across <strong>13 countries </strong>(we’re remote-first), 2600+ international clients, delivering research from <strong data-stringify-type="bold">+190 markets,</strong> globally.</p> <p>Want to be a part of the Appinio movement? <strong>🚀</strong></p> <p><span data-preserver-spaces="true">Here at Appinio, we value <strong>transparency</strong> <strong>in our recruitment process</strong>, and we've created a blog to share what to expect during each step of our journey together:</span><strong><span data-preserver-spaces="true"><em data-stringify-type="italic">&nbsp;</em></span><span data-preserver-spaces="true"><a class="c-link c-link--focus-visible" href="https://www.appinio.com/en/blog/life-at-appinio/appinio-recruitment-process" target="_blank" data-stringify-link="https://www.appinio.com/en/blog/life-at-appinio/appinio-recruitment-process" data-sk="tooltip_parent">here</a></span></strong></p></div><div class="role"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454830"> <p><strong>Your mission as an Analytics Engineer</strong></p> <p>We are looking for an Analytics Engineer (m/f/d) with strong data engineering skills to join our Data team and help build a scalable, reliable, and well-structured data foundation across Appinio.<br>In this role, you will design and maintain clean, scalable data models that make data easy to access, understand, and use across the organisation. You will use SQL, dbt, and Python to transform raw data into meaningful datasets, develop automated workflows, and ensure consistency and reliability across our data warehouse.<br>Beyond data modelling, you will contribute to building, maintaining, and optimising data pipelines and integrations. You will work with APIs, databases, and third-party data sources to ensure reliable data ingestion, troubleshoot pipeline issues, and improve the overall stability and performance of our data infrastructure.<br>Working closely with Analytics, Product, Engineering, and business teams, you will help define and standardise key business metrics such as revenue, bookings, and churn, ensuring a single source of truth across the company. You will also take ownership of data quality through automated testing, validation, and monitoring across the data lifecycle.<br>You will explore and leverage AI-powered tools to improve development workflows, automate repetitive tasks, and enhance data engineering and analytics processes. You will also help prepare our data foundation for AI-driven analytics by ensuring that data models, business definitions, and documentation are structured, consistent, and accessible.<br>You will contribute to documentation, performance optimisation, and the continuous improvement of our data stack, helping us build a robust and scalable data platform that enables teams across Appinio to make faster, more informed decisions.</p> <p>&nbsp;</p> <p><strong>What you’ll be doing</strong></p> <ul> <li><strong>Data Modeling:</strong> Design, build, and maintain clean, scalable data models in the data warehouse using SQL and dbt, making data accessible and reliable for analysts and business users.</li> <li><strong>Data Transformation:</strong> Develop and maintain data transformation workflows, turning raw data from multiple sources into structured, analytics-ready datasets.</li> <li><strong>Data Pipelines &amp; Integration:</strong> Build, maintain, and troubleshoot data pipelines and integrations, ensuring reliable data ingestion from APIs, databases, and third-party systems into the data warehouse.</li> <li><strong>Data Quality &amp; Testing:</strong> Ensure data accuracy and reliability by implementing automated tests, validations, monitoring, and proactive issue resolution across data pipelines and models.</li> <li><strong>Documentation:</strong> Document data models, pipelines, business definitions, and transformation logic to ensure transparency, maintainability, and knowledge sharing.</li> <li><strong>Business Logic Ownership:</strong> Define, implement, and standardize key business metrics (e.g. revenue, bookings, churn) to ensure consistency across reporting and analytics.</li> <li><strong>Collaboration:</strong> Work closely with analysts, business stakeholders, and engineering teams to understand data requirements and deliver reliable, scalable data solutions.</li> <li><strong>Performance &amp; Infrastructure Optimization:</strong> Optimize SQL queries, dbt models, and data pipelines for performance, scalability, and efficient use of data warehouse resources.</li> </ul> <p><strong>You will thrive in this role if</strong></p> <ul> <li><strong>Strong SQL &amp; Data Modeling Skills:</strong> You have excellent SQL skills and hands-on experience designing, building, and maintaining scalable data models in a modern data warehouse.</li> <li><strong>Experience with dbt: </strong>You have practical experience using dbt to develop, test, document, and maintain reliable data transformation workflows.</li> <li><strong>Data Engineering &amp; Python:</strong> You are proficient in Python and have experience building, maintaining, and troubleshooting data pipelines, including integrations with APIs, databases, and third-party systems.</li> <li><strong>Data Warehousing Knowledge: </strong>You understand modern data warehouse architectures and have experience working with cloud-based solutions such as Amazon Redshift, Snowflake, or BigQuery.</li> <li><strong>Data Quality &amp; Reliability:</strong> You have a strong understanding of data quality principles, automated testing, validation, and monitoring, with a proactive approach to identifying and resolving issues.</li> <li><strong>Business Understanding:</strong> You can translate business requirements into reliable data models and clearly defined metrics, balancing technical quality with practical business needs.</li> <li><strong>Problem-Solving &amp; Ownership:</strong> You are analytical, detail-oriented, and comfortable taking ownership of technical challenges, investigating root causes, and developing sustainable solutions.</li> <li><strong>Collaboration &amp; Communication:</strong> You communicate technical concepts clearly, work effectively with both technical and non-technical stakeholders, and enjoy collaborating across teams.</li> <li><strong>AI &amp; Automation Mindset:</strong> You are curious about AI-powered development tools and actively explore opportunities to automate repetitive tasks, improve workflows, and increase productivity.</li> </ul> <p><strong>What’s in it for you?</strong></p> <ul> <li><strong><span data-preserver-spaces="true">Flexibility</span><span data-preserver-spaces="true"> Policy</span></strong><span data-preserver-spaces="true"> - Average is 30 days taken, however, we do not have a hard cap of number of vacation days as we know life happens</span></li> <li><strong><span data-preserver-spaces="true">Temporary work from abroad - </span></strong><span data-preserver-spaces="true">If you're based in the EU, you can work outside your country of residence for up to 180 days per year</span></li> <li><span data-preserver-spaces="true">All the hardware you need and&nbsp;</span><strong><span data-preserver-spaces="true">your own MacBook</span></strong></li> <li><span data-preserver-spaces="true">If you are located in Hamburg or Berlin, you'll get a&nbsp;</span><strong><span data-preserver-spaces="true">Deutschland ticket</span></strong><span data-preserver-spaces="true"> or access to a mobility budget with the&nbsp;</span><strong><span data-preserver-spaces="true">NAVIT app</span></strong><span data-preserver-spaces="true"> to get you to and from the office space</span></li> <li>Subsidised <strong>Urban Sports Club </strong>or <strong>ClassPass</strong> membership based on location</li> <li><span data-preserver-spaces="true">In case</span><span data-preserver-spaces="true"> you’re located in one of the cities where most of our fellow Appinioneers are (Hamburg, Berlin, Munich, London, Madrid, Barcelona, or New York), you can get access to our&nbsp;</span><strong><span data-preserver-spaces="true">Co-working spaces</span></strong></li> </ul> <p><strong><span data-preserver-spaces="true">Additional role details</span></strong></p> <ul> <li>This is a&nbsp;<strong>fully remote position</strong>&nbsp;open to candidates based in Germany, the UK, Portugal, the Netherlands, and Spain</li> <li>This role will report directly to our Team Lead, Business Intelligence</li> </ul> <p><strong><span data-preserver-spaces="true">Our interview process</span></strong></p> <ul> <li>Screening Call with the Talent Acquisition team</li> <li>Hiring Manager interview</li> <li>Case Study&nbsp;</li> <li>Executive Interview</li> <li>References</li> </ul> </div> </div><div class="content-conclusion"><div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454846"> <div class="role"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454830"> <p><strong>Kind reminder:</strong>&nbsp;Please ensure that your application is submitted in English.</p> <p><em data-stringify-type="italic">This post not only outlines our ideal candidate but also serves as an inspiration for what this role can evolve into. Even if you consider yourself an 80% fit but have a genuine passion for this position, we encourage you to apply. We're eager to hear from individuals who share our enthusiasm.</em></p> <p><em>Appinio is an equal-opportunity employer. All applicants will be considered for employment without attention to race, colour, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.<br><br></em><strong>Please read our privacy policy <a href="https://www.appinio.com/en-gb/privacy">here</a>.</strong></p> </div> </div> <div class="ja-right"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454850"> <div class="contact"> <div class="c3"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454866"> <div> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454878"><strong>Learn more about us:</strong></div> </div> <div class="a1"><a href="https://appinio.com/" target="_blank"><img style="max-width: 100%;" src="https://jobdata.prescreen.io/appinio/website-icon.svg">&nbsp;appinio.com&nbsp; &nbsp;</a><a href="https://de.linkedin.com/company/appinio-gmbh" target="_blank"><img style="max-width: 100%;" src="https://jobdata.prescreen.io/appinio/linkedin-icon.svg">&nbsp;LinkedIn &nbsp;&nbsp;</a><a href="https://www.xing.com/companies/appiniogmbh" target="_blank"><img style="max-width: 100%;" src="https://jobdata.prescreen.io/appinio/xing-icon.svg">&nbsp;Xing&nbsp; &nbsp;&nbsp;</a><a href="https://www.kununu.com/de/appinio" target="_blank"><img style="max-width: 100%;" src="https://jobdata.prescreen.io/appinio/kununu-icon.svg">&nbsp;Kununu &nbsp;&nbsp;</a><a href="https://www.instagram.com/appinio" target="_blank"><img style="max-width: 100%;" src="https://jobdata.prescreen.io/appinio/instagram-icon.svg">&nbsp;Instagram</a></div> </div> </div> </div> </div> </div> </div> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454850"> <div class="offer"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454854"> <div class="contact"> <div class="c3"> <div class="job-ad-editable job-ad-editable job-ad-editor" data-content="6454866">&nbsp;</div> </div> </div> </div> </div> </div></div>

Find Jobs in United Kingdom on Arbeitnow

Check your resume against this jobSee which keywords from this posting your resume is missing.
Check my resume

Also listed on