Data Integration Analyst II

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 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 judgement on when to escalate matters.
• Diagnose and articulate application and infrastructure issues, involving contractors, vendors, and Port staff.

Abilities & Competencies:

• 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, PowerBI, Tableau).
• Common protocols: SFTP, HTTP/S, SMTP, DNS.
• Windows/Linux OS & standard applications.

Selection Process: (tentative schedule):

1. 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.
2. A Subject Matter Expert (SME) Panel will perform an evaluation of experience and training taken from your employment application materials.
3. Our goal is to schedule the virtual first round of interviews with candidates who successfully passed the SME evaluation on January 26, 2026. Panel Interviews will be held February 10, & February 12, 2026.

About us:

At the Port of Portland, we use everything we have - our three airports, three working marine terminals, six business parks, and all the resources, expertise, and experience behind them - to move with purpose, connecting people with powerful opportunities and creating value for our region. We know that every person we hire, business we work with, contract we sign and decision we make is a chance to make someone's life better. And we'll use our power and influence to unlock new opportunities and ensure more people share in our region's success. With YOUR help - together with our partners, customers, and community - we'll help drive meaningful change!

Do you have questions about this job?

Contact us: careers@portofportland.com

Safety: The Port promotes safety as a Core value and we seek to eliminate harm through a culture of active prevention, curiosity, evaluation, and action. We comply with safety and health policies and procedures and consistently look for improvements that support operational excellence.

Equal Opportunity Employer: The Port of Portland is dedicated to maintaining and improving a work environment, which extends equal opportunity to all individuals, regardless of their race, color, sex, age, religion, national origin, marital status, veteran status, disability or sexual orientation. Employment decisions shall be made in such a manner as to further the principle of equal employment opportunity and to comply with state, federal and local laws. We affirm through this policy statement our continuing commitment to the principles of nondiscrimination.

Veterans Preference: Under Oregon law, qualified veterans may be eligible for veterans' preference when applying for Port of Portland positions. If you are a veteran and would like to be considered for a veteran's preference for this job, please provide the qualifying documents as instructed during the application process.

Background Checks and Drug Testing: The Port of Portland will conduct background checks and/or drug tests for positions where such tests are required by regulation and for other safety-sensitive positions.

ADA Accommodation: Accommodations will be considered for applicants or candidates with a qualifying disability that prevents them from participating in this process. Accommodations will be made where the Port can reasonably do so without imposing an undue hardship on the business or compromising the integrity of the recruitment process. An applicant with any disability who believes that they need an accommodation should contact Human Resources: call 503-415-6690 or email careers@portofportland.com.