ETL Developer

Pentaho ETL developer

Job Family:

Travel Required:

Clearance Required:

What you will do

• Design, develop, and optimize ETL workflows using Pentaho Data Integration (PDI/Kettle) to extract, transform, and load data from various sources into target databases and data warehouses.
• Collaborate with business analysts and other team members to understand "Business", data requirements and translate them into effective ETL solutions.
• Develop and maintain robust and efficient SQL queries, stored procedures, and database objects to support ETL processes and data management needs.
• Assist in troubleshooting and resolving data quality issues and performance bottlenecks within ETL jobs and database systems.
• Work closely with report developers and other stakeholders to ensure data availability and accuracy for reporting and analytical purposes.
• Document ETL processes, data flows, and technical specifications for maintainability and knowledge sharing.
• Contribute to the continuous improvement of data integration processes and best practices.
• Work in Azure Datawarehouse solutions as a part of modernization
• Work on challenging and impactful data projects.

What You Will Need:

• Bachelor's degree in computer science, Information Technology, or any related field.
• 2-3 years of professional experience in ETL development, preferably with Pentaho Data Integration (PDI/Kettle).
• Strong understanding of relational databases and database concepts, including data modelling and SQL programming (e.g., writing complex queries, stored procedures).
• Familiarity with data warehousing concepts and principles.

What Would Be Nice To Have:

• Experience with Pentaho Business Analytics components (e.g., Pentaho Report Designer, Analyzer) for creating reports and dashboards.
• Exposure to other BI tools and platforms.
• Knowledge of scripting languages like Python or Java for advanced data manipulation or integration tasks.
• Familiarity with performance tuning techniques for databases and ETL processes.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

About Guidehouse

Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at or via email at All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including or Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse's Ethics Hotline. If you want to check the validity of correspondence you have received, please contact Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant's dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.