Data Engineer

About the Group The world is obsessed by small start-ups or the largest corporates. Most UK media agencies are built to serve the top 100 spending clients, and there are a multitude of boutique agencies to serve those starting out in business. The Specialist Works is different. We are built exclusively for marketers at entrepreneurial brands. Businesses that are past the messy start-up stage but are worlds away from the slow-paced nature of large corporates.   Our clients span large privately owned businesses (often PE backed, founder-led or both) and small to mid-cap public enterprises. They are fighting larger, more established competitors and know they need to think and behave differently to win. They don’t conform to category norms. Since they can’t out-spend their competition, disruption is the safest move they can make.   The marketers leading these brands are innovative, resourceful, moving at pace and in all-out growth mode. They’re powerful; redefining categories, overtaking and acquiring traditional businesses and changing consumer behaviour along with it.    Our clients share three common yet exciting challenges which define everything we do as an agency:   Consumer – customer acquisition is key to their success   Company – they are highly ambitious and built lean   Category – they are often outspent by their competitors, need to outmanoeuvre the competition and are passionate about disrupting an established category   Role Overview As a TSW data engineer you will be a key member of a dynamic media activation team, and a 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 collect information for new scopes, investigate new data sources and devise 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 we use to drive efficiency in our data team and across the business. This role is suited to someone with a strong background in Python, SQL and cloud services (Azure, GCP and AWS). A media agency or marketing data background is essential for this role. Requirements Own…