Data Integration Analyst II

The Position

The Port of Portland is hiring a Data Integration Analyst II.

This is a Limited Duration role currently budgeted for 4 years. The duration of the role may be subject to change based on business needs.

Join the team leading 'Port Forward - Transform with Purpose' the Port of Portland's bold transformation journey. This position is responsible for supporting the development, maintenance, and monitoring of data integrations that connect the Port's legacy systems (e.g., JD Edwards, Avantis, Workforce) and modern enterprise platforms through the iPaaS environment.

This individual will perform data mapping, transformation, troubleshooting, and documentation activities for assigned integrations under the guidance of senior analysts. Contributing to the Port's business process modernization by ensuring reliable, consistent, and accurate flow of data across systems is also a key factor in performing this role.

From the Hiring Manager: "Imagine joining a team where the work you do every day directly shapes how an entire organization operates for the next 20 years. That's what this role offers. As a Data Integration Analyst II at the Port of Portland, you won't just maintain interfaces - you'll help build the digital backbone of Port Forward, our multi-year modernization of finance, HR, asset management, procurement, and operational systems.

This is the ideal role for someone who wants to grow:
Your ideas will matter, your technical skills will expand quickly, and you'll be part of a talented, supportive IT culture that values experimentation, learning, and shared success.

If you're looking for a place where your work has real impact, where you can help build the next generation of enterprise technology using modern integration strategies, and where people genuinely care about collaboration and purpose - this is the team you want to join."

We offer a flexible hybrid schedule to support both work-life balance and team collaboration. Due to the nature of this role, it may require more on-site participation outside of the norm. This role CANNOT be performed remotely.

Integration Development & Configuration:

• Build, configure, and maintain assigned integrations using Boomi as our iPaaS tool.
• Modify and support existing SSIS packages and ETL/ELT processes as systems transition.
• Assist in developing and testing integration workflows, APIs, and data transformation logic.
• Implement assigned components of cutover, data migration, and system conversion tasks.
• Maintain accurate and up-to-date documentation for integration designs, mappings, schedules, and dependencies.

Operational Support & Data Reliability:

• Monitor assigned integrations, scheduled jobs, and Boomi processes to ensure reliability and performance.
• Troubleshoot failures; escalate complex issues to senior analysts.
• Validate datasets, ensure transformation accuracy, and perform reconciliation activities supporting ERP modernization.
• Coordinate with internal stakeholders and vendor teams to resolve data or interface-related issues.
• Query data and prepare routine reports or extracts to support operational decision making.

Project Participation &

Collaboration:

• Participate in integration design, requirements clarification, testing, deployment, and documentation.
• Collaborate with data analysts, ETL developers, business analysts, and project teams.
• Contribute insights on data mapping, interface impacts, and process considerations.
• Engage in knowledge transfer activities to support long-term sustainability.

• (Preferred) Bachelor's in Computer Science, Information Systems, or related field.
• (Required) 2+ years of experience with data Integration, ETL/ELT development, SQL scripting, or system interface support.
  • (Preferred) Experience with Boomi, legacy-to-modern systems integrations, or ERP modernization.

Demonstrated Skills:

• Use structured design and programming methodologies (required).
• Manage a complex multi-vendor technology environment including enterprise solutions (e.g. financial, HR, maintenance, GIS) and operational systems supporting various vendor functions.
• Interpersonal and teamwork skills to work collaboratively with…