Developer II (Middleware & Integrations)

HNI Corporation is a global family of brands for the workplace and home dedicated to enhancing the spaces where we live, work, and gather. We pride ourselves on fostering an environment where we make a positive impact on others; upholding our beliefs in integrity, inclusion and belonging.

We are hiring a Developer II with experience in middleware and integrations. This role focuses on designing, building, and maintaining robust data pipelines and integration solutions that connect enterprise applications, transactional systems, and third-party platforms. Unlike BI or analytics-focused data engineering roles, this position emphasizes operational data flows, system interoperability, and ensuring that critical business applications communicate efficiently and reliably.

This is a full-time, direct-hire salaried position that will work onsite four days a week (M-TH) from our newly renovated IT building in Muscatine, IA.

What You Will Do:

• Design, develop, and maintain ETL processes and data integration solutions to support middleware workflows across enterprise systems.
• Build and optimize data pipelines that enable seamless exchange of information between ERP, CRM, HR, finance, and other enterprise applications.
• Collaborate with application owners, solution architects, and infrastructure teams to translate integration requirements into scalable technical solutions.
• Ensure data integrity, consistency, and security across multiple platforms and environments.
• Develop APIs, messaging services, and file-based integrations to enable application interoperability.
• Monitor and troubleshoot data flows, addressing performance bottlenecks and integration failures.
• Document system designs, data mappings, and integration specifications to support ongoing maintenance and knowledge transfer.
• Stay current with emerging tools, patterns, and practices in enterprise integration and middleware technologies.

What You Have:

• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• 3–5 years of experience as a Data Engineer, ETL Developer, or Integration Developer within an enterprise IT environment.
• Strong proficiency with Informatica ETL tools
• Hands-on experience building web services (REST/SOAP)
• Solid understanding of SQL, relational databases, and data modeling.

Preferred Qualifications

• Experience with scripting languages (Python, PowerShell, Shell) for automation and data manipulation.
• Familiarity and/or experience with Oracle Integration Cloud (OIC) is STRONGLY preferred.
• Strong problem-solving skills and the ability to work collaboratively with cross-functional teams.

Relevant Skils

Core ETL & Data Integration Skills

• Proficiency with ETL tools
• Experience developing and maintaining data pipelines and workflows
• Strong SQL skills (query optimization, stored procedures, performance tuning)
• Knowledge of data mapping, transformation, and cleansing techniques
• Familiarity with data modeling (relational and dimensional)

Middleware & Integration Technologies

• Hands-on experience with APIs (REST, SOAP) and web services
• Knowledge of file-based integrations (SFTP, flat files, XML, JSON, CSV)
• Experience with enterprise service bus (ESB) or integration frameworks

Databases & Cloud

• Proficiency with relational databases (Oracle, SQL Server)

Programming & Scripting

• Python for scripting and automation
• Shell scripting / PowerShell for batch jobs and system-level integration

Systems & DevOps Practices

• Experience with CI/CD pipelines for ETL and integration code deployment
• Familiarity with version control (Git, SVN)
• Experience with job scheduling/orchestration tools (Airflow, Automic UC4)

Security & Compliance

• Understanding of data security practices (encryption, masking, secure file transfer)

We look forward to hearing for you!