the7stars is unlike any other agency. The distinction started the day we launched in 2005 when we named ourselves after a pub, but more importantly when we made a promise that we were going to do things differently.

And this commitment has stuck with us. It guides how we work, how we think and how we treat one another and can be expressed in a single word.

Freedom.

Our Freedom philosophy lives across our entire business from people, product and planning. It means we plan & buy media how we want​, develop careers how we want, take holiday when we need it​, invent tools when we need them, give people a platform to speak up, question and express themselves freely - but more importantly it has allowed us to create an amazing place to work.

In 2024 we achieved our 12th year in a row as a Sunday Times Top 100 company to work for and in 2023 were awarded Campaign’s number one media agency to work for accolade for the second year running. 

the7stars is 300 passionate media people that are able to focus purely on creating great work for our clients. UK focused, we also operate within an agile global network of like-minded friends, extending our client portfolio into Europe and the US.

If thinking freely and with integrity is your bag, then the7stars is the place for you.

The Opportunity

This is an exciting opportunity for the right candidate to join this new operational business unit within the7stars group. We believe that this is an essential role in delivering the ongoing success of campaign workflow and automation process within the7stars group.

What you’ll be doing:

• Support the development of One Campaign Hub (OCH), delivering a best-in-class data visualisation solution for the agency and for clients
• Plan and build comprehensive dashboards collecting, storing and transforming data from disparate sources across the agency
• Develop and maintain internal processes to ensure ongoing engagement, solution accuracy and reliability
• Educate client stakeholders on platform usage
• Educate internal stakeholders on platform maintenance and support and guide them to deliver client satisfaction
• Pioneer the mission to empower agency users to make OCH the go-to data visualisation and reporting tool, minimising reporting fragmentation and reducing reliance on manual processes and presentation of data in excel/powerpoint
• Support the development and maintenance of automated jobs that ensure required data is made available in the most efficient and scalable way as possible

• Assist the development and maintenance of data quality checks and procedures, helping account teams overcome data issues before they impact the quality of the reporting solution
• Support the translation of user requirements and business needs into functional dashboards

• Monitor automated jobs, troubleshooting data issues when they arise
• Support champion members of the7stars teams responsible for last-mile transformation and visualisation of data within the OCH platform
• Provide hands-on support to users of reporting solutions, helping the wider team triage and respond to user queries in a timely manner
• Develop a team of cross-functional agency champions to support in platform development and maintenance 
• Attend internal stakeholder meetings, presenting your solutions and providing updates on your progress 
• Support the development strong working relationships with third-party data providers that we rely on for access to necessary data, particularly Salesforce and Adverity
• Keep on top of new functions and proactively test any betas that come our way 

Requirements

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

Technical Skills you'll possess

Data Visualization:

• Mastery of data visualization tools (Salesforce Marketing Cloud Intelligence and Adverity being the most desirable for this role)
• Ability to create interactive and engaging dashboards for marketing stakeholders
• Strong understanding of data storytelling and visualization best practices
• Strong experience and understanding of marketing platforms, metrics and KPIs

Data Engineering:

• Proficiency in ETL (Extract, Transform, Load) processes
• Experience with data warehousing and data lakes
• Experience working with different data models and architecture to deliver efficient, scalable visualisations from multiple data sources
• Proficiency in Python, R, or similar languages for data manipulation and analysis
• Proficiency in SQL for data extraction and manipulation
• Knowledge of JavaScript for custom visualizations or integrations

Cloud Platforms:

• Familiarity with cloud platforms (AWS, GCP, Azure) for data storage and processing

Experience you will have...

Essential

• Demonstrable experience working with marketing data sets, preferably within a media agency environment
• Understanding of the standard workflows involved in digital marketing process
• Demonstrable project management experience; you will be expected to inspire, educate, support and guide internal teams and clients, encouraging engagement with automated reporting solutions, ensuring ongoing adherence to process and client satisfaction

Desirable

• Experience working at a media agency or similar, working with data visualisations at scale across multiple entities
• Knowledge of Salesforce Marketing Cloud Intelligence
• Knowledge of Adverity

Apply if you want to...

• Join the largest independent, free thinking, fast moving media agency in the UK
• Have the freedom to grow your career at pace
• Be surrounded by a diverse team of talented thinkers, who love the work they do
• Have the freedom to design a flexible approach to your working life
• Be challenged to learn and grow every day
• Join a business that does more than just media – that gives 5% of its profits back into the community
• Be part of a culture that encourages creativity, entrepreneurialism and most importantly of all… fun

Please don't apply if...

• You need a lot of handholding
• Thinking big isn’t your thing
• Shaping the company, you work for and things around you doesn’t get you excited
• Challenging yourself isn’t something you want to do

Benefits

• Uncounted Holiday

• Performance related Summer profit share & Christmas bonus

• Flexible & hybrid working
• Personalised training plan & access to coaching
• Wellbeing Days
• Flexible pension plan through Royal London
• Optional private medical insurance (Vitality) & cash back plan (Medicash)
• Employee Assistance Programme
• Work from anywhere up to 2 weeks each year
• Paid for gym membership with a choice of 5 gyms
• Enhanced family friendly policies
• Personal financial advice & support
• Life Assurance & Critical Illness cover

• Profit share scheme (after 3 years' service)
• Electric Vehicle scheme
• Nursery Partnership
• Tech & Cycle to Work scheme
• Season ticket loans & expensed Railcard

The7stars is committed to creating a diverse environment, where employees feel empowered to share different ideas, perspectives and experience in a collaborative and creative work environment. Equality and inclusion are 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.