Senior Data Engineer

KINESSO is the global technology-driven performance marketing agency that sits at the very heart of IPG Mediabrands, providing actionable growth for both our agency partners and clients. We turn ‘action' into ‘outcome' for our clients, leveraging our unique capabilities in optimization, analytics, AI and experimentation. KINESSO has brought together the collective power of what was formerly Matterkind, Reprise, and Kinesso under one collective entity that will serve as the most powerful delivery engine in the industry. The company has more than 6,000 employees operating in more than 60 countries. Learn more at www.KINESSO.com

The Role

The Senior Data Engineer is responsible for the creation and maintenance of ETL processes in and out of the data warehouse, data management and modelling, and Data as a Service product.

Practical experience with Python and SQL is essential for the role, as is a working knowledge of cloud computing and data warehousing concepts. A substantial portion of the role includes interacting with APIs, data pipeline creation, troubleshooting, data discovery, data modelling.

This role also requires the ability to think logically and critically to solve complex problems or build business rules using data, as well as the ability to work independently and proactively on projects from end-to-end. As part of a small, lean team, you will own and manage the entirety of the ETL process for a number of different pipelines, and need to manage and prioritise tasks accordingly.

Key Responsibilities

• Creation and maintenance of data pipelines from AdTech platforms
• Data cleansing - troubleshooting, fixing errors and identifying discrepancies in data when onboarding new sources.
• Engaging with internal and external stakeholders
• Working with BI Engineers and Data Scientists to confirm data quality.
• Provide input to project planning, status, and review meetings.
• Requirements gathering
• Query data using SQL including the creation of logical schemas and tables.
• Provide input to project planning, status, and review meetings.
• Mentor and grow team members.

About you

• 5+ years' experience in data engineering or equivalent role.
• Strong Python skills with proven experience
• Proven experience in building data warehouses and ETL workflows
• Knowledge of cloud data warehousing
• Experience with Airflow & Snowflake
• Experience manipulating and extracting data using SQL.
• Proactive, able to manage projects end-to-end and work independently
• Inquisitive, creative and a passion for data
• Ability to project manage and prioritise against multiple deadlines.
• A hybrid working model and incredible office culture. with opportunities for global transfers, internal secondments, and travel.
• Mentorship programs, learning modules and professional skills training to support your career ambitions.
• Wellness programs including access to an EAP and wellness coaching
• Agency perks, early finish Fridays, culture club, breakfast, health and wellbeing initiatives

We value unique backgrounds and experiences to encourage and celebrate diversity. First Nations people, those identifying as LGBTQ+, people of all ages, people with disabilities, and people who are culturally and linguistically diverse are encouraged to apply. Our aim is to create a workforce that reflects the community in which we live.