We are seeking a Senior Data Engineer with deep expertise in SQL, data modelling, and ETL development, alongside strong experience with modern data platforms and business intelligence tools. The ideal candidate will have a proven track record of designing, building, and maintaining scalable data solutions, including enterprise-grade data warehouses, while ensuring data integrity and enabling advanced analytics across the organisation.
This role is suited to an experienced professional who can take ownership of data architecture, mentor junior team members, and drive best practices in data engineering within a collaborative IT environment.
Key Responsibilities:
- Design, develop, and maintain robust, scalable ETL/ELT pipelines to integrate data from multiple systems into centralised data platforms.
- Lead the design, implementation, and ongoing maintenance of data warehouses and data lake architectures.
- Develop and optimise complex SQL queries, stored procedures, and data models to support reporting, analytics, and operational use cases.
- Define and enforce data modelling standards (e.g., dimensional modelling, star/snowflake schemas).
- Collaborate with software engineers, analysts, and business stakeholders to translate requirements into reliable and performant data solutions.
- Oversee data integration processes, ensuring high performance, reliability, and security across all pipelines.
- Implement and champion data quality, validation, and governance frameworks.
- Support and optimise datasets for BI tools such as Power BI, ensuring efficient and scalable reporting solutions.
- Work closely with IT and Infrastructure teams to design secure, scalable, and cost-effective data environments.
- Mentor and support junior data engineers, promoting best practices and continuous improvement.