This job has closed.

Port of Portland · 2 weeks ago

Data Integration Analyst II

Portland, OR

Full-time

Onsite

Entry, Mid Level

2+ years exp

The Port of Portland is hiring a Data Integration Analyst II to support their transformation journey, 'Port Forward – Transform with Purpose'. The role involves developing, maintaining, and monitoring data integrations between legacy systems and modern platforms, contributing to the Port's business process modernization efforts.

GovernmentPublic TransportationTransportation

Responsibilities

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

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

Qualification

Data IntegrationETL/ELT DevelopmentSQL ScriptingBoomiAPI ConceptsData ValidationLegacy ERP SystemsInterpersonal SkillsWritten CommunicationProblem SolvingTeam Collaboration

Required

2+ years of experience with data Integration, ETL/ELT development, SQL scripting, or system interface support

Use structured design and programming methodologies

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

iPaaS fundamentals

SQL/T-SQL scripting and relational database concepts

ETL/ELT processes, including SSIS

API concepts (REST, SOAP, OpenAPI), JSON/XML