Data Integration Analyst II

Data Integration Analyst II

Port of Portland is hiring a Data Integration Analyst II. This is a Limited Duration role, currently budgeted for 4 years. The duration may change based on business needs.

Join the team leading “Port Forward – Transform with Purpose”, our bold transformation journey. This position supports 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.

Responsibilities include data mapping, transformation, troubleshooting, and documentation for assigned integrations under the guidance of senior analysts. Your work helps ensure reliable, consistent, and accurate flow of data across systems.

• 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.

• Monitor assigned integrations, scheduled jobs, and Boomi processes to ensure reliability and performance.
• Troubleshoot failures and escalates 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.

• 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.

• Use structured design and programming methodologies.
• Manage a complex multi‑vendor technology environment including enterprise solutions (financial, HR, maintenance, GIS) and operational systems supporting various vendor functions.
• Interpersonal and teamwork skills to work collaboratively with staff and customers at all levels; influence others and manage change.
• Diagnostic, conceptual, and systematic thinking skills.
• Proactively identify issues and provide creative solutions.
• Written and verbal communication skills, tailoring content to audience.
• Provide recommendations for best practices, development options, and design decisions.
• Work without supervision, apply good judgment on when to escalated matters.
• Diagnose and articulate application and infrastructure issues, involving contractors, vendors, and Port staff.

• iPaaS fundamentals (Boomi strongly preferred).
• SQL/T‑SQL scripting and relational database concepts.
• ETL/ELT processes, including SSIS.
• API concepts (REST, SOAP, OpenAPI), JSON/XML.
• Data validation, QA/QC techniques.
  
  Legacy ERP systems (e.g., JDE, Avantis, Workforce).
• Reporting tools (SSRS, Power
  
  BI, Tableau).
• Common protocols: SFTP, HTTP/S, SMTP, DNS.
• Windows/Linux OS & standard applications.

A minimum qualification evaluation of the education, training, and experience of submitted application packets will take place by Human Resources the week of January 12, 2026.

A Subject Matter Expert (SME) panel will perform an evaluation of experience and training taken from your employment application materials.

Our goal is to schedule the virtual first round of interviews with candidates…