Lead Data Platform Engineer

Dyson’s Global IT is on a mission to pivot to in-house capabilities and become the go-to internal technology solutions partner, driven by Global IT's Innovation & Technology (CITO) team. We focus on streamlining IT efficiency and nurturing a culture of innovation, leveraging the promises of data and emerging technologies while ensuring a steadfast commitment to security, compliance, and resilience. Our goal is to not only meet but exceed the changing needs of our business and customers, and guide the organization in using these technologies to their maximum potential. 

The Data Platform Team architects, develops, and maintains Dyson’s data backbone. We specialise in building advanced SQL-based solutions, robust ETL pipelines, and managing seamless data movement across both legacy and cutting-edge systems. From daily data operations to strategic migrations, our team keeps Dyson’s data accurate, fast, and reliable for business users around the world.

Key Responsibilities

• Lead, design, and maintain complex SQL solutions for ETL, data integration, and migration projects.
• Build and optimise SSIS packages and manage SAP BODS jobs for enterprise-scale data operations.
• Oversee end-to-end migration activities, including data profiling, mapping, SQL query optimisation, testing, and go-live support.
• Working knowledge of using tools like Fivetran and Google Cloud Composer.
• Work closely with business and IT teams to translate integration and reporting requirements into SQL and ETL solutions.
• Leverage Google BigQuery, Dbt and SAP Datasphere for cloud-based analytics and advanced data integration.
• Monitor, troubleshoot, and tune SQL queries and ETL workflows for maximum efficiency and accuracy.
• Document processes and enforce data quality, governance, and security standards throughout all data activities.
• Mentor and support a team of data engineers, championing best practices in SQL, ETL, and data management.

Qualifications & Experience

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• K6–7 years of hands-on experience working with SQL Server (T-SQL), ETL development, and large-scale data migrations.
• Deep experience designing, tuning, and troubleshooting SQL queries and stored procedures.
• Strong experience with Microsoft SSIS, SAP BODS, and data migration tools and frameworks.
• Practical skills with data integration and orchestration platforms such as Fivetran and Google Cloud Composer.
• Experience with Google BigQuery for advanced analytics and data warehousing.
• Familiarity with SAP Datasphere and SAP data integration.
• Proven ability to manage and deliver complex SQL and data migration projects.
• Comprehensive understanding of data governance, security, and compliance.
• Excellent communication, documentation, and stakeholder management skills.

Nice to Have

• Experience with Python or other scripting languages in a data engineering context.
• Familiarity with additional cloud data platforms or BI/reporting tools.
• Involvement in large-scale data transformation or SAP system upgrade projects.

Dyson is an equal opportunity employer. We know that great minds don’t think alike, and it takes all kinds of minds to make our technology so unique. We welcome applications from all backgrounds and employment decisions are made without regard to race, colour, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other any other dimension of diversity.