At a Glance
- Tasks: Join a dynamic team to build and manage data solutions using cutting-edge cloud platforms.
- Company: Be part of the UK's largest independent media agency with a vibrant culture.
- Benefits: Enjoy competitive salary, unlimited holiday, free breakfast, and gym membership.
- Other info: Hybrid working model with excellent career growth opportunities in a diverse environment.
- Why this job: Make a real impact by transforming data into actionable insights for top clients.
- Qualifications: Experience in data engineering, SQL, Python, and familiarity with marketing platforms required.
The predicted salary is between 58500 - 71500 £ per year.
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, Ad Week, 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 Engineeryouwill 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.
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 other BI tools such as Tableau or Power BI.
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 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.
- Your responsibilities
- 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.
- You will need
- 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 tocommunicate 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.
#J-18808-Ljbffr
Data Engineer employer: the7stars UK Ltd
At the7stars, we pride ourselves on being the UK's largest independent media agency, fostering a vibrant and inclusive culture that champions creativity and collaboration. Our Covent Garden location offers a dynamic work environment with exceptional benefits, including competitive salaries, generous holiday allowances, and comprehensive family leave packages, all while empowering employees to grow and thrive in their careers. Join us to be part of an award-winning team that values transparency and innovation, making a meaningful impact for our clients and the industry.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like the7stars UK Ltd!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at the7stars UK Ltd.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like the7stars UK Ltd.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at the7stars UK Ltd, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at the7stars UK Ltd, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at the7stars UK Ltd. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at the7stars UK Ltd
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at the7stars UK Ltd!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
