Data Engineer

About the team

the7stars is the UK’s largest independent media agency, offering the best people, the best service and the most creative media campaigns. Our clients include Admiral, The Financial Times, Gousto, Iceland and The Postcode Lottery.

Since our inception in 2005, we set out on a mission – to inspire the exceptional and defeat the bad and the boring. By championing transparency, our goal was to deliver award-winning work for clients across all sectors, whilst fostering a truly vibrant and inclusive culture that welcomes the best industry talent from all walks of life.

20 years on, we have achieved all of this and more. We have graced The Sunday Times Best Places to Work list for thirteen consecutive years, whilst also being crowned Campaign’s Best Place to Work on three occasions. Our work has garnered acclaim from the likes of IPA, WARC, Effie, Media Week, Thinkbox, Campaign Magazine, The Drum, AdWeek, and more. We have continued to grow our agency every single year, delivered show-stopping work for our clients, and have consistently delivered exceptional media value.

The Insight, Analytics and Data unit you will be a part of are an award winning multi discipline team of 25. In recent years we have won prestigious awards including Effie, Campaign, Media Week and IPA Effectiveness Awards, as well as being awarded the IPA’s Effectiveness Accreditation on all three occasions (2021, 2023, 2025).

As aData Engineeryouwill be a key member of a specialist

Data andTech solutions team within the7stars.

You will beusing cloud platforms(primarilyGoogle Cloud Platform , but also AWSand Azure) to build databases, transform, model, and activate data from multiple sourcesincludingadvertising platforms, analytics platforms, and client data.

Your role in the team will bedeliver best- in- class data visualisation solutions that unite agency teams and engage marketing stakeholders.

Experience with Lookerpreferable, or similar experience with otherBI tools such as Tableau orPowerBI.

You will also be involved in future facing marketing transformation projects for the agency and our clients – integrating artificial intelligence and scaling efficient ways of uniting data to deliver market leading tech media planning and activation solutions.

You will need to be familiar with howAPIs are configured.

You will need to have strong experience with using

Google Big Query, and working with the wider

Google Marketing Platform stack, including familiarity with Google Analytics data, and will have experience integrating other 3rd party technologies to enhance our advertisers’ understanding of campaign and business performance.

Experience with integrating and onboarding data from Salesforce Marketing Cloud and Salesforce CRM is required.

Any other e xperience with utilising data clean room s and integrating 1 st party audiences from clients to 3 rd party solutions would also be beneficial.

This role will play a key part in enabling clients to fully lean in to utilising their data to its full potential, improving the effectiveness of their marketing goals, and helping them gain valuable, actionable insights about their audiences.

• Managing data integrations with clients, between our own platforms and external 3rd party platforms, data partners and development partners.
• Project management, co-ordinating various stakeholders to make sure the right access is setup, the data is validated and documenting the process and updates clearly and regularly.
• Building/implementing and scaling solutions across clients, enabling data-driven activation and campaign activation.
• Creating and maintaining ELT pipelines to ensure data freshness and accuracy, working with teams to resolve missing data points and build robust and trustworthy data sets.

• Self-driven, results-oriented, solutions-focused with a desire to advance the agency to deliver improved ways of working.
• Be able to quickly learn and adapt to new systems and processes.
• Able to assimilate information quickly and adhere to processes and best practices.
• Demonstrate critical thinking and problem-solving abilities.
• Highly organised with the ability to resolve…