Location: Warwick (Hybrid Working)
Contract: Initial 6 Months
Pay Rate: £550 - £650 (Umbrella)
Role Overview
Our client is seeking a hands-on Senior Data Engineer with deep experience in enterprise data warehousing and data integration. This role is focused on designing and building robust, scalable data warehouse solutions, with a strong emphasis on practical implementation and real-world delivery, not just theoretical knowledge.
You will play a key role in shaping and delivering high-quality data models, ETL/ELT pipelines, and integration patterns, working closely with architects and analysts to enable reliable and performant analytics across the organisation.
Key Responsibilities
Lead the design, development, and maintenance of large-scale data systems, including data warehouses, data lakes, and pipelines.
Design, develop, and maintain ETL/ELT processes utilising tools such as Matillion.
Create and maintain optimal data flows and data pipeline architectures.
Create and implement semantic data models, including fact and dimension tables.
Own the end-to-end data lifecycle: extraction, transformation, validation, and loading
Develop and manage data warehouse objects, including tables, views, and security roles in Snowflake.
Extract data from diverse sources, including databases, flat files, and APIs.
Transform and cleanse data to ensure quality and integrity.
Load data into the data warehouse while ensuring consistency and accuracy.
optimise ETL processes for performance, scalability, and reliability.
Implement data validation, quality checks, and security measures.
Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures.
Implement best practises for data warehousing, data modelling, and ETL development.
Document ETL processes, data mappings, and configurations.
Collaborate closely with data architects, analysts, and developers to support data integration initiatives.
Requirements
Experience with relational databases, ETL/ELT, and data warehousing.
Expertise in ETL/ELT tools such as Informatica, ODI, Matillion, or SSIS.
Experience with cloud-based data platforms like Snowflake.
Proven experience in designing and developing complex near real-time and/or batch data integration solutions.
Familiarity with both traditional and non-traditional analytical data design methodologies (e.g., Kimball, Inmon).
Strong SQL programming skills and a solid understanding of relational database concepts.
Experience in loading and maintaining enterprise data warehouse environments.Nice to Have
Experience working with finance data or within financial services environments.
Familiarity with SAP systems and databases.
Knowledge of data visualisation tools such as Power BI or Tableau.If you're passionate about data engineering and meet the above criteria, we would love to hear from you. Join our client and play a pivotal role in enhancing their data infrastructure and analytics capabilities. Apply today!
Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.
Please be advised: if you haven't heard from us within 48 hours, then unfortunately your application has not been successful on this occasion. We may, however, keep your details on file for any suitable future vacancies and contact you accordingly.
We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention
Salary description
£550.00 - £650.00 per day