Job Title: ETL Engineer (Pentaho)
Job Location: Chicago, IL (onsite)
Job type: Contract
About Edify :
For 24 years, Edify has partnered with organizations to modernize, secure, and scale through cloud transformation, AI/ML, data analytics, and cybersecurity. Headquartered in Naperville, IL, we're a CMMI Level 3 and ISO 27001/9001/20000 certified digital transformation partner with deep platform expertise and proven delivery discipline. We deliver deep expertise across Salesforce, Palantir, ServiceNow, and MuleSoft, with specializations in intelligent APIs and integrations, platform engineering, adaptive analytics, intelligent process automation, cloud-native architecture, AI/data science, and quality engineering. From data governance and generative AI to digital workflows and agile delivery, we handle end-to-end transformation. Join Edify and work on high-impact engagements across today's most in-demand technologies, backed by nearly a quarter century of proven results and a team that gives your expertise room to grow.
Mandatory Skills & Qualifications :
Advanced SQL expertise with strong hands-on experience working with both OLTP and OLAP databases.
Proven experience in SQL query performance tuning, particularly when working with large datasets.
Strong hands-on experience with Pentaho Data Integration (PDI) and ETL development.
Scripting experience in PowerShell or Unix Shell scripting — experience with either one is mandatory.
Strong understanding of Unit Testing and Integration Testing, including performing data validation and reconciliation to ensure data accuracy and integrity.
Self-motivated and capable of working independently with minimal supervision.
Good to Have :
Working knowledge of Azure DevOps and/or GitHub.
Experience with Git-based source control and CI/CD practices.
Azure cloud experience is a strong plus.
Excellent communication and collaboration skills, with the ability to work effectively with IT, development, and data teams.
Strong team-player mindset with the ability to collaborate across technical teams.
We're Committed to Equal Opportunity & Inclusion
At Edify, We care about your skills, your curiosity, and your drive to solve hard problems. We actively recruit, develop, and promote talent across all backgrounds because diverse teams build better solutions. Our engineers, architects, and strategists come from different industries, geographies, and experiences and that's exactly why we're successful. You'll work in an environment where your ideas are heard, your growth is prioritized, and your contribution is valued. That's not just policy at Edify, it's how we operate every day. Edify Technologies is an Equal Opportunity Employer.
Never miss an opportunity! Create an alert based on the job you applied for.