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

About the role

Posting number: 26DOT-HQ-05603 Department: Dept. of Transportation Division: Headquarters Job classification: IT DATA MANAGEMENT - SENIOR/SPECIALIST Posting type: Open & Promotional Categories: IT and Computers, Project Management, Database Administration Summary 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 world's 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 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  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.