ABOUT THE GROUP:

The Specialist Works, part of What's Possible Group, is an independent media and marketing services agency. With an evidence-based approach, we provide media planning and buying, data science, brand partnerships and creative solutions. 

Our independence gives us the freedom to keep challenging the status quo to achieve even better results. Everything we do – from the people we hire to the tools we build – is about future proofing our clients. Our capabilities have been built and shaped by their needs.

JOB SUMMARY:

As a TSW data engineer you will be a key member of a dynamic media activation team, and critical part of our service delivery to clients. You will oversee the integrity and evolution of our reporting and attribution platforms.

Day-to-day you’ll be responsible for creating, monitoring, maintaining, and optimising data pipelines within the TSW data ecosystem – primarily using Azure and the Adverity platform. This means writing SQL queries to generate bespoke reporting outputs, troubleshooting code issues, and implementing changes to futureproof the code. You’ll also be collecting information for new scopes, investigating new data sources and devising the business logic to get to the desired output.

You will work closely with our head of digital delivery to create bespoke marketing intelligence reports for clients, bringing together data from multiple sources to enable campaign activation and automation. As part of this you’ll collaborate closely with internal stakeholders, suppliers, and clients to ensure that data is provided correctly and that our data solutions adhere to the data governance required.

You’ll have a big say in our data product roadmap and how it’s deployed. Your input will help shape the processes and tools that we use to drive efficiency in our data team and across the business.

This role is suitable for someone with a strong background in Python, SQL and Cloud Services (Azure, GCP, and AWS). A media agency or marketing data background would give you the best possible start.

LOCATION: London/hybrid

Requirements

YOUR ROLE & RESPONSIBILTIES

• Ownership of delivery of new and existing ETL pipelines, and data engineering projects for the agency and wider group
• Work collaboratively with media teams and other business partners to make sure data is available and interpretable across the business
• Provide client-facing support with onboarding and troubleshooting for our data solutions
• Help shape the continuing evolution of our data ecosystem by bringing your experience to product design and architecture discussions, collaborating to help suggest, develop, design and write new solutions
• Own the work across various DevOps tasks (managing cloud infrastructure in support of our data solutions)
• Ensuring adherence to data governance and data security best practices throughout our ecosystem
• Be an internal champion for our data solutions, encouraging adoption and supporting smooth implementation
• Doing all the above while demonstrating the ability to be friendly, yet assertive, when working with other team members, suppliers and clients in order to complete work to our required standard

WHAT YOU ARE ABLE TO BRING

• 2-3 years of full-time Python and SQL experience
• Experience and understanding of how APIs extract data from various platforms
• Experience with data orchestration tools (e.g. Airflow, Prefect, etc) and building scalable data pipelines.
• Strong Git and collaborative development skills (i.e. GitHub, Gitlab, etc)
• Strong understanding of data fundamentals (MDM, data integrity best practices, auditing processes, automated validation, etc.)
• Cloud DevOps experience (i.e. Azure, GCP, AWS, etc.)
• Strong experience in create technical requirements out of business/data needs
• Ability to communicate technical concepts and requirements in non-technical language
• Back-end development for visualisation and dashboarding products (Power BI, Tableau, Datorama, etc). Experience with AdVerity would be extremely valuable.

Additionally, the following are “nice to have” but would give you a strong advantage in the role:

• Experience working in a media agency, or with media and marketing data (both digital and non-digital) is highly desirable
• Experience working with Linux VMs
• Worked with shell scripting (e.g. bash, zsh, etc)
• Creating or using Git-hooks
• Continuous integration / continuous deployment tools experience

Benefits

We provide an exciting, fast paced, people first environment that allows everyone to grow, learn and thrive. We encourage a flexible way of working to adapt to personal circumstances, individual, and business needs.

Currently operating a 9 day fortnight, meaning staff have every other Friday off!

We offer all our employees share options, and we've built a benefits package that invests in our employees’ long-term personal and professional growth and wellbeing.

Our Values

- Passion: You share your excitement about what drives you

- Inquisitiveness: Ask "what's possible?". Ask "why not?".

- Caring:Be a good professional, a good colleague and a good human.

- Knowledge:Know plenty. Share it. Learn more.

And we live them every day#IamPICK

Sound good to you? Then get in touch. We don’t bite.

At The What's Possible Group our culture, our creativity and our passion is powered by people. People just like you. Diversity and difference drive innovation, not only for us but also for our clients and is at the heart of everything that we do.

The What's Possible Group is proud to be an equal opportunities employer. We welcome applications from all, regardless of race, gender, disability, religion, sexual orientation or age as we seek to recruit the very best at The What's Possible Group from a diverse talent pool. If you require flexible working options please still get in touch and we’ll be as accommodating as we can.