Functional Analyst III (SDA/TLT)

• This recruitment is open to King County employees and the general public
• 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 by leveraging new and existing data and technology, partnering with staff across the Division's Operations, Maintenance, and Strategy and Administration Units, and collaborating with Metro and Sound Transit data and BI teams. About the Performance Strategy Team The Rail Division's Performance Strategy team has three functional areas: Data, Analytics & Technology Services

• operational analytics, enterprise reporting, dashboards, business systems support, and technology coordination Priority Project Management
• cross-functional project delivery, strategic initiatives, and organizational improvement efforts Continuous Improvement
• operational process improvement, workflow optimization, and employee-driven improvement initiatives This SDA/TLT opportunity is expected to be until May 2027, with the possibility of extension.

About King County Metro Transit's Rail Division King County Metro's Rail Division manages and maintains Sound Transit's Link Light Rail, a growing network spanning 60 miles and serving 38 stations across the Puget Sound region. Together with Metro's extensive fixed-route bus system and mobility services, the Link Light Rail system is the backbone of an integrated regional transit network that gives people real freedom of movement. As Puget Sound transit agencies work together to build a seamless, connected system, our light rail system plays a central role in expanding access, reducing barriers, and ensuring that everyone across our region can get where they need to go. Joining Metro's Rail Division means joining an organization that is shaping the future of public transportation in the Pacific Northwest and setting the standard for modern rail operations nationwide. This is a division that values strategic thinking, collaborative leadership, and a deep commitment to the people we serve, both our riders and our teams. Whatever your role, your work here contributes to something that matters, a light rail system that thousands of people count on every day. Seattle Streetcar includes the 1.3 mile South Lake Union line and the 2.5 mile First Hill line, proudly serving the diverse and vibrant communities around Seattle's downtown core. These rail services complement Metro's extensive fixed-route bus system and mobility services. Puget Sound transit agencies are collaborating to create an integrated transit network that enables people to travel farther, faster, and more easily. Who May Apply This position is open to King County employees and the general public. King County Employees applying for this SDA need to have passed their six (6) month probationary period (or will complete it by the closing date of this posting) in their current career service position. To Apply, you

Must Submit:

An O nline King County Application. Please include relevant work history going back 10 years (or more, if necessary), with all duties, dates of employment, and reasons for leaving explained clearly. A C over Le tter (1 page maximum) addressing : How your experience and background meet or exceed the qualifications for this position Why you are interested in this position and working in the Rail Division Answer the supplemental questions in their entirety. The employment history detailed in your application under the work experience section MUST correlate/support your responses to the supplemental questions and cover letter. If your responses cannot be validated, you will not proceed to the next steps of the review/selection process. Applications that do not follow the above instructions may be rejected as incomplete and will not be advanced in the process . Want to make sure your application materials are as competitive as possible? We highly recommend visiting the Career Support Services website for tips and examples on how to make your application materials most effective: Career Support Services

• King County .

Need Assistance? If you need this announcement in an alternate language or format, would like to request accommodation or assistance in the application or assessment process, or if you have questions, please contact Marwa Alansi, HR Talent Advisor, at malansi@kingcounty.gov Applying equity and social justice principles is a daily responsibility and a foundational expectation for all King County employees. In this role, you will apply equity and social justice principles that exemplify shared values, behaviors, and practices to all aspects of the work. As a Functional Analyst III, you will: 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 from a specific craft/work area 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 requests. 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, to meet project, team, and Rail Division goals. 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 include:

Experience creating or using interactive business intelligence reports that encourage data-driven decision making and curiosity among report users, using BI tools such as Power BI or Tableau. 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 as well as technical and non-technical audiences. 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 internal and external stakeholders as well as technical and non-technical audiences. Skill in handling multiple competing priorities. Skill in working effectively and cooperatively with a variety of individuals from diverse backgrounds. The most competitive applicants will possess these

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 in any capacity. 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 (planning, requirements, design, implementation, testing, training, deployment, and maintenance). 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, such as reference checks or internal record reviews. In addition, this recruitment's selection process may be used to establish an eligibility pool to fill future SDA/TLT position vacancies in this classification and within this division over the next twelve (12) months and will be utilized at the discretion of the hiring authority. 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 in this role 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 (access may be supplemented in some situations) where they can reliably perform work and remain available and responsive during scheduled work hours. Upon hire, employees must reside in Washington state and must be able to travel to the below work locations in a timely manner to respond to operational needs and workplace reporting requirements. Work Location Primary Work Locations will be:

King Street Center:

201 S Jackson St, Seattle, WA 98104

Union Station:

401 S Jackson St, Seattle, WA 98104 However, e mployees may need to report to any of the following locations: 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.

Job Code/ Pay Grade:

733502/ 62 An Employer to Be Proud Of King County Metro Transit is a regional leader in helping people move quickly throughout the region, reducing commuter stress, greening the environment and radically improving urban air quality, by providing comfortable, effective transit services for the thousands of commuters and other residents of King County, Washington. Working for Metro means working for a leader in this public transportation industry. Forbes recently named King County as one of Washington State's best employers. Together, with leadership and our employees, we're changing the way government delivers service and winning national recognition as a model of excellence. Are you ready to make a difference? Come join the team dedicated to serving one of the nation's best places to live, work and play. Guided by our " True North ", we are making King County a welcoming community where every person can thrive. We value diversity, inclusion and belonging in our workplace and workforce. To reach this goal we are committed to workforce equity. Equitable recruiting, support, and retention is how we will obtain the highest quality workforce in our region; a workforce that shares and will help advance our guiding principles

• we are one team; we solve problems; we focus on the customer; we drive for results; we are racially just; we respect all people; we lead the way; and we are responsible stewards.

We encourage people of all backgrounds and identities to apply, including Native American and people of color, immigrants, refugees, women, LGBTQ+, people living with disabilities, and veterans. 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.