Functional Analyst III (SDA/TLT)

King County Metro Transit’s Rail Division is seeking a detail-oriented Functional Analyst III . The Functional Analyst III will lead the creation of new Power BI reports, monitor and validate reports, support monthly business reviews with the Rail Division and Sound Transit, contribute to process automation efforts, and respond to ad‑hoc data and report requests. We are looking for a lifelong learner who has a drive to understand the intricacies and nuances of data sets and the systems and people that produce the data. Reporting to the Data and Analytics Manager in the Rail Division’s Performance Strategy Team, this position will play a critical role in fostering a culture of data‑informed decision making in the Rail Division. Responsibilities Lead the creation of new, and revisions to existing, Power BI reports that relate to all aspects of the Rail Division (operations, maintenance, finances, human resources, procurement, safety). Monitor and validate reports and data sets for accuracy and quality. Collaborate with Metro and Sound Transit business intelligence and data teams regarding source data sets, changes to reports, and new reports. Support coordination teams that consist of Rail Division and Sound Transit staff by answering questions about data and reports, completing ad‑hoc data analysis, and developing and updating Power BI reports relevant to the coordination teams. Assist with documenting and following up on action items generated during monthly business reviews with the Rail Division and Sound Transit. Apply skills in storytelling and data visualization to foster a data‑informed organizational culture. Identify trends, risks, and improvement opportunities through data analysis and reporting activities. Respond to ad‑hoc data and report requests, some of which may be urgent. Use manual or automated methods to keep source data tables updated. Facilitate discussions and meetings to gather insights and build consensus on data collection and reporting methods. Build strong stakeholder relationships, including with Sound Transit. Communicate with stakeholders on new and changed reports and data sets. Provide data for display on digital screens throughout Rail Division facilities through manual or automated methods. Implement and maintain process automation solutions using Power Automate or other technologies. Work with other members of the Performance Strategy Team, including project managers and the continuous improvement specialist. Create documentation of standard processes completed by the Data and Analytics team. Support the management and administration of the Rail Division’s SharePoint sites. Perform other related duties as assigned. Minimum Qualifications Three (3) years of experience in data analysis and/or data visualization. Two (2) years of experience creating interactive business intelligence reports using Power BI, Tableau, or similar and/or two years of experience writing SQL queries. One (1) year of experience working directly with multiple stakeholder groups to gather report, application, or system requirements and/or respond to report, application, or system enhancement requests or bug reports. Additional Minimum Competencies / Qualifications Experience creating or using interactive business intelligence reports that encourage data‑driven decision making. Experience using analytical tools to clean and manipulate data sets. Experience completing comprehensive testing and validation of data, reports, applications, and/or technology systems. Experience using Microsoft Excel to manage datasets and respond to ad‑hoc data requests. Experience providing timely and informative project/task updates to internal and external stakeholders. Experience writing documentation for standard processes. Experience writing release notes or maintaining changelogs for reports, applications, or systems. Ability to tell a compelling story with data. Ability to provide clear, effective training and support to stakeholders and end users. Ability to maintain confidential and sensitive information. Ability to navigate interpersonal and organizational dynamics with professionalism, discretion, and strong relationship‑building skills. Skill in actively listening and adapting messaging for stakeholders. Skill in handling multiple competing priorities. Skill in working effectively and cooperatively with a variety of individuals from diverse backgrounds. Desirable Qualifications Experience with transit technology systems and data (e.g., EAMS, SCADA, HASTUS, GTFS, GTFS‑realtime). Experience with finance and HR systems and data (e.g., Oracle, PeopleSoft). Experience writing Microsoft SQL Server queries. Experience working in transit operations or maintenance. Experience with the public sector, either through consulting or employment within a government agency. Familiarity with local transit and mobility systems, including the business model and practices of Sound Transit and/or King County Metro. Experience planning and implementing automated data pipelines and data collection mechanisms. Advanced knowledge and training with data visualization standards and governance. Experience with Power Automate and Power Apps. Understanding of the full systems/software development life cycle. Selection Process Applications will be screened to determine whether candidates meet minimum qualifications, and for clarity, completeness, and responsiveness to the application instructions above. Applications will then undergo a blind panel review. Highly competitive applicants may be invited to participate in one or more interviews. Formal offers will be finalized after candidates have successfully completed any necessary pre‑employment processes. Work Schedule This position is full time, 40 hours per week, typically Monday through Friday. The work schedule is between 6:00 a.m. and 6:00 p.m.; however, there is some flexibility in start and end time with manager approval. Employees may be required to work a flexible schedule as needed to meet business and operational requirements. This position is exempt from the provisions of the Fair Labor Standards Act and is not eligible for overtime pay. Telework The work associated with this position will be performed in a hybrid work environment with a minimum of 3 days in office. Employees will have access to shared workspaces at various Sound Transit facilities. Employees will be provided with a Sound Transit‑issued laptop and must maintain a workspace with an internet connection. Work Location King Street Center: 201 S Jackson St, Seattle, WA 98104 Union Station: 401 S Jackson St, Seattle, WA 98104 Operations and Maintenance Facility – Central: 3407 Airport Way South, Seattle, WA 98134 Operations and Maintenance Facility – East: 1925 120th Ave NE, Bellevue, WA 98005 And any future Sound Transit Link facilities Union Membership This position is represented by PROTEC17:C4 union. Pay Grade Job Code 733502 / Grade 62 Equal Employment Opportunity King County is an Equal Employment Opportunity (EEO) Employer. No person is unlawfully excluded from employment opportunities based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status, or other protected class. Our EEO policy applies to all employment actions, including but not limited to recruitment, hiring, selection for training, promotion, transfer, demotion, layoff, termination, rates of pay or other forms of compensation. #J-18808-Ljbffr King-County,-W