In detailThe Goodstuff Data Scientist is responsible for extracting, transforming and loading data (ETL) to support data warehousing, visualisation and automation. Using a broad range of coding languages, ingestion methods and datasets, you will help Goodstuff make better, faster decisions with data.You’ll work with a range of internal stakeholders and have exposure to clients, supporting both day-to-day delivery and internal innovation projects. You’ll be expected to develop an understanding of media and marketing channels, and to become a go-to person for data processing and infrastructure across the business.Reporting to Chief Digital, Data and Technology Officer.Use an analytical mindset to scope, design and document data to power AI and machine learningHelp to build and maintain robust data pipelines, including scheduling, monitoring refreshes, troubleshooting failures and ensuring outputs are formatted correctly to support automation, modelling and AI toolsDevelop efficient, readable and structured code (e.g. SQL and other languages) to process data when briefed, with an eye on reuse, scalability and error-handling, including for AI and ML-driven workflowsGet to grips with the key tools and systems for the role – including bespoke internal platforms and R-Studio, Power BI, Looker Studio, SQL, Mediaocean, and SMIBuild a strong understanding of how media data flows from research → planning → delivery → evaluation, and how Data Science, machine learning and AI techniques can support planning, optimisation and measurementApply data quality best practice: running validation checks and reconciling data across sources and support the creation of clear, intuitive data visualisations and dashboards that make complex datasets easy to understandWork with internal teams to ensure data handling is secure and compliant, escalating any risks or issues, especially in the context of AI, automation and model governanceLearn to manage data flows, working with internal and external stakeholders to ensure timely and accurate delivery of projectsDevelop strong relationships with internal teams and wider network agencies to support with analysis and reporting on projects to realise our data ambitionsWork with client to scope data needs and clarify requirementsBuild strong relationships with internal teams to understand how data will be used to shape efficient data solutions within agreed deadlinesImprove efficiency in data manipulation, automation and reporting through robust, reusable solutionsSeek to improve our products and services by flagging opportunities where better data processes can drive valueSupport a culture of learning and development by providing coaching in Excel and core data skillsEnsure accurate and consistent weekly completion of timesheetsThe requirementsStrong analytical and numerical abilityConfidence in ETL techniques encompassing multiple sourcesHigh levels of organisation and excellent attention to detailA confident, committed and professional approachSelf-sufficiency and the ability to prioritise workloads, with good judgement on when and how to seek wider team supportThe ability to distil complex data set-ups into simple, clear routes to solutions for a range of stakeholdersExperienced in SQL and passionate about AI and its scope for development. Media experience an advantage but not essentialPassionate to be an internal advocate for data and automation· A strong team orientation and a proactive self-starterEffective time-management and the ability to work across multiple workstreams at onceThe ability to think around problems and arrive at inventive solutions, asking relevant questionsMade of different stuffGoodstuffers are a group of individuals made of different stuff. Collectively we shine in support of our mission: to be the World’s most inventive media agency. Our invention is born out of divergent thinking in an inclusive environment which comes together to create something truly original and good. Truly Goodstuff.To support this, we have an Equal Opportunities Policy; except we call ours the Do the Right Thing Policy. It’s simple. We believe in fairness. That means, first and foremost, we recruit on merit and ability. We treat each other, fairly, with dignity and respect – we give a shit. We create an inclusive environment in which everyone belongs. When we recruit, promote, train, or reward we do that on the basis of aptitude and ability. We help and encourage everyone at Goodstuff to realise their full potential.Any form of discrimination or harassment, less favourable treatment, or victimisation based on age, disability, gender reassignment, marriage and civil partnership status, pregnancy and maternity, race, religion or belief, sex, or sexual orientation will not be tolerated.