Senior Data Engineer

IntaPeople: STEM Recruitment; Newport; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

25 days annual leave

Free parking on-site

Bonus Scheme

Private Medical Healthcare

Group Life Insurance

Employee Assistance Programme

Cycle to Work Scheme

Enhanced Maternity & Paternity

Performance and Development Framework

Long service awards

Job summary

IntaPeople is seeking an experienced Data Engineer for a South Wales client in a finance-focused environment. The role focuses on transforming reporting-led processes into insight-driven decisions, building robust data pipelines, and enabling self-service analytics at scale.

You will work within a small Data/BI team, leveraging Kimball modelling, Microsoft stack tools, and best practices to deliver high-quality data products and support reporting needs across the business.

Qualifications

• Experience delivering scalable data solutions in a business environment.
• Strong SQL and transformation logic in a data warehouse setting.
• Proven ability to design and maintain ETL pipelines and data integration processes.

Responsibilities

• Design, build, and maintain scalable data pipelines from multiple sources.
• Develop and optimise the data warehouse as a single trusted data source.
• Automate data flows to reduce manual processing and improve efficiency.
• Implement data quality checks, monitoring, and validation processes.

Skills

SQL

ETL pipelines

Data warehousing

Kimball modelling

Azure Data Factory

Azure Synapse

SQL Server

Microsoft Fabric

Data quality

BI collaboration

Tools

SQL Server

Azure Data Factory

Azure Synapse

Microsoft Fabric

Job description

IntaPeople are seeking an experienced Data Engineer to join one of their financial services focussed clients based in South Wales. This role is critical to transforming a reporting-led organisation into a proactive, insight-driven business. The Data Engineer will be responsible for developing robust data engineering solutions that reduce manual processes, improve data quality, and enable self-service analytics at scale.

You will have strong experience in data architecture, ETL development, and modern data warehousing practices, including the application of Kimball methodology and dimensional modelling, alongside a proven track record of building reliable, high-performance data solutions in a business-focused environment.

This is a newly created role within the Data Engineering function due to growth and forward planning. You will join a small Data/BI team of 3 (soon to be 4) so being a Senior within the team will allow a large amount of responsibility and report directly into the ‘Head of Data’.

Technical Skills (at a glance)

• Proven experience in a Data Engineer or Senior Data Engineer role, delivering scalable data solutions in a business environment.
• Strong experience with SQL and transformation logic in a data warehousing environment.
• Experience designing and maintaining ETL pipelines and data integration processes.
• Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling).
• Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric, or similar).
• Experience working with structured data from multiple operational systems.
• Strong understanding of data quality, governance, and best practices for managing trusted data assets.
• Experience working closely with BI/analytics teams to support reporting and insight delivery.
• Strong problem-solving skills with the ability to diagnose and resolve data issues quickly and effectively

Key Responsibilities (but not limited to)

• Design, build, and maintain scalable, robust data pipelines to ingest, transform, and deliver data from multiple source systems.
• Develop and optimise the enterprise data warehouse to provide a single, trusted source of data across the organisation.
• Reduce reliance on manual data processing by automating data flows, integrations, and transformations.
• Ensure data is accurate, consistent, and reliable through the implementation of data quality checks, monitoring, and validation processes.
• Work closely with BI, analytics, and business stakeholders to understand data requirements and enable high-quality reporting and insight.
• Support the transition to self-service analytics by ensuring data is structured, accessible, and well-governed.
• Design efficient, scalable data models that support both operational reporting and advanced analytics use cases.
• Improve performance, scalability, and cost-efficiency of data processes and infrastructure.Integrate new data sources (e.g. operational systems, third-party platforms) into the data platform in a consistent and governed manner.
• Establish and maintain best practices in data engineering, including documentation, version control, testing, and deployment processes.
• Collaborate with Technology and BI teams to align data architecture with overall system architecture and business strategy.
• Stay up to date with emerging data engineering tools, technologies, and best practices to continuously enhance the data capability.

Role overview at a glance

• Competitive Salary depending on experience – please enquire for more information
• Starting on 25 days annual leave per year
• Hybrid working – 2-3 days onsite - Newport
• Free parking on-site
• Bonus Scheme based on performance
• Private Medical Healthcare
• Group Life Insurance (4x basic annual salary)
• Employee Assistance Programme
• Cycle to Work Scheme
• Enhanced Maternity & Paternity Benefits
• Performance and Development Framework
• Long service awards.

This role is a hybrid role with a 3 days office requirement for collaboration, workshops and stakeholder meetings per week on-site in the Cardiff/Newport area (South Wales).

Please note we can not provide sponsorship to candidates who are not eligible to live and work within the UK without restriction.