Salary : $94,620.00 - $127,248.00 Annually
Location : Thurston County - Lacey, WA
Job Type: Full Time - Permanent
Remote Employment: Flexible/Hybrid
Job Number: 26DOT-HQ-05603
Department: Dept. of Transportation
Division: Headquarters
Opening Date: 09/15/2026
Closing Date: 9/22/2026 11:59 PM Pacific

Description
The Opportunity

WSDOT's Accounting and Financial Services Division (AFS) is currently seeking an IT Data Management - Senior/Specialist to serve as the Financial Business Intelligence Specialist in Lacey, WA. In this role, you will lead the design, development, and delivery of enterprise reporting solutions that support statewide financial and operational decision-making. This position is a senior-level technical specialist responsible for architecting advanced reporting structures, optimizing business intelligence systems, and designing and maintaining semantic models, data sets, and data structures that provide a reliable foundation for WSDOT financial reporting and inquiries. The Financial Business Intelligence Specialist will establish relationships between data sources to ensure accurate, consistent, and standardized reporting while supporting enterprise data governance, security, and reporting practices. This position will also provide technical guidance and quality assurance to Report Developers, mentor staff in the effective use of business intelligence tools and data resources and collaborate with the Technology Services Division Business Intelligence Architect to implement best practices and supportable reporting solutions.
What to Expect

Among the varied range of responsibilities held within this role, the Financial Business Intelligence Specialist will:

• Perform advanced data analysis and consult with WSDOT data stewards and IT professionals to ensure TRAINS 4.0 reporting solutions provide accurate report data.
• Maintain advanced knowledge of Power Bl business intelligence and reporting tool and Snowflake database.
• Design and maintain semantic models and data sets.
• Review user developed reports for compliance with reporting standards, enterprise reporting standards, requirements and data governance practices.
• Collaborate with data stewards to ensure that data presented in reports is accurate and meets business needs.
• Advise executive management and data stewards regarding Power Bl technologies and TRAINS 4.0 reporting capabilities.
• Consult with other WSDOT IT professionals and leads the integration of reporting tools with other reporting technologies as well as internal and external systems and interfaces.
• Design and maintain web-based reporting interfaces, applying WSDOT Intranet design standards.
• Develop and maintain release management checklist to ensure all reports released to production meet enterprise standards.
• Provide advanced technical support, troubleshooting and problem resolution for customers using reporting tools.

Qualifications

To be considered for this opportunity, the following competencies are required:

• SQL & Data Modeling: Demonstrated proficiency writing advanced SQL queries across multiple complex data sources and applying data modeling principles to develop reliable, efficient, and accurate reporting solutions.
• Business Intelligence Tools: Demonstrated proficiency using business intelligence and data visualization tools, including Power BI, and integrating data from sources such as GIS to develop effective reporting and visualization solutions.
• Analysis & Translation: Ability to conduct customer and stakeholder interviews, gather and evaluate business requirements, and translate them into effective, scalable, and supportable reporting and technology solutions.
• Data Quality & Audit: Ability to assess data quality, identify discrepancies and inconsistencies, perform data validation and auditing, and implement processes that support accurate, reliable, and consistent reporting.
• Complex Problem-Solving & Troubleshooting: Ability to analyze complex and non-routine data, reporting, and technical issues; identify root causes; and develop effective solutions that improve system performance, reliability, and usability.
• Systems Integration: Ability to analyze relationships among systems, data sources, processes, and business functions and develop integrated solutions that support enterprise reporting and business objectives.
• Leadership & Staff Development: Ability to lead, coach, mentor, and provide technical guidance to staff while promoting effective use of business intelligence tools, data resources, and reporting practices.
• Communication & Facilitation: Ability to translate complex technical and data concepts into clear, business-relevant information for non-technical audiences and facilitate discussions with customers and stakeholders to achieve shared understanding and effective solutions.
• Cross-Functional Coordination: Ability to collaborate and coordinate effectively with technical teams, report developers, stakeholders, and other partners to develop, implement, and support enterprise reporting solutions.
• User Training & Support: Ability to develop and deliver user training, provide technical support, and assist customers in effectively using business intelligence tools, reports, and data resources.
• Growth Mindset & Service-Oriented: Actively demonstrates a commitment to learning and growth and takes action to meet the needs of others.

It is preferred that qualified candidates also demonstrate/have:

• SQL Mastery & Data Modeling: Experience constructing complex queries, troubleshooting performance issues, validating data accuracy, and designing Bl semantic layers.
• Business Intelligence Tool Expertise: Experienceleading Bl integration efforts, developing dashboards, supporting user troubleshooting, and ensuring Bl tools are configured for optimal performance.
• User Training & Support: Experience training Bl users and ensuring knowledge workers can correctly use reporting tools for their work.

*To review the full Position Description, please follow the directions in the Contact Us section of this posting.
Important Notes

• This recruitment may also be used to fill additional positions per business needs.
• In addition to base salary, employees may be entitled to other forms of compensation depending on the type, duties, or location of the position. For union-represented positions, more information on other forms of compensation can be found in the applicable Information on other compensation types for non-represented positions can be found in of the Washington Administrative Code.
• This position offers flexible/hybrid remote work options.

How to Apply

Applications for this recruitment will be accepted electronically. Your relevant experience may be evaluated to determine salary. Therefore, it is very important that the "Work Experience" portion of the application be completed in as much detail as possible.

In order to be considered for this opportunity, please include the following with your online application:

• An attached Resume outlining (in reverse chronological order) your experience to date.
• An attached Cover Letter that further explains your qualifications and indicates why you believe you are a viable candidate for this role.
• Contact details for a minimum of three (3) individuals who can attest to your work performance, technical skills, and job-related competencies. NOTE: This information may be entered in the "References" section of the online application; does not require an additional attachment.

Please click the "APPLY" button to proceed. Note that you will be prompted to either sign in or create an account. This step is required in order to submit an application to this opportunity.
Contact Us

For inquiries about this posting, you may contact the assigned Recruiter at . Please be sure to reference 26DOT-HQ-05603 in the subject line.
More than Just a Paycheck!
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.

We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.

Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.

To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.

The Washington State Employee Assistance Program promotes the health and well-being of employees.

Retirement and Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

Social Security
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.

Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal h