Senior Pentaho & Denodo Data Integration Engineer

ISx4 Group; United Kingdom; Remote; GBP 65,000 - 90,000; Full time

Job summary

ISx4 Group is seeking an experienced Pentaho/Denodo Developer to support a complex data analytics solution in a secure UK public sector environment. You will build and maintain data pipelines, virtualization components and data access layers across a multi-technology platform.

The role requires active UK Security Clearance and hands-on experience with ETL, SQL and Oracle databases, with emphasis on robust integration design and data quality controls.

Qualifications

• Active UK Security Clearance required.
• Hands-on experience with ETL and data integration solutions.
• Experience with relational databases (Oracle).
• Ability to design complex data transformations and mappings.
• Understanding of data quality and data management principles.
• Experience handling large or complex datasets.
• Strong analytical and troubleshooting skills.
• Ability to translate requirements into robust integration solutions.

Responsibilities

• Design, develop and maintain ETL and data integration pipelines.
• Develop Pentaho jobs and transformations for data ingestion and cleansing.
• Develop Denodo data virtualization components and data access layers.
• Integrate data from multiple internal and external sources.
• Query, transform and persist data using Oracle and other relational databases.
• Develop and maintain SQL used in data processing workflows.
• Support scheduled and batch processing using Cron and orchestration tools.
• Collaborate with SAS and data engineering teams on upstream/downstream processing.
• Translate data requirements into robust integration solutions.
• Analyse source data structures and support data mapping and transformation design.
• Implement data quality checks and error-handling processes.
• Troubleshoot data integration, performance and processing issues.
• Support testing, defect resolution and deployment activities.
• Produce technical documentation covering data flows and logic.
• Participate in code reviews and knowledge transfer.

Skills

ETL development

Data integration

SQL

Data quality

Analytical skills

Technical documentation

Troubleshooting

Team collaboration

Tools

Pentaho

Denodo

Oracle

Cron

Airflow

Git

CI/CD

SAS

Job description

ISx4 Group is seeking an experienced Pentaho/Denodo Developer to support a complex data analytics solution in a secure UK public sector environment. You will build and maintain data pipelines, virtualization components and data access layers across a multi-technology platform.

The role requires active UK Security Clearance and hands-on experience with ETL, SQL and Oracle databases, with emphasis on robust integration design and data quality controls.