Pentaho Consultant

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

Job Role

We are seeking an experienced Pentaho / Denodo Developer to support the delivery of a complex data and analytics solution within a secure UK public sector environment.The role will focus on building and maintaining data integration, transformation and access processes across a multi-technology data platform. Strong experience with Pentaho, Denodo, SQL and relational databases is highly desirable.Due to the nature of the engagement, candidates must hold active UK Security Clearance.

Key Responsibilities

• Design, develop and maintain ETL and data integration pipelines.
• Develop Pentaho jobs and transformations to ingest, cleanse, transform and move data between source and target systems.
• Develop and maintain Denodo data virtualisation components and data access layers.
• Integrate data from multiple internal and external source systems.
• Work with Oracle and other relational databases to query, transform and persist data.
• Develop and maintain SQL used within data processing and integration workflows.
• Support scheduled and batch processing using Cron and other orchestration technologies.
• Work closely with SAS and data engineering teams to integrate upstream and downstream processing.
• Translate data and technical requirements into robust integration solutions.
• Analyse source data structures and support data mapping and transformation design.
• Implement appropriate data quality checks and error-handling processes.
• Troubleshoot data integration, performance and processing issues.
• Support testing, defect resolution and deployment activities.
• Produce clear technical documentation covering data flows, transformation logic and operational processes.
• Participate in code reviews and knowledge transfer across the delivery team.

Key Requirements

• Active UK Security Clearance.
• Proven hands-on experience developing data integration or ETL solutions.
• Experience working with relational databases such as Oracle.
• Experience designing and developing complex data transformations.
• Good understanding of data integration, data quality and data management principles.
• Experience working with large or complex datasets.
• Strong analytical and troubleshooting skills.
• Ability to understand technical and data requirements and translate them into working solutions.
• Experience working within structured software or data delivery projects.
• Ability to work effectively both independently and within a multidisciplinary technical team.
• Strong technical documentation and communication skills.
• Ability and willingness to learn adjacent technologies where required.

Nice to Have

• Experience with data virtualisation concepts and technologies.
• Experience delivering data and analytics solutions within UK Government.
• Experience with Cron or other scheduling technologies.
• Experience with Airflow or other workflow orchestration tools.
• Experience with SAS or SAS Viya.
• Experience integrating Pentaho with SAS-based processing.
• Oracle performance tuning or advanced SQL experience.
• Experience with fraud, compliance, risk or rules-based decisioning solutions.
• Experience with Git and modern source-control / CI/CD practices.
• Experience working within Agile delivery environments.