Application consultant

• Provide the Legislature with accurate and timely information and reports for use in budget formulation, historical analysis, and expenditure tracking.
• Understand legislative fiscal processes, the agency and executive branch budget development processes, the data utilized by each LEAP system, and the business processes associated with each system in order to communicate with those directly involved in carrying out those processes.
• Partner with legislative fiscal staff to understand business needs and provide them with consulting support.
• Work collaboratively as part of the LEAP Applications Development Team to : Determine requirements, design, develop, test, document, train, troubleshoot, and maintain operating, transportation, and capital budget development and reporting systems utilized by legislative fiscal committees and specialized systems utilized by the LEAP On-Call Support Team in a highly dynamic environment.

Create, update, and streamline Windows-based Visual Basic .NET and Transact SQL code utilized by LEAP client systems, as well as administrative systems utilized by LEAP staff.

Create, update, and streamline ad hoc queries and format information to support requests from clients for specialized data extracts and processes.

Develop and support complex Excel models. Design, create, and maintain SQL Server databases, with a strong emphasis on data administration and integrity.

Work collaboratively with the LEAP Web Development Team in providing public access to state budget and oversight information via the state fiscal.

wa.gov and LEAP Committee websites.

• As part of the LEAP On-Call Support Team, provide 24 / 7 after-hours support to fiscal clients during legislative sessions as required, including holidays and weekends.
• Respond to requests for information and modeling from legislators, legislative staff, legislative committees, and other entities.
• Appreciate the dependencies on executive and non-executive branch agencies as suppliers of fiscal information to the Legislature and work with those agencies to ensure integrity and enhance the utility of information provided.

Qualifications

• A proactive, flexible, and service-oriented approach to work.
• Excellent analytical, quantitative, and problem-solving skills with strong attention to detail.
• Experience with state and legislative budgeting and accounting processes.
• High level of proficiency in multiple software applications, including Visual Studio, SQL Server, and Microsoft Office products.
• Experience in planning, developing, and deploying complex information technology solutions used in financial analyses and budget development.
• Excellent communication and interpersonal skills; capability to build and maintain positive and collaborative working relationships with co-workers, legislative staff, state agency staff, and others, as well as a consistent professional approach and demeanor in high-pressure situations.
• Self-motivation and a can-do attitude, with an aptitude to learn quickly and retain and apply knowledge and manage multiple tasks simultaneously, while responding to the workload demands of the Legislature.
• Strong organizational skills, including the ability to prioritize and work efficiently and effectively under deadlines.
• Bachelor’s or Master’s degree in information technology, business or public administration, mathematics, statistics, economics, or other relevant field of study;

an equivalent combination of information technology or fiscal-related training and experience may substitute year for year for education.

Benefits

SALARY AND BENEFITS

• The salary range for this position is $8,876 $15,385 per month, depending on experience and qualifications, although the expected hiring salary will typically be less than the top of the range.
• A 3 percent legislatively approved salary increase will be included effective July 1, 2024.
• In addition to paid leave, a competitive state benefits package is also offered which includes a choice of medical / dental insurance plans, retirement, and life and basic long-term disability insurance.

Last updated : 2024-05-17