Revenue Forecast Analyst

Washington State Department of Licensing; Olympia (WA); On-site; USD 95,000 - 140,000; Full time

Job summary

Washington State Department of Licensing (DOL) is seeking a Tax Policy Specialist to join the OEPA Forecasting Unit. You will conduct econometric and policy analyses to project statewide revenue impacts and advise on tax policy options.

Responsibilities include preparing quarterly revenue forecasts, supporting fiscal notes and policy discussions, and presenting findings to legislative and OFM staff using SAS, EViews, R, and advanced Excel.

Qualifications

• 9+ years in economic analysis or tax policy analysis.
• Forecasting and statistical analytics software experience (SAS, EViews, R).
• Experience with financial modeling and large data sets.

Responsibilities

• Prepare and monitor quarterly revenue forecasts.
• Prepare revenue impact assessments for fiscal notes and policy scenarios.
• Provide expert testimonies on tax policies as needed.
• Coordinate with program areas and staff to ensure data accuracy.
• Present analyses and forecasts to executive and legislative audiences.

Skills

Forecasting analytics

Statistical analysis

Data analysis

Excel proficiency

Policy analysis

Communication

Executive writing

Presentation skills

Team collaboration

Problem solving

Education

Master's degree in Economics/Public Administration

Bachelor's degree in Economics/Statistics/Related

Statistical methods knowledge

Tools

SAS

Eviews

R

SQL

Excel

Job description

At the Department of Licensing (DOL) , we recognize the importance of work life harmony and strive to create a culture where employees feel valued and respected. Our employees are trusted and encouraged to be a part of process improvements that impact their work, create value for our customers and help build trust in our government.

Our Office of Equity, Performance, and Accountability (OEPA) is looking for a curious, analytic-minded, and customer service-oriented Tax Policy Specialist to join the Forecasting Unit.

As one of the most public facing state agencies and the second-largest revenue generator in Washington State, we engage with over 6 million residents each year and collect nearly $3 billion in taxes and fees revenue annually. We understand that our services are vital to the daily lives of our customers, enabling them to live, work, drive, and thrive. We take this responsibility to heart and are dedicated to providing equitable and meaningful access to our services for every Washington resident.

Forecasting Unit within OEPA is responsible for providing accurate and sound projection of revenue collected by DOL. This projection is critical for statewide financial planning, affecting among others transportation budget and public safety.

If you are passionate about analyzing legislation, policies, or initiatives using statistical, survey, mathematical, and other scientific methods of analysis, please read on!

As a Tax Policy Specialist (Revenue Forecast Analyst) within the forecasting unit of OEPA, you will conduct complex analyses and studies concerning statewide tax policies and their revenue impacts. Your analytical and problem-solving skills will lead you to develop what-if scenarios based on revenue impact assessments that you have created. Using that expertise, you will be able to advise on the advantages and disadvantages of existing and proposed policies. You will monitor revenue and establish quarterly revenue forecast by researching and developing econometric, time-series, and fiscal simulation models to provide revenue impact analysis for proposed legislative/policy changes affecting Washington State transportation.

Some of what you will do:

• Prepare and monitor quarterly revenue forecast for assigned revenue portfolio through researching, designing, and developing econometric, time-series, and fiscal simulation models.
• Prepare revenue impact assessments for DOL fiscal notes, decision packages, and other fiscal impact scenarios as assigned.
• Provide expert testimonies concerning tax policies and impacts as needed.
• Conduct tax studies, recommend policy options, and evaluate the existing policies.
• Coordinate with program areas, accounting, and information system staff to ensure data availability and accuracy.
• Respond to inquiries from outside related parties, legislative staff, Office of Financial Management staff, Transportation and Economic Revenue Forecast Council.

The work you will be doing is critical for statewide financial planning, affecting transportation budget, public safety, and the agency's ability to fulfill our purpose of, "Helping every Washington resident live, work, drive, and thrive."

What you will bring:

• Nine (9) years of professional experience in economic analysis or tax policy analysis.

OR

• Two (2) years of experience as a Tax Policy Specialist 1.

OR

• One (1) year as a Tax Policy Specialist 2

