Data Integration Analyst Ii

Portland, OR, US, United States

Job Description

Salary


$85,500.00 - $119,500.00 Annually

Location

Portland 97218, OR

Job Type


Full-Time Administrative

Job Number


02169

Division


Finance, Tech & Analytics

Department


Business Solutions

Opening Date


12/22/2025

Closing Date


1/11/2026 11:59 PM Pacific

FLSA


Exempt

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.




Essential Job Duties


------------------------


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.

Minimum Qualifications


--------------------------


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

Supplemental and Selection Information


------------------------------------------


Selection Process: (tentative schedule):



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



At the Port of Portland, we strive to offer a holistic and comprehensive benefits package for employees and their families. We care about your health by offering highly-subsidized healthcare plans that include alternative care. We look out for you and for family by paying for life and accidental death & dismemberment (AD&D) insurance, short-term and long-term disability coverage. We participate in the Oregon Public Employees Retirement System (PERS) retirement program. We provide access to additional coverage and benefits including pre-tax spending accounts, voluntary term life insurance, a deferred compensation plan, and critical illness and accident insurance policies.



We go above and beyond by offering an award-winning wellness program for all employees to engage in. Employees can tend to their physical and mental health, earn rewards, and create community. Our employee assistance program supports the Port's commitment to emotional and mental well-being by providing mental health services, discounts on local gyms, and pet insurance for companions.



Our commitment to work-life balance ensures you have time to spend with loved ones and do the things you enjoy. We offer generous vacation time that accrues with length of service, sick leave that never expires and can be used for dependent care, health maintenance and mental health, and 8 weeks of paid parental leave - all in addition to 10 paid holidays. As an added bonus - because we know employees use their time off differently - once a year we give employees the opportunity to convert sick leave to personal leave, and to convert vacation leave to either cash, a retirement plan contribution, or a contribution to a Health Savings Account.



Please note:

Some benefits vary by job type/group, so please be sure to review your comprehensive benefit guide and/or collective bargaining agreement upon hire to confirm what is available to you.



Employer


Port of Portland

Address


7200 NE Airport Way



Portland, Oregon, 97218


Website


https://www.portofportland.com/Careers

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD6570470
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    85500.0 119500.0 USD
  • Employment Status
    Permanent
  • Job Location
    Portland, OR, US, United States
  • Education
    Not mentioned