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

State of Washington•Thurston County – Lacey, WA

5d•Hybrid

About The Position

The Washington State Department of Transportation (WSDOT) is seeking an IT Data Management – Senior/Specialist to serve as the Financial Business Intelligence Specialist in Lacey, WA. This role will lead the design, development, and delivery of enterprise reporting solutions supporting statewide financial and operational decision-making. The 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 for WSDOT financial reporting. The Financial Business Intelligence Specialist will establish relationships between data sources for accurate, consistent, and standardized reporting, while supporting enterprise data governance, security, and reporting practices. This role 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.

Requirements

Demonstrated proficiency writing advanced SQL queries across multiple complex data sources and applying data modeling principles to develop reliable, efficient, and accurate reporting solutions.
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.
Ability to conduct customer and stakeholder interviews, gather and evaluate business requirements, and translate them into effective, scalable, and supportable reporting and technology solutions.
Ability to assess data quality, identify discrepancies and inconsistencies, perform data validation and auditing, and implement processes that support accurate, reliable, and consistent reporting.
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.
Ability to analyze relationships among systems, data sources, processes, and business functions and develop integrated solutions that support enterprise reporting and business objectives.
Ability to lead, coach, mentor, and provide technical guidance to staff while promoting effective use of business intelligence tools, data resources, and reporting practices.
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.
Ability to collaborate and coordinate effectively with technical teams, report developers, stakeholders, and other partners to develop, implement, and support enterprise reporting solutions.
Ability to develop and deliver user training, provide technical support, and assist customers in effectively using business intelligence tools, reports, and data resources.
Actively demonstrates a commitment to learning and growth and takes action to meet the needs of others.

Nice To Haves

Experience constructing complex queries, troubleshooting performance issues, validating data accuracy, and designing BI semantic layers.
Experience leading BI integration efforts, developing dashboards, supporting user troubleshooting, and ensuring BI tools are configured for optimal performance.
Experience training BI users and ensuring knowledge workers can correctly use reporting tools for their work.

Responsibilities

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 BI 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 BI technologies and TRAINS 4.0 reporting capabilities.
Consult with other WSDOT IT professionals and lead 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.