Data Engineer

Position: Data Engineer
Job Reference: West Berkshire
Location: Newbury, RG14 5LD (Hybrid: 2 days per week in office)
Contract Type: 3-months initial contract
Hours: 35-37 hours per week, Monday-Friday, standard business hours
Pay Rate: £271.57 per day (PAYE)

We are seeking a skilled Data Engineer with strong system integration expertise to ensure reliable, well-structured, and trusted data flows between systems. The role involves implementing platform enhancements, managing operational processes, and delivering system and database customisations across SQL Server, QTC/Unit4 environments, and system-to-system migration assessments. The successful candidate will play a key role in enabling analytics, reporting, and digital services by maintaining high-quality, secure, and accessible data.

Key Responsibilities

• Implement and maintain SQL Server-based data solutions, ensuring performance, reliability, and scalability.
• Develop, maintain, and monitor ETL/ELT workflows, including incremental loads, CDC, SCDs, and error-handling mechanisms.
• Support system integrations and migrations, including QTC/Unit4 platforms.
• Provide operational support and troubleshooting for production systems.
• Design, document, and implement technical solutions, adhering to best practices in data modelling and architecture.
• Ensure data governance, cataloguing, lineage, and metadata management are followed.
• Collaborate with business analysts and stakeholders to translate requirements into technical solutions.
• Optimise SQL Server performance, including indexing, execution plans, partitioning, and tempdb usage.

Essential Skills & Experience

• 3-5 years' experience with Microsoft SQL Server 2016+ and SSIS in production environments.
• Minimum 3 years' experience in applications support and maintenance.
• Minimum 3 years' experience in business analysis, technical design, and documentation.
• At least 3 years' experience with the full project management life cycle.
• Strong knowledge of data governance, metadata, cataloguing, and data lineage principles.
• Proficiency in SQL Server Agent, SSIS logging, SSISDB deployment, and workflow orchestration.
• Proven experience with ETL/ELT design patterns, including incremental loads, CDC, SCD, error handling, and idempotency.
• Advanced data modelling skills (Kimball, dimensional, relational).
• Strong SQL Server engineering skills, including advanced T-SQL, indexing, performance tuning, execution plans, statistics, partitioning, and tempdb optimisation.

How to Apply

• Quote the Job Title and Reference Number in your application.
• Submit your CV in Word format.
• Applications are reviewed on a rolling basis-early submission is recommended.

We will also add your details to our mail out lists. Please note you may receive details of roles outside of your immediate vicinity, as many candidates are able to relocate temporarily for work. Please disregard any such emails that are not of interest and let us know if you would rather not receive such mailouts and/or if you wish us to delete your details and prefer to apply direct to our advertised roles.

If you do not hear from us within three working days, unfortunately your application has not been shortlisted on this occasion. Thank you for your interest in working with us.

Qualification details and any other experience/skills relevant to the role to help support your application should be clearly shown in your CV.