Data Integration Administrator

Salary: $90,060.00 - $121,116.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number: 0
Department: Office of Financial Management
Division: Forecasting and Research
Opening Date: 04/11/2025
Closing Date: 4/25/:59 PM Pacific
Salary Information: The high end of the salary range, Step M is typically a longevity step

Description
Hybrid: Our physical office is in Olympia, WA. Our physical office is in Olympia WA. This position is flexible/hybrid, with the ability to telework, and some travel to in-person activities, meetings, and events are required.
Why work for the Office of Financial Management (OFM)?

The serves as the backbone of Washington state government. Our vision at OFM is to work together for the equitable future of all Washingtonians. Our mission is to make our state a better place by connecting people, budgets, policies, data, and systems for state agencies and the Legislature.

We're also committed to creating an environment that fosters our - Diversity, Equity, Inclusion and Belonging, Integrity, Innovation, Collaboration and Operational Excellence. All staff are expected to embed these values in their team and work. Join us in filling a key role in enhancing how state government serves its citizens, making a meaningful difference and taking public service to another level.

The job opportunity:
As a Data Integration Administrator, you will be responsible for consulting, designing, implementing, and managing integration solutions for Forecasting systems. You willsupport all platform/technologies involved in connecting critical multi-agency data sources of statewide education, workforce and justice applications and making cross-sector data available to partner agencies and external research entities. You will also provide expert Integration systems server and software administration, including architecting, managing, and maintaining integration solutions
This is a challenging position, but one that offers immense rewards and the opportunity to grow. Your work will help drive policies that make a real difference, impacting lives across our state. If you're someone who is ready to roll up your sleeves, engage with leaders from all sectors, and contribute to shaping the future of our state's fiscal policies, we encourage you to apply now.
Duties
What you'll work on:

• Design, maintain and deliver ETL Integration, data governance, and Identity Resolution Solution platform technologies.
• Configure, manage, and maintain Identity Resolution and ETL technical environments currently leveraging Informatica Master Data Management (MDM), PowerCenter and supporting technologies.
• Identify unique use cases specific to division's use of underlying technology to engage supporting vendors on, to improve product performance and functionality.
• Write and execute Test IO Utility scripts to troubleshoot database performance and network-latency issues, and to establish performance benchmarks.
• Use software such as native Informatica and Java/JBoss utilities, Wireshark, Debug Diagnostics, Sysinternals, Plan Explorer, and SQL Server tools to conduct performance analysis, identifying performance bottlenecks and opportunities for tuning and optimization, and work with peer engineers (DBA, Infrastructure and Operations staff) and vendor support to resolve performance issues and/or session failures.
• Write and execute scripts to troubleshoot database performance and network-latency issues, and to establish performance benchmarks.
• Use tools such as native Informatica utilities, Wireshark, Debug Diagnostics, Sysinternals, Plan Explorer, and SQL Server tools to conduct performance analysis, identifying performance bottlenecks and opportunities for tuning and optimization, and work with peer engineers (DBA, Infrastructure and Operations staff) and vendor support to resolve performance issues and/or session failures.
• Improve and protect solutions and the data.
• Implements continuous improvement on existing technical solutions - continually assessing current and planned utilization of the solutions leveraging Informatica and its supporting technologies or other ETL and data management technologies.
• Research, evaluate, make recommendations, and implement data solutions supporting new technologies, solutions, and services.
• Apply and ensure adherence to vendor and agency best practices for managing major/minor releases/upgrades, patches, hot fixes (HFs), and emergency bug fixes (EBFs).
• Serve as backup to the Forecasting and Research Division Database Solution Architect and Administrator.
• As needed, perform ongoing system maintenance of all Forecasting database management systems.
• Implement and maintain operational and disaster recovery procedures

Qualifications
What we need you to bring

Required Qualifications:

• Bachelor's Degree in Computer Science or related area (Mathematics, Engineering, Data and Integrations Design) (additional 2 years of experience in installation, configuration, and administration of integration software solutions such as core Informatica solutions (PowerCenter, Data Quality, and Master Data Management may substitute for the educational requirement)
• 5 years of experience in installation, configuration, and administration of integration software solutions such as core Informatica solutions (PowerCenter, Data Quality, and Master Data Management)
• 4 years concurrent experience supporting a large enterprise platform with support of technical Infrastructure and data movement troubleshooting.
• Five (5) or more years of experience designing and implementing and maintaining data warehouse solutions utilizing extract transform and load (ETL) procedures.
• Experience designing and engineering complex data and application integration architecture and platforms.
• Experience with performance monitoring tools and understanding performance metrics.
• Experience in performance analysis, tuning and query optimization of at least one of the relational databases like Oracle, MSSQL and MySQL et cetera (MSSQL preferred)
• Experience with Debug Diagnostics or similar tools

Desired Qualifications:

• Skills and experience in research organizations systems and platform support for integration technologies and methods. Skills and experience in OFM systems, platform, and network support and methods.
• Experience with data modeling and architecture tools, ER/Studio Data Architect preferred).
• Experience working with Azure DevOps.
• Experience in cloud platform environment.
• Experience in application servers (WebLogic and/or WebSphere and/or JBoss - JBoss preferred).
• Experience with network troubleshooting tools.

We are invested in acquiring the best and most innovative 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.
Supplemental Information
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.

Please visit our for a full list of benefits available to employees. Here's a quick glance at some of the unique benefits that OFM offers:

• A culture that values and strives to advance
• Tuition reimbursement
• 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

Application Process: Once you've decided to apply for a state government job, you'll complete an online application to showcase your qualifications. Keep in mind that once you submit the application, a real person is going to read it. We do not use AI or other technology that screens your application. Please be sure to provide clear and detailed information about your work history so your qualifications can be accurately assessed. We will contact the top candidates directly to schedule interviews. If you need reasonable accommodation in applying, please call 7-1-1 or 1-.

When completing your application, we encourage you to attach all of the following:

• Cover letter:describing your qualifications for this specific position
• Resume: that details your applicable experience and education.
• References: at least three professional references and their contact information.

Questions: OFM's Staff ASL interpreter is available to all deaf and hard of hearing applicants. For questions about this recruitment or to request a reasonable accommodation in the application or interview process, please email us at

The Office of Financial Management is an equal opportunity employer. We strive to create a working environment that includes and respects cultural, racial, ethnic, sexual orientation and gender identity diversity. Women, racial and ethnic minorities, persons of disability, persons over 40 years of age . click apply for full job details