Pentaho Engineer

Pentaho Engineer - Inside IR35 - SC Cleared

One of our leading clients is looking for a Pentaho Engineer who will design, develop, and maintain ETL (Extract, Transform, Load) workflows and data integration solutions using Pentaho Data Integration (PDI). This role focuses on ensuring the accuracy, scalability, and performance of data pipelines that support analytics, reporting, and Business Intelligence initiatives.

Key Responsibilities:

• Design, develop, and optimize ETL workflows using Pentaho Data Integration (PDI).
• Integrate data from multiple heterogeneous sources such as databases, APIs, flat files, and cloud platforms.
• Implement data transformation, cleansing, and validation processes.
• Collaborate with data analysts, BI developers, and data architects to understand data requirements.
• Troubleshoot and resolve issues in ETL jobs, ensuring data accuracy and integrity.
• Automate and schedule Pentaho jobs using Carte, Kitchen, or Pan scripts.
• Optimize performance of ETL jobs and SQL queries.
• Participate in data modelling and data warehouse design discussions.
• Support deployment of Pentaho solutions in production environments.
• Create and maintain documentation for ETL processes and data flows.

Required Skills and Experience

• Hands-on experience with Pentaho Data Integration (PDI/Kettle).
• Strong proficiency in SQL (MySQL, PostgreSQL, Oracle, SQL Server, etc.).
• Experience with data warehousing concepts (star schema, dimension modelling).
• Familiarity with ETL performance tuning and error handling techniques.
• Experience working with Linux/Unix environments and Shell Scripting.
• Understanding of REST/SOAP APIs, JSON, XML, and flat file processing.
• Version control experience (eg, Git, SVN).
• Solid analytical and problem-solving skills.
• Experience with big data platforms (eg, Hadoop, Spark) or cloud ETL tools (AWS Glue, Azure Data Factory, etc.).
• Knowledge of BI tools (eg, Pentaho BA Server, Tableau, Power BI).
• Familiarity with data governance, metadata management, and data quality frameworks.
• Experience with Python or Java Scripting for ETL customization.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.

If you are looking for your next contract, contact me on the details below.