IT Senior Application Developer (3 positions)

State of Washington Office of Financial Management; Olympia (WA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental, Vision, Life Ins.

12 paid holidays

14 paid vacation days

State retirement programs

Job summary

The State of Washington Office of Financial Management is looking for three Senior Applications Developers to enhance state enterprise applications and data integration solutions. This role involves designing, coding, and implementing solutions that connect various applications and support critical business functions across Washington State.

Applicants should demonstrate experience in developing complex ETL solutions and integrating SOAP and REST APIs.

Qualifications

• Experience designing complex enterprise applications and data integration solutions.
• Advanced experience developing ETL and data integration solutions.
• Proficiency in SQL and database programming.
• Ability to troubleshoot and resolve complex application integration problems.

Responsibilities

• Design application and near-real-time data integration solutions.
• Develop code to integrate data between disparate applications.
• Maintain code documentation and technical specifications.
• Monitor production application data exchanges.

Skills

Data integration

ETL development

SQL

SOAP web services

REST APIs

Python

Informatica

SSIS

Job description

Why work for OFM

The Office of Financial Management (OFM) serves as the backbone of Washington state government. Our mission is to make our state a better place by connecting people, budgets, policies, data, and systems for state agencies and the Legislature. Our team includes budget advisors, researchers, and other experts, all dedicated public servants working towards an equitable future for every Washingtonian.

If you want to play a key role in enhancing how state government serves its citizens, you’ve found the right place. Join us in making a meaningful difference for every Washingtonian!

The job opportunity

We are seeking three Senior Applications Developers to serve as technical authorities in designing, developing, and implementing statewide enterprise applications and data integration solutions that support mission‑critical business functions across Washington State. These positions lead the development of scalable, reusable, and extensible solutions that connect applications, data, platforms, and technologies across agencies. The Senior Applications Developers provide advanced technical expertise in solving complex integration and data pipeline challenges and develop strategies and roadmaps for application and data integration. Solutions support critical enterprise functions, including financial management, budgeting, human resources, legislative operations, and asset management, as well as systems such as AFRS, HRMS, CAMS, and One Washington.

These positions design, code, configure, implement, and support complex integration solutions, including near‑real‑time messaging and data exchange and core integrations supporting the Workday implementation, Workday error reporting, Enterprise Data Warehouse, upload tools, and other enterprise integration needs. Using technologies such as Snowflake and other advanced development and integration tools, the Senior Applications Developers collaborate with technical teams and business partners to develop reliable, sustainable solutions and resolve complex enterprise challenges. These positions also contribute to statewide integration standards and provide technical guidance and mentoring to other developers, helping advance consistent and effective application development and integration practices across OFM and state agencies.

What you’ll work on

• Design application and near-real-time data integration solutions; integrating state enterprise mission‑critical applications data, such as AFRS, HRMS, and data warehouses, between each other and with applications maintained by other state agencies.
• Develop code to integrate data between disparate applications built on different platforms and technologies and build integration workflows using Informatica PowerCenter.
• Write and maintain code in multiple languages for web services (SOAP and REST) and APIs, allowing 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; determines and designs data integration application architecture.
• Build web service definition language (WSDL) documents to define the request and response of the web service.
• Write and maintain code documentation and technical specifications.
• Apply standardized release management procedures to plan, schedule, test, and implement deployments of data and application integration solutions through lower environments and to plan, schedule, and validate administrators' deployments to production environments, including facilitation through 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 development of ETL services.
• Design and develop complex Extract, Transform, and Load (ETL) to support Enterprise Data Warehouses and data marts, which would be easily consumable by the self‑service Data Analytics tools. Development tools can include, but are not limited to, Informatica and SSIS.
• Perform ongoing maintenance and support of the agency's enterprise integration solutions.
• Perform in-depth code and quality assurance reviews for both new application integration solutions and enhancements to existing solutions.
• Conduct real‑time root cause analysis in response to production issues, applying application coding and troubleshooting skills and experience in various tools and disciplines, including SQL, database systems, data integration, web services, SAP, and VSAM (mainframe).
• Monitor production application data exchanges and ensure the 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

What we need you to bring

Required Qualifications

• 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, along with 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, combined with the 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.

Desired Qualifications

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

We are most interested in finding the best candidate for the job, and that candidate may be one from a less traditional background. Don't let doubts stop you from applying for this position. If you have transferable experience, please tell us about it or contact us with questions about the required qualifications and how your experience relates to them.

What we offer

At OFM, we foster a culture of integrity, innovation, inclusion, and belonging. We value both learned and lived experiences, believing that diversity makes us stronger. To support your health and well‑being, we offer a variety of benefit programs for our employees.

Here’s a quick glance at some of the unique benefits that OFM offers:

• An environment of diversity, equity, inclusion, and belonging
• Medical, Dental, Vision, and Life Insurance
• 12 paid holidays, 14 paid vacation days (minimum), and 12 days of sick leave per year
• State retirement programs

The Office of Financial Management is an equal opportunity employer. We strive to create a working environment that includes and respects diversity in culture, race, ethnicity, sexual orientation, and gender identity. Women, racial and ethnic minorities, persons with disabilities, persons over 40 years of age, and disabled and Vietnam‑era veterans are encouraged to apply.

This position is exempt from civil service rules.

For more information, please see WAC 357-19-195.