About the Role
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. You will have a significant say in our data product roadmap and its deployment, helping to shape the processes and tools used to drive efficiency.
Responsibilities
- Create, monitor, maintain, and optimize data pipelines within the TSW data ecosystem, primarily using Azure and the Adverity platform.
- Write SQL queries to generate bespoke reporting outputs.
- Troubleshoot code issues and implement changes to future-proof code.
- Collect information for new scopes, investigate new data sources, and devise business logic.
- Collaborate with the head of digital delivery to create bespoke marketing intelligence reports for clients.
- Bring together data from multiple sources to enable campaign activation and automation.
- Collaborate with internal stakeholders, suppliers, and clients to ensure correct data provision and adherence to data governance.
- Own delivery of new and existing ETL pipelines and data engineering projects.
- Work collaboratively with media teams and other business partners to ensure data availability and interpretability.
- Provide client-facing support with onboarding and troubleshooting for data solutions.
- Help shape the evolution of the data ecosystem, contributing to product design and architecture discussions.
- Suggest, develop, design, and write new solutions.
- Own work across various DevOps tasks, managing cloud infrastructure.
- Ensure adherence to data governance and data security best practices.
- Act as an internal champion for data solutions, encouraging adoption and supporting implementation.
- Work in a friendly but assertive manner with colleagues, suppliers, and clients.
- Support initiatives that promote social equity, diversity, and inclusion.
- Actively support and promote sustainable best practices.
- Help implement green office practices.
- Coordinate initiatives that enhance corporate social responsibility.
- Ensure operations align with values of sustainability and social responsibility.
Requirements
- 2-3 years of full-time Python and SQL experience.
- Experience working in a media agency, or with media and marketing data (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.
- 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 visualization and dashboarding products (Power BI, Tableau, Datorama).
- 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.
- A creative eye for spotting and prototyping improvements to reporting and manual workflows.
Skills
- Python
- SQL
- Azure
- Adverity platform
- Git
- GitHub
- GitLab
- MDM
- Power BI
- Tableau
- Datorama
- Linux VMs
- Shell scripting
- bash
- zsh
- Continuous integration
- Continuous deployment
Location
- UK
Work Type
- Full-time
- Remote
Experience Level
- 2-3 years
Benefits
- 9-day fortnight (every other Friday off)
- Benefits package investing in long-term personal and professional growth and wellbeing.
- Continuous personal development through learning modules and policies.
- Opportunities to contribute to social equity, diversity, and inclusion initiatives.
- Support for sustainable best practices and eco-friendly initiatives.
About the Company
- The Specialist Works is a media agency built exclusively for marketers at entrepreneurial brands that are past the start-up stage but not yet large corporates.
- Clients span large privately owned businesses (PE backed, founder-led) and small to mid-cap public enterprises.
- The company fosters an exciting, fast-paced, people-first environment that allows everyone to grow, learn, and thrive.
- Values include Passion, Inquisitiveness, Caring, and Knowledge.
- What's Possible Group's mission is to build a group people are proud of, focusing on client delivery, employee treatment, and commitment to people, planet, and profit.
- The group has implemented 'What's Possible University' with learning modules and policies.
- Dedicated to embedding social and environmental responsibility into every aspect of the business.
- Culture, creativity, and passion are powered by people, with diversity and difference driving innovation.
Equal Opportunity
- Diversity and difference drive innovation, not only for us but also for our clients and is at the heart of everything that we do.