Up to four (4) years of relevant education in Economics, Statistics, Business, Public Administration, or closely related fields may substitute year for year for experience.

(Associate degree = 2 years Bachelor’s degree = 4 years)

Experience must include:

• Two years of Professional experience in:
• using forecasting and statistical analytics software, such as SAS, Eviews, and R.
• applied mathematical and/or statistical analysis of data.
• performing complex data analysis, financial modeling, and efficiently manage and manipulate large dataset.
• Two (2) years of experience using Microsoft Office Suite, including Word, PowerPoint, Outlook, Teams, and SharePoint. This includes the ability to create professional briefing documents, presentations, and manage email and calendar tasks effectively, ensuring seamless coordination and communication.
• Three (3) years of proficiency in Microsoft Excel, including advanced capabilities such as linked tables, Power Query, Power Pivot, and the creation and use of macros.
• The ability to:
• Leverage digital tools to perform data analysis and complex financial modeling.
• Analyze financial data, identify trends, and interpret complex information to make accurate predictions and strategic decision. This includes evaluating economic conditions and their impact on revenue forecast.
• Effectively present analysis and forecasts to relevant parties, preparing detailed reports and explain complex concept in understandable manner.
• Write clearly and concisely for executive level management, general public, legislative and OFM staff.
• Use charts, graphs, and narrative concisely and effectively to communicate information, adapt presentations to audience's level of understanding, and ensuring that both technical and non-technical relevant parties understand the essential points. Follow-up and follow-through.
• Independently perform complex research and impact analysis of current and proposed law and policies
• Prioritize work, manage their time effectively, and deliver high-quality results within set timelines.
• Be flexible in their approach and capable of adjusting plans and strategies in response to new information, shifting priorities, or unexpected challenges.
• Work collaboratively within a team environment, contributing to group project, sharing knowledge, and supporting colleagues to achieve common goals. Must be able to treat everyone equitably and inclusively.
• Manage multiple tasks and deadline efficiently.
• Effectively coordinate activities, services, and schedules to ensure smooth and efficient operation of work.
• Take the initiative to identify opportunities for improvement, develop innovative solutions and drive project forward without constant supervision. This includes staying updated with portfolio's industry trends and best practices.
• Understand and follow agency values of respect, trust, diversity, equity and inclusion through behaviors and decisions.
• Promote and support a respectful, equitable, and inclusive workplace for all employees.
• Promote and support respectful, equitable, and inclusive delivery of services to customers.
• Take action to learn and grow.
• Take action to meet the needs of others.

*Experience can be obtained concurrently*

What may help set you apart:

• A Master's Degree in economics, business, public administration, or a related field.
• Two (2) years of experience with statistical software such as R, SAS, EViews, or STATA.
• Advanced Excel data manipulation skills such as linked table, Pivot tables, Macros, and Power queries.
• Ability to query data with either SQL server, SAS, or Excel.
• Excellent verbal and written communication: prepare, review, summarize, and presenting information in a clear, concise, and accurate manner that meet the needs of diverse audiences.
• Excellent organizational skills, including ability to coordinate and prioritize multiple projects and meeting deadlines, with continuous improvement in mind.
• The ability to:
• Discuss technical forecast and legislation/policy, and recommendation in layperson term.
• Demonstrate knowledge of State of Washington's budget/fiscal/revenue policies, processes, and financial system.
• Demonstrate knowledge of legislative process, bill analysis, and fiscal note financial impact modeling. Ensure accuracy and appropriateness of supporting assumption, close coordination and collaboration with DOL program staff and other internal and external relevant parties.
• Understand and synthesize large amount of financial and policy information, and approach problem solving in supportive, logical, and solution-oriented manner.
• Work collaboratively in a team environment, effectively manage tasks, work efficiently, creatively solve problems, and handle difficult situations, in order to achieve agency goals.

Additional Conditions of employment:

• Prior to a new hire, a preemployment check including, Abstract of Driver Record (ADR) and criminal record history will be conducted.Information from the background check will not necessarily preclude employment but will be considered in determining the applicant’s suitability and competence to perform in the position.
• This position is expected to work at a minimum one (1) day per month in-office or more as business needs arise.
• The ability to travel to our Olympia office to meet business needs.