At a Glance
- Tasks: Create and optimise data pipelines using Azure and SQL for innovative marketing solutions.
- Company: Join a dynamic media agency focused on entrepreneurial brands and disruptive marketing.
- Benefits: Enjoy a 9-day fortnight, competitive benefits, and a culture of growth and learning.
- Other info: Be part of a team that values passion, inquisitiveness, and social responsibility.
- Why this job: Make a real impact in a fast-paced environment while shaping the future of data solutions.
- Qualifications: 2-3 years of Python and SQL experience, with a background in media or marketing data.
The predicted salary is between 63000 - 77000 £ per year.
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
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 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, bringing your experience to product design and architecture discussions, and collaborating to suggest, develop, design and write new solutions
- Own work across various DevOps tasks, managing cloud infrastructure in support of our data solutions
- Ensure 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
- Work in a friendly but assertive way with colleagues, suppliers and clients to get things done to our standard.
What you'll bring:
- 2-3 years of full-time Python and SQL experience
- Experience working in a media agency, or with media and marketing data (both digital and non-digital)
- Experience and understanding of how APIs extract data from various platforms
- Experience briefing, designing and implementing ETL solutions end-to-end, from requirements gathering through to deployment
- Experience with data orchestration tools (e.g. Airflow, Prefect) and building scalable data pipelines
- Strong Git and collaborative development skills (e.g. GitHub, GitLab)
- Strong understanding of data fundamentals: MDM, data integrity best practices, auditing processes, automated validation
- Cloud DevOps experience (e.g. Azure, GCP, AWS)
- Strong experience translating business and data needs into technical requirements
- Ability to communicate technical concepts and requirements in non-technical language
- Back-end development for visualisation and dashboarding products (Power BI, Tableau, Datorama). Experience with Adverity would be extremely valuable.
Nice to have:
- Experience working with Linux VMs
- Shell scripting experience (e.g. bash, zsh)
- Creating or using Git hooks
- Continuous integration / continuous deployment tooling experience
- Basic awareness of platform costing and infrastructure trade-offs, so cost or infrastructure issues get caught early
- A creative eye for spotting and prototyping improvements to reporting and manual workflows, ideally backed by examples of processes you’ve streamlined.
Benefits
We provide an exciting, fast paced, people first environment that allows everyone to grow, learn and thrive. We work a 9-day fortnight, meaning staff have every other Friday off! 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
Social and Environmental Commitment
At What’s Possible Group, our mission is to build a group our people are proud of. Proud of what we deliver to clients. Proud of how we treat each other. Proud of our commitment to people, planet and profit. Having rolled out a What’s Possible University with learning modules & policies, including anti bribery & corruption, DE&I and code of ethics, our people have continuous personal development, and the group is continuously improving. We are dedicated to embedding social and environmental responsibility into every aspect of our business. You'll contribute to initiatives that promote social equity, diversity, and inclusion within our workplace and in the content we create, whilst actively supporting and promoting sustainable best practice by continuously working to minimise waste, prioritising eco-friendly suppliers, and promoting remote work to reduce carbon emissions.
Your role will include supporting these efforts by helping to implement green office practices, coordinating initiatives that enhance our corporate social responsibility, and ensuring our operations align with our values of sustainability and social responsibility.
Sound good to you? Then get in touch. 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.
Data Engineer in London employer: The Specialist Works
The Specialist Works is an exceptional employer that fosters a vibrant and collaborative work culture in West Malling, UK. With a strong emphasis on employee growth, we offer numerous opportunities for professional development and the chance to lead innovative campaigns in the dynamic field of Out-of-Home and Print Media. Join us to be part of a team that values creativity, encourages initiative, and rewards hard work.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in London
✨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 The Specialist Works!
✨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 The Specialist Works.
✨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 The Specialist Works.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at The Specialist Works, 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 in London
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 The Specialist Works, 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 The Specialist Works. 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 The Specialist Works
✨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 The Specialist Works!
✨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.
