ZipRecruiter

Log In

1

Pentaho Data Integration Jobs in Michigan (NOW HIRING)

Western Michigan University

IT Data Engineer

Kalamazoo, MI · On-site

$65K - $76K/yr

Develop and manage ETL processes using tools such as Pentaho and Microsoft SSIS, ensuring reliability and performance * Design and implement data models and schemas to support downstream analytics ...

All JobsPentaho Data Integration JobsPentaho Data Integration Jobs in Michigan

Pentaho Data Integration information

What is a Pentaho Data Integration?

A Pentaho Data Integration (PDI) job involves designing, developing, and managing ETL (Extract, Transform, Load) processes using the Pentaho Data Integration tool. Professionals in this role work with data pipelines to extract data from various sources, transform it into a usable format, and load it into databases or data warehouses. They ensure data quality, optimize performance, and automate workflows to support business intelligence and analytics initiatives.

What are the key skills and qualifications needed to thrive in the Pentaho Data Integration position?

To thrive as a Pentaho Data Integration specialist, you need strong skills in ETL (Extract, Transform, Load) processes, data modeling, and database management, typically supported by a degree in computer science or a related field. Expertise in using Pentaho Data Integration (PDI), SQL, and familiarity with other data warehousing tools or certifications is highly valued. Analytical thinking, problem-solving, and effective communication are essential soft skills that help in understanding business requirements and collaborating with cross-functional teams. These capabilities are crucial for efficiently designing, implementing, and maintaining robust data integration solutions that drive business intelligence and decision-making.

What are some common challenges faced by Pentaho Data Integration professionals in their daily work?

Pentaho Data Integration professionals often encounter challenges such as managing large and complex data sets from diverse sources, ensuring data quality and consistency, and optimizing ETL workflows for performance. They may also need to troubleshoot issues related to data transformation, connectivity, and integration with other enterprise systems. Working collaboratively with business analysts, data architects, and IT teams is essential to align technical solutions with business requirements. Overcoming these challenges requires a strong understanding of both the technical tools and the business context, as well as adaptability to evolving project needs.

What are popular job titles related to Pentaho Data Integration jobs in Michigan?

For Pentaho Data Integration jobs in Michigan, the most frequently searched job titles are:

What job categories do people searching Pentaho Data Integration jobs in Michigan look for?

The top searched job categories for Pentaho Data Integration jobs in Michigan are:

Pentaho Data Integration jobs near you
Infographic showing various Pentaho Data Integration job openings in Michigan as of August 2026, with employment types broken down into 1% As Needed, 82% Full Time, 12% Part Time, 4% Contract, and 1% Nights. Highlights an 86% Physical, 3% Hybrid, and 11% Remote job distribution.

IT Data Engineer

Western Michigan University

Kalamazoo, MI • On-site

$65K - $76K/yr

Full-time

Medical, Retirement, PTO

Re-posted 29 days ago

Western Michigan University rating

6.7

Company rating: 6.7 out of 10

Based on 30 frontline employees who took The Breakroom Quiz

492nd of 628 rated colleges and universities

Job description

Description
The Data Engineer is responsible for designing, building, and maintaining the organization's data
infrastructure to support a scalable, governed, and analytics-ready environment. This role focuses on the
development of robust data pipelines, integration of disparate data sources, and optimization of data storage
and processing frameworks, while contributing to the evolution of the WMed data platform toward a data-asa-
service (DaaS) model that enables standardized, secure, and reusable access to trusted data assets
across clinical operations, medical education, research, compliance, and executive decision-making.
Working within a modern data architecture, the Data Engineer transforms fragmented, system-centric data
into structured, reliable, and accessible datasets. This role partners closely with analysts, stakeholders, and
technical teams to ensure data availability, integrity, and performance across platforms including partner
EHRs, academic systems, and enterprise applications.
Please Note this is a Salaried Hybrid Position that will require on-site attendance. (MI residents only or willing to relocate - at their expense, to Michigan)
This position is NOT eligible for employer-sponsored work authorization (visa sponsorship), now or in the future.
BENEFITS
  • Wellness reimbursement.
  • Continuing education and tuition reimbursement.
  • Employer-funded retirement plan.
  • Two medical plan options: PPO and High Deductible Health Plan (HDHP) with employer HSA contribution.
  • Flexible work solutions based on position and department.
  • Up to four weeks of PTO accrual beginning in year one.
  • Paid holidays.
  • Paid volunteer time.
  • Paid preferred holiday.

DUTIES AND RESPONSIBILITIES:
  • Design, build, and maintain scalable data pipelines to ingest, transform, and load data from clinical, academic, and enterprise systems
  • Develop and manage ETL processes using tools such as Pentaho and Microsoft SSIS, ensuring reliability and performance
  • Design and implement data models and schemas to support downstream analytics and reporting use cases
  • Contribute to the development of a DaaS platform, enabling reusable, governed data products and standardized access patterns for analysts, applications, and self-service users
  • Optimize and maintain PostgreSQL data environments, including performance tuning and storage strategies
  • Implement and monitor data quality, validation, and error-handling processes
  • Establish and maintain data lineage, metadata, and documentation to support governance and transparency
  • Integrate new data sources into the data platform, including APIs, flat files, and third-party systems
  • Troubleshoot and resolve data issues across the full data lifecycle
  • Support the evolution of organizational data architecture toward a modern, scalable platform
  • Contribute to standards, best practices, and governance frameworks for data engineering
  • All other duties as assigned

Requirements
To perform this job successfully, an individual must be able to perform each duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
EDUCATION AND/OR EXPERIENCE:
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related technical field (or equivalent experience).
  • 3 to 5 years of experience in data engineering, ETL development, or data platform engineering.
  • Advanced proficiency in SQL (PostgreSQL or similar relational databases).
  • Experience designing and managing data pipelines and workflows (Pentaho, Microsoft SSIS, or similar ETL tools).
  • Experience working with healthcare data systems preferred.
  • Experience integrating academic and enterprise systems preferred.

OTHER SKILLS AND ABILITIES:
  • Strong understanding of data architecture, data modeling, and data warehousing concepts.
  • Experience building and maintaining data pipelines (ETL), orchestration, and scheduling frameworks.
  • Knowledge of data warehousing and/or data lake architectures.
  • Experience with data quality frameworks, validation, and monitoring.
  • Familiarity with performance tuning and query optimization.
  • Familiarity with modern data platform concepts including DaaS and self-service analytics enablement.
  • Understanding of data governance, lineage, and metadata management concepts.
  • Experience working with structured and semi-structured data (CSV, JSON, APIs).
  • Ability to troubleshoot data issues across multiple systems and layers (source to pipeline to warehouse to reporting).
  • Experience with BI tools (Power BI or similar) for downstream data consumption.
  • Ability to learn and adapt to evolving data technologies and platforms.

What Western Michigan University employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom

Apply