ETL Engineer (Analytics Engineering focus)

We are looking for an ETL Engineer with a strong analytics engineering focus to work within our FlightDeck infrastructure, ensuring data is arriving reliably, well-modelled, and analysis-ready for planners, strategists and clients. You will be responsible for maintaining and configuring data pipelines in our ETL tool, owning transformations, data models and metric definitions, and ensuring data can be confidently used across the agency.

In this role, you'll live our values day to day - thinking freely to solve complex data challenges, staying smart by building robust, scalable and well-governed pipelines, and aiming higher by continuously improving how data powers decision-making across the agency. You'll get involved by working closely with planners, strategists and clients, translating technical complexity into practical solutions, and you'll win together by collaborating openly with the wider FlightDeck and TKF team to deliver work we're proud of.

Your role

• Maintain and evolve core databases and data pipelines, ensuring data quality, consistency and trust
• Build and manage API integrations, working closely with Adverity on new developments
• Deliver measurement and data integration projects within FlightDeck, from ingestion through to analysis-ready outputs
• Own and resolve complex technical support queries
• Translate high-level briefs into clear, usable data solutions, including data models and definitions that scale across clients
• Work directly with clients and internal teams to understand data needs and turn them into practical, scalable implementations, We're immensely proud of the vibrant culture at The Kite Factory. Our commitment to continuous improvement is reflected in our quarterly pulse surveys, which create a valuable feedback loop, allowing us to evolve and refine our agency's operations. Here, every voice is heard and valued. We've diligently built and embodied our core values: Think Freely, Aim Higher, Stay Smart, Get Involved, and Win Together .

Our people are our greatest asset, and the connections they forge with one another are the foundation of our success. To strengthen these relationships and foster a supportive and inclusive environment, we offer several committees that everyone is encouraged to join, including Social, Diversity & Inclusion, and Environmental Impact. These groups play a crucial role in shaping our culture and ensuring that we not only work together but thrive together., To all recruitment agencies: The Kite Factory does not accept speculative agency resumes. Please do not forward resumes to our people alias, The Kite Factory employees or any other company location. The Kite Factory is not responsible for any fees related to unsolicited resumes. We will only accept CV's from the partners with relevant agreement via the People and relevant teams only.

• 3 Years experience in a commercial environment
• ETL of Advertising data
• SQL Server database management - including schema design, optimisation and maintenance beyond querying
• Working knowledge of scripting
• Experience shaping data so it can be consistently used in reporting, dashboards and analysis
• Online data visualization platforms
• An individual who is hands-on, pragmatic, and stakeholder-aware

As well as working with some of the best people in the industry, we offer a competitive salary, a range of benefits, a huge focus on training and development with dedicated training time, partnerships with industry specialists, and the opportunity to progress and develop your career with the support of a fantastic team.

We're The Kite Factory, an independent media agency that fuses Heart, Art, and Science to craft creative media ideas that deliver . We're here because we spotted a gap: too many agencies focus either on bold ideas or on measurement, but rarely both. We believe the magic happens when you bring them together. Smart, strategic, and creative media that doesn't just look good on paper but delivers in the real world. Our roots are in measurement, but our craft is in turning insight into action. That's how we drive real results for ambitious commercial and third sector organisations like White Claw, Skin+Me, WaterAid, Lovehoney, David Lloyd Clubs, Triodos Bank, and Little Freddie. We're now over 100 specialists strong - strategists, planners, creatives, and data geeks, united by curiosity, craft, and a passion for growth - yours, ours, and our clients'. In the past five years, we've grown fast, winning major clients and industry accolades including Campaign's Independent Agency of the Year 2024 and Sunday Times Best Places to Work 2024 and 2025 . People love working here, and it shows. We're proud to hold IPA Platinum status and be consistently named a Campaign Best Place to Work.