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 you will be a key member of a specialist Data and Tech solutions team within the7stars.

You will beusing cloud platforms(primarily Google Cloud Platform, but also AWSand Azure) to build databases, transform, model,and activate data from multiple sourcesincludingadvertising platforms, analytics platforms, and client data. Yourrole in the team will be to deliver best-in-class data visualisation solutions that unite agency teams and engage marketing stakeholders.Experience with Lookerpreferable, 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 APIsare configured.

You will need to have strong experience with using Google BigQuery, and working with the wider Google Marketing Platform stack, including familiarity with Google Analyticsdata,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 experience with utilising data clean roomsand integrating 1stparty audiences from clients to 3rdparty solutionswould 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.

Your responsibilities

• Managing data integrations with clients, between our own platforms and external 3rd party platforms, datapartnersand developmentpartners.

• Project management, co-ordinating various stakeholders to make sure the right access is setup, the data is validatedand documenting the process and updates clearly and regularly.

• Building/implementingand scalingsolutions across clients,enablingdata-driven activation and campaign activation.

• Creating and maintainingELT pipelinesto 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 identifypatterns and inconsistencies.

• Collaborative with strong interpersonal and relationship building skills, andhave the ability totrain 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 managementand 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 recordof 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.