Financial Business Intelligence Specialist (IT Data Management - Senior/Specialist) | AFS

Financial Business Intelligence Specialist (IT Data Management - Senior/Specialist) | AFS

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
• Benefits
• Questions

Description

About WSDOT

The Washington State Department of Transportation (WSDOT) is a multimodal agency with a global reputation for excellence. Our dedicated workforce plans, designs, builds, and operates an integrated transportation system that safely and efficiently moves people and goods throughout the state. In addition to maintaining over 20,000 lane miles of state highway and 4,100 bridges, WSDOT leads an award-winning Active Transportation Plan, manages the worlds longest floating bridge, and operates the largest ferry system in the nation!

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: Experience leading 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 Collective Bargaining Agreements. Information on other compensation types for non-represented positions can be found in Chapter 357-28 of the Washington Administrative Code.
• This position offers flexible/hybrid remote work options.
• WSDOT does not use the E-Verify system, therefore we are not eligible to extend STEM Optional Practical Training (OPT). For more information, please visit www.uscis.gov

Why WSDOT

• Work-Life Balance - We are committed to ensure that our staff experience the reward of public service, while also sustaining a routine that suits each individuals' lifestyle. As such, there are a number of flexible schedule options available, including telework options for eligible positions.
• Paid Leave - In addition to 12 paid holidays, full-time employees earn up to 25 paid vacation days per year!
• Tuition Assistance - Permanent employees have several options for assistance with education expenses, including tuition reimbursement programs, government discounts at participating colleges throughout the state, and eligibility for federal student loan forgiveness.
• Plan For Your Future - WSDOT offers a comprehensive benefits package that includes a variety of healthcare options. Employees also have their choice of state retirement programs, and much more. Go to State Benefits for more information.

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.

WSDOT is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected, included, and empowered to bring unique ideas to the agency. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. All persons, regardless of race, ethnicity, age, veteran status, sexual orientation, and/ or gender identity, are encouraged to apply. Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact the listed Recruiter.

WSDOT does not use the E-Verify system, therefore we are not eligible to extend STEM Optional Practical Training (OPT). For more information, please visit www.uscis.gov

Contact Us

For inquiries about this posting, you may contact the assigned Recruiter at Robyn.Lovely@wsdot.wa.gov. 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. Thats 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 holiday per calendar year.

Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.

Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.

Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.

Sick Leave

Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.

Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.

Vacation (Annual Leave)

Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.

Part-time employees accrue vacation leave hours in accordance with WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.

Pay status includes hours worked, time on paid leave and paid holiday.

As provided in WAC 357-58-175, an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.

Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.

Military Leave

Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave

Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.

Additional Leave

Leave Sharing

Parental Leave

Family and Medical Leave Act (FMLA)

Leave Without Pay

Please visit the State HR Website for more detailed information regarding benefits.

Updated 01-07-2026

01

SQL & Data Modeling: Select the best option that describes your experience writing SQL queries and applying data modeling principles.

• I have extensive experience writing advanced SQL queries across multiple complex data sources and designing data models that support accurate, efficient, and reliable enterprise reporting.
• I have experience writing complex SQL queries across multiple data sources and applying data modeling principles to develop reporting solutions.
• I have experience writing SQL queries and applying basic data modeling concepts to support reporting and data analysis.
• I have limited or no experience writing SQL queries or applying data modeling principles.

02

Please briefly describe your experience writing SQL including when and where you gained this experience. If you do not have this experience, please enter N/A.

03

Business Intelligence Tools: Select the best option that describes your experience using business intelligence and data visualization tools.

• I have extensive experience developing and integrating enterprise business intelligence solutions, including dashboards and visualizations, using tools such as Power BI and integrating data from sources such as GIS.
• I have experience using Power BI or similar business intelligence and visualization tools to develop dashboards, reports, and data visualizations.
• I have experience using business intelligence or visualization tools to support reporting or data analysis.
• I have limited or no experience using business intelligence or data visualization tools.

04

Please list the business intelligence tools you have used and describe how you have applied them. If you do not have experience with these tools, please enter N/A.

05

Data Quality & Audit: Select the best option that describes your experience assessing and ensuring data quality.

• I have independently developed and implemented data validation, auditing, and quality processes across complex data environments to ensure accurate, reliable, and consistent enterprise reporting.
• I have regularly validated and audited data, identified discrepancies or inconsistencies, and implemented processes to improve data quality.
• I have performed data validation or quality checks and assisted with resolving data discrepancies.
• I have limited or no experience performing data quality or audit activities.

06

Complex Problem-Solving & Troubleshooting: Select the best option that describes your experience troubleshooting complex data, reporting, or technical issues.

• I have independently diagnosed complex and non-routine data or reporting issues, performed root-cause analysis, and implemented solutions that improved system performance, reliability, or usability.
• I have analyzed and resolved complex data, reporting, or technical issues and identified solutions to improve performance or reliability.
• I have troubleshot routine data or reporting issues and assisted with identifying and implementing solutions.
• I have limited or no experience troubleshooting data, reporting, or technical issues.

07

Systems Integration: Select the best option that describes your experience integrating systems and data sources.

• I have designed or led complex integrations across multiple systems and data sources, analyzing relationships among systems, processes, and business functions to support enterprise reporting and business objectives.
• I have developed or supported integrations between multiple systems or data sources to meet business or reporting needs.
• I have participated in system or data integration activities and supported the implementation of integrated solutions.
• I have limited or experience with systems or data integration.

08

Leadership & Staff Development: Select the best option that describes your experience providing leadership, coaching, or mentoring.

• I have led, coached, and mentored technical staff while providing technical guidance, developing team capabilities, and promoting effective use of business intelligence tools and data resources.
• I have provided technical leadership, coaching, or mentoring to staff or colleagues and supported their development.
• I have informally assisted or provided guidance to colleagues in technical or reporting activities.
• I have limited or no experience providing leadership, coaching, or mentoring.

09

Please briefly describe your experience coaching, mentoring, or supervising technical staff. If you do not have this experience, please enter N/A.

10

User Training & Support: Have you provided formal or structured training to business intelligence users to help them correctly and effectively use reporting tools for their work?

• Yes
• No

11

User Training & Support: Select the best option that describes your experience providing training and support for business intelligence tools, reports, or data resources.

• I have developed and delivered comprehensive training and ongoing technical support for business intelligence users, enabling knowledge workers to effectively and accurately use reporting tools and data resources.
• I have developed or delivered training and provided technical support to users of business intelligence tools, reports, or data resources.
• I have provided informal guidance or basic support to users of reporting or data tools.
• I have limited or no experience providing user training or support.

12

Please briefly describe your experience of training or supporting users with reporting or business intelligence tools. If you do not have this experience, please enter N/A.

13

SQL Mastery & Data Modeling: Select the best option that describes your experience with advanced SQL and data modeling.

• I have designed complex SQL queries, independently diagnosed and resolved query performance issues, validated data accuracy, and designed semantic layers to support enterprise business intelligence solutions.
• I have developed complex SQL queries, troubleshot performance issues, validated data, and applied data modeling techniques to support business intelligence solutions.
• I have used SQL and data modeling techniques to support reporting and data analysis.
• I have limited or no experience with advanced SQL or data modeling.

14

Business Intelligence Tool Expertise: Select the best option that describes your experience leading business intelligence integration and optimization efforts.

• I have led enterprise business intelligence integration efforts, developed dashboards and reporting solutions, resolved complex user issues, and optimized BI tools and configurations for performance and reliability.
• I have developed dashboards and reporting solutions, supported users, and helped optimize business intelligence tools for effective performance.
• I have used business intelligence tools to develop reports or dashboards and provided basic user support.
• I have limited or no experience developing or supporting business intelligence solutions.

15

Please identify the BI tools you have used and provide an example of an integration, dashboard, or optimization effort you led or supported. If you do not have this experience, please enter N/A.

16

How did you learn of this employment opportunity?

• Indeed
• LinkedIn
• Direct Email Notification
• WSDOT social media (Twitter, Facebook, YouTube, etc)
• Career Fair
• Monster
• WorkSource
• Handshake
• AASHTO
• NACTO
• COMTO
• APWA
• "NOW HIRING" banner/sign
• Radio advertisement
• WSDOT Employment Site
• Careers.wa.gov
• governmentjobs.com
• Other (specify below)

17

If you selected Other on the previous question, please specify how you learned of this employment opportunity in the space provided:

Required Question

Employer State of Washington

Address View Job Posting for Agency Information

View Job Posting for Location, Washington, 98504

Website http://www.careers.wa.gov