Data Integration Administrator
Data Integration Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 inperson activities meetings and events are required.Why work for the Office of Financial Management (OFM)
The Office of Financial Management (OFM) 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.
Were also committed to creating an environment that fosters our core values 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 multiagency data sources of statewide education workforce and justice applications and making crosssector 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 youre someone who is ready to roll up your sleeves engage with leaders from all sectors and contribute to shaping the future of our states fiscal policies we encourage you to apply now!Duties
What youll 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 divisions 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 networklatency 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 networklatency 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:
- Bachelors 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. Dont 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 wellbeing we offer a variety of benefit programs for our employees.
Please visit our Recruitment Pagefor a full list of benefits available to employees. Heres a quick glance at some of the unique benefits that OFM offers:
- A culture that values and strives to advance diversity equity inclusion and belonging
- 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 youve decided to apply for a state government job youll 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 711 or.
When completing your application we encourage you to attachall 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:OFMs 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 and disabled and Vietnamera veterans are encouraged to apply.
This position is exempt from civil service rules.
For more information please see WAC.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
