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). The Role As a Data Engineer yo u will be a key member of a specialist D ata and T ech solutions team within the7stars . You will be using cloud platforms ( primarily G oogle C loud P latform, but also AWS and Azure ) to build databases, transform, model , and activate data from multiple sources including advertising platforms, analytics platforms, and client data . Your role in the team will be to deliver best - in - class data visualisation solutions that unite agency teams and engage marketing stakeholders. Experience with Looker preferable, or similar experience with other BI tools such as Tableau or PowerBI . 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 how APIs are configured. You will need to have strong experience with using G oogle B ig Q uery , and working with the wider G oogle M arketing P latform 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, improv ing the effectiveness of their marketing goals , and helping them gain valuable , actionable insights about their audiences. Your responsibilities Managing data integrations with clients, between our own platforms and external 3rd party platforms , data partners and development partners . P roject 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. You will be 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 issues in a timely manner . Highly numerate and able to confidently work with data to identify patterns and inconsistencies. Collaborative with strong interpersonal and relationship building skills, and have the ability to train others. Team player who motivates others and encourages close collaboration. Strong accountability to meet deadlines and attention to detail. Ability to manage workloads across multiple projects. Adept at organisation, multi-tasking, time management and project management. Able to communicate clearly and proactively to manage stakeholder expectations. You will need Experience in an engineering /developer role with an emphasis on media and marketing data solutions Experience with Salesforce Strong experience and understanding of marketing platforms, metrics and KPIs Industry experience of SQL and python A track record of implementing cloud-based data solutions The ability to manage projects and processes independently A good understanding of business and marketing performance metrics A good understanding of the ad/mar-tech landscape Excellent interpersonal and communication skills Excellent attention to detail Salary & Benefits Competitive salary Uncounted holiday Free breakfast Free company bar New Business Bonus eligible in your first year as a the7stars employee Personal finance advice from Financial Advisor Life Assurance Critical Illness cover Income protection Summer profit share bonus and Christmas bonus Private Medical Insurance Gym Membership (choice of mutilple local options) Season ticket Loan Cycle to work Scheme Techscheme Extensive Maternity, Paternity, fostering and adoption leave package, including a bonus for birthing parents when they announce they are expecting and a Gousto box for when the baby first arrives home Royal London pension (Including a Green Pension option) Employee assistance programme Our working pattern is Monday-Thursday in our Covent Garden offices, followed by hybrid working on Friday. the7stars is committed to creating a diverse environment, where employees feel empowered to share different ideas, perspectives and experiences in a collaborative and creative work environment. Equality and inclusion are at the heart of our culture. All qualified applicants will receive consideration for employment without regard to age, disability, gender reassignment, marriage and civil partnership, pregnancy and maternity, race (which includes colour, nationality and ethnic or national origins), religion or belief, sex or sexual orientation.