This is a Senior Data Engineer role with KINESSO Australia based in Sydney, NSW, AU KINESSO Australia Role Seniority - senior More about the Senior Data Engineer role at KINESSO Australia About KINESSO 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. Why join KINESSO? 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. Before we jump into the responsibilities of the role. No matter what you come in knowing, you’ll be learning new things all the time and the KINESSO Australia team will be there to support your growth. Please consider applying even if you don't meet 100% of what’s outlined Key Responsibilities Creating and maintaining data pipelines Engaging with stakeholders Mentoring team members Key Strengths Python SQL ☁️ Cloud data warehousing Data pipeline creation Data cleansing Project management A Final Note: This is a role with KINESSO Australia not with Hatch.
