IT Senior Application Developer (3 positions)

State of Washington•Thurston County – Olympia, WA

About The Position

The Office of Financial Management (OFM) is seeking three Senior Applications Developers to serve as technical authorities in designing, developing, and implementing statewide enterprise applications and data integration solutions. These roles are crucial for supporting mission-critical business functions across Washington State. The developers will lead the creation of scalable, reusable, and extensible solutions that connect applications, data, platforms, and technologies across agencies. They will provide advanced technical expertise to solve complex integration and data pipeline challenges, and develop strategies and roadmaps for application and data integration. The solutions will support critical enterprise functions such as financial management, budgeting, human resources, legislative operations, and asset management, as well as systems like AFRS, HRMS, CAMS, and One Washington. The positions involve designing, coding, configuring, implementing, and supporting complex integration solutions, including near-real-time messaging, data exchange, and core integrations for the Workday implementation, Workday error reporting, Enterprise Data Warehouse, upload tools, and other enterprise integration needs. Utilizing technologies like Snowflake and other advanced tools, developers will collaborate with technical teams and business partners to create reliable, sustainable solutions and resolve complex enterprise challenges. Additionally, they will contribute to statewide integration standards and mentor other developers to promote consistent and effective application development and integration practices across OFM and state agencies.

Requirements

Demonstrated experience designing complex enterprise applications and data integration solutions across disparate platforms, applications, databases, and organizational environments, including near-real-time and batch integration patterns.
Demonstrated advanced experience developing complex ETL and data integration solutions supporting enterprise data warehouses, data marts, and operational systems using technologies such as Informatica and/or SQL Server Integration Services (SSIS).
Demonstrated experience developing and integrating SOAP and REST web services and APIs, with working knowledge of XML, JSON, WSDL, XSD, and related integration/interface standards.
Demonstrated proficiency in SQL and database programming.
Experience using scripting/programming languages such as Python, VBScript, and/or batch scripting to develop, automate, and orchestrate application and data integration solutions.
Demonstrated ability to troubleshoot and resolve complex application and data integration problems, perform root-cause analysis, conduct code and quality assurance reviews, optimize integration solutions, and support mission-critical production environments.
Demonstrated experience applying SDLC, source control, testing, release/change management, technical documentation, and deployment practices.
Ability to provide technical consultation, establish integration standards, and collaborate with technical teams, project teams, and customers.
The ability to take action to learn and grow.
The ability to meet the needs of others.

Nice To Haves

Five (5) years developing solutions in a Middleware environment (Informatica, MQ).
Experience in engineering complex data and application integration solutions for enterprise systems.
Experience in enterprise systems, integration technologies, and methods.

Responsibilities

Design application and near-real-time data integration solutions, integrating state enterprise mission-critical applications data (e.g., AFRS, HRMS, data warehouses) with each other and with applications maintained by other state agencies.
Develop code to integrate data between disparate applications built on different platforms and technologies.
Build integration workflows using Informatica PowerCenter.
Write and maintain code in multiple languages for web services (SOAP and REST) and APIs, enabling other agencies' systems to access statewide data stores, utilizing knowledge of XML, WSDLs, XSDs, and JSON.
Consume web services and APIs exposed by various vendors/SAAS solutions to integrate enterprise data.
Translate application requirements into functioning code for application integration and determine/design data integration application architecture.
Build WSDL documents to define web service requests and responses.
Write and maintain code documentation and technical specifications.
Apply standardized release management procedures for planning, scheduling, testing, and implementing deployments of data and application integration solutions through lower environments and validating production deployments via the agency’s change management system (ServiceNow).
Design and implement statewide Enterprise Data Warehouse ETL processes as the designated lead for current and emerging enterprise system data movement solutions and ETL service development.
Design and develop complex ETL to support Enterprise Data Warehouses and data marts for self-service Data Analytics tools, using tools such as Informatica and SSIS.
Perform ongoing maintenance and support of the agency’s enterprise integration solutions.
Perform in-depth code and quality assurance reviews for new and existing application integration solutions.
Conduct real-time root cause analysis for production issues, applying coding and troubleshooting skills in SQL, database systems, data integration, web services, SAP, and VSAM.
Monitor production application data exchanges to ensure timely delivery of data, files, and messages.
Analyze and document existing and proposed application integration standards, best practices, integration definitions, and business rules.
Assist customers with integrations, complex problem resolution, and architecture.
Assist in time-critical production failure resolution.
Analyze and resolve complex application integration problems.
Determine and recommend overall design for application integration solutions.
Research and explore innovative options to establish integration standards for data and application templates and processes.