NEOGOV · 2 weeks ago
Data Integration Analyst II
Portland 97218, OR
Full-time
Hybrid
Entry, Mid Level
$86K/yr - $120K/yr
2+ years expThe Port of Portland is seeking a Data Integration Analyst II to support their transformation journey. This role involves developing, maintaining, and monitoring data integrations to ensure reliable data flow across systems, contributing to the Port’s modernization efforts.
GovTechHuman ResourcesInformation TechnologySoftware
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
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 (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
Preferred
Bachelor's in Computer Science, Information Systems, or related field
Experience with Boomi, legacy-to-modern systems integrations, or ERP modernization
Benefits
Highly-subsidized healthcare plans that include alternative care
Life and accidental death & dismemberment (AD&D) insurance
Short-term and long-term disability coverage
Oregon Public Employees Retirement System (PERS) retirement program
Pre-tax spending accounts
Voluntary term life insurance
Deferred compensation plan
Critical illness and accident insurance policies
Award-winning wellness program
Mental health services
Discounts on local gyms
Pet insurance for companions
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
8 weeks of paid parental leave
10 paid holidays
Opportunity to convert sick leave to personal leave
Convert vacation leave to either cash, a retirement plan contribution, or a contribution to a Health Savings Account
Company
NEOGOV
NEOGOV is the leading provider of workforce management software uniquely designed for the public sector, education, and public safety.
501-1000 employees
H1B Sponsorship
NEOGOV has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (10)
2023 (10)
2022 (18)
2021 (14)
2020 (16)
Funding
Current Stage
Late StageTotal Funding
$700MKey Investors
Warburg Pincus
2025-07-28Secondary Market· $700M
2025-07-28Acquired
2021-06-02Private Equity
Leadership Team
Shane Evangelist
CEO
Brandon McDonald
Head Of Marketing
Recent News
Canada NewsWire
2025-11-14
2025-11-14
Government Technology US
2025-10-31
Company data provided by crunchbase