Senior Data Engineer

This is an exciting opportunity for an experienced Data Engineer with strong SQL and Python skills to work with modern cloud data technologies, contribute to our engineering standards and play a part in delivering and evolving PHMG’s Data Strategy.

What you will do:

• Design, build and maintain scalable, reliable and maintainable data pipelines and datasets.
• Play a key role in developing and improving our Microsoft Fabric data platform.
• Take ownership of complex data engineering solutions from design through to production.
• Contribute to technical design and architecture decisions across data warehouse, lakehouse and data integration solutions.
• Champion strong engineering practices across source control, CI/CD, testing, documentation, monitoring and error handling.
• Work with other Data Engineers to improve data architecture, platform performance and engineering processes, providing technical guidance and mentoring where required.
• Work closely with the business to understand requirements and deliver effective data solutions., The Data Engineering team sits within PHMG’s wider Data function and is responsible for building and maintaining the platforms, pipelines and data models that underpin reporting, analytics and data science across the organisation.

The team works closely with Reporting & Insights, Data Science, IT and other business teams to make data reliable, accessible and useful across the business. We are continuing to strengthen our engineering practices, improve our platform and build greater resilience and consistency across the data estate.

The person we are looking for will have the following experience:

• Strong SQL and Python skills, with practical experience using both for data engineering and transformation.
• Significant experience designing, building and supporting production data pipelines using modern ETL/ELT practices.
• Experience working with modern cloud data platforms and orchestration technologies. Experience within the Microsoft data ecosystem would be advantageous.
• Strong data modelling experience, including dimensional modelling and designing datasets for downstream consumption.
• Experience with modern engineering practices including Git-based source control, CI/CD, testing, monitoring and error handling.
• Experience taking ownership of complex technical solutions and contributing to architecture and design decisions.
• Strong analytical and problem-solving skills.
• Experience supporting or mentoring other engineers and working effectively within cross-functional teams.

Nice-to-have experience:

• Microsoft Fabric, including Lakehouse, Warehouse, and Data Factory capabilities.
• Dbt, including experience developing, testing and maintaining transformation models.
• Infrastructure as Code approaches and tools such as Terraform.
• API-based, event-driven or operational system integrations, such as Salesforce.

PHMG is continuing to develop and mature its data capability, focusing on modernising our data platform and enhancing the way we work. As part of this continued development, we are looking to strengthen our Data Engineering team and maximise the value from the wealth of data held across the organisation., Established in 1998, PHMG has grown from a renowned Manchester-based business to the world’s leading audio branding agency - working with 36,000 clients in 54 countries across the globe. This expansive client list includes household names of the calibre of Samsung, Audi and Adidas, as well as SMEs in every sector of the global market. We give each of them a stellar production that combines creative copy, world-class voice artistry and an exclusive Brand-Sound-Track - strengthening their business identity in the most memorable, emotive way.