About the Department

Learn how Metro connects you with what matters

**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 Online 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 Cover Letter (1 page maximum) addressing:
1. How your experience and background meet or exceed the qualifications for this position
2. 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 [email protected]

Position Duties

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

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).

Other Qualifications

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, employees 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.

Benefits

King County offers a highly-competitive compensation and benefits package designed to meet the diverse needs of our employees and support our employees' health and well-being. Eligible positions receive the following benefits and have access to the following programs:

Excellent medical, dental, and vision coverage options: King County provides eligible employees with options, so they can decide what’s best for themselves and their eligible dependents
Life and disability insurance: employees are provided basic coverage and given the opportunity to purchase additional insurance for both the employee and eligible dependents
Retirement: eligible King County employees may participate in a pension plan through the Washington State Department of Retirement Systems and a 457(b) deferred-compensation plan
Transportation program and ORCA transit pass
12 paid holidays each year plus two personal holidays
Generous vacation and paid sick leave
Paid parental, family and medical, and volunteer leaves
Flexible Spending Account
Wellness programs
Onsite activity centers
Employee Giving Program
Employee assistance programs
Flexible schedules and telecommuting options, depending on position
Training and career development programs

For additional information about employee benefits, visit our Benefits, Payroll, and Retirement Page.

This is a general description of the benefits offered to eligible King County employees, and every effort has been made to ensure its accuracy. If any information on this document conflicts with the provisions of a collective bargaining agreement (CBA), the CBA prevails.

NOTE: Benefits for Term Limited Temporary (TLT) or Short Term Temporary (STT) positions, including leave eligibility and/or participation in the pension plan through the Washington State Department of Retirement Systems, will vary based upon the terms and details of the position. Short Term Temporary positions are not eligible for an ORCA transit pass.

For inquiries about the specifics of this position, please contact the recruiter identified on this job posting.

Supplemental Questions

Did you attach a ONE PAGE cover letter addressing the below?:

1. How your experience and background meet or exceed the qualifications for this position.
2. Why you are interested in this position and working in the Rail Division.

**please note, only the 1st page of your cover letter will be reviewed

How many years of experience do you have in data analysis and/or data visualization?

Less than 3 years
At least 3 years but less than 5 years
At least 5 years but less than 7 years
7 years or more
None

How many years of experience do you have creating interactive business intelligence reports using Power BI, Tableau, or similar?

Less than 2 years
At least 2 years but less than 5 years
At least 5 years but less than 7 years
7 years or more
None

Please describe a project or task that involved learning a complex data set and creating interactive business intelligence reports using Power BI, Tableau, or similar and/or writing SQL queries. In your response, include 1. One or more examples of intricacies or nuances you discovered in the data set and any changes you made to your approach to account for these intricacies or nuances, and 2. How you tested or validated the report and/or query results.

Please describe in 300 words or less.

How many years of experience do you have writing SQL queries?

Less than 2 years
At least 2 years but less than 5 years
At least 5 years but less than 7 years
7 years or more
None

How many years of experience do you have 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?

Less than 1 year
At least 1 year but less than 3 years
At least 3 years but less than 5 years
5 years or more
None

Please provide an example of a time you worked 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.

Please describe in 200 words or less.

Do you have any of the following desired qualifications? Select All That Apply

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).

Are you able and willing to travel to different work locations, as needed, in a timely manner to respond to operational needs and workplace reporting requirements?

Are you currently an internal King County Metro Employee under the PROTEC 17 C4 union?

If you answered yes to the above, have you completed the six (6) month probationary period (or will complete it by the closing date of this posting) in your current career services position?

Yes, I've completed the six (6) month probationary period in my current career service position.
Yes, I'm serving a probationary in my current career service position which will be completed by the closing date of this posting.
No, I have not completed the six (6) month probationary period in my current career service position and will not complete it by the closing date of this posting.

Are you applying to this position as an eligible current or previous King County Employee Priority Placement Program Participant? Is this position the same or lower percentage of full-time when compared to the position held at the point of the notification of layoff? Do you possess the skills and abilities to qualify for this position?

Yes, I was given a layoff notice from my role at King County and I am within two years of the effective date of my layoff. Additionally, the position I was laid off from was the same or a higher percentage of FT status when compared to this one.
No.

If you answered yes to the question above and you are applying for this position as a Priority Placement Participant, to be considered, you must provide the following three pieces of information in the space provided:
1. The title you held when you received your layoff notice
2. The department you worked in
3. The effective date of your layoff

If you have a relative who works for King County Metro Transit, please provide the employee's name, position, and your relationship. Note: A relative is defined as a parent, child, sibling, spouse or domestic partner, aunt or uncle, niece or nephew, grandparent, grandchild, in-laws, children, or relatives of a domestic partner.

If you do not have a relative employed by King County Metro, please indicate “N/A”.

If you have a relative who works for Metro, please provide the Division of King County Metro that they currently work in. Select all that apply.

a. Bus Operations Division
b. Capital Division
c. Employee Services Division
d. Facilities Division
e. Finance & Administration Division
f. General Manager's Office
g. Marine Division
h. Mobility Division
i. Rail Division (including Streetcar)
j. Safety, Security & Quality Assurance
k. Vehicle Maintenance
l. I do not know which Division my relative works in at Metro Transit
m. I do not have a relative that works for King County Metro

If you have a disability as defined by the Americans with Disabilities Act, will you need accommodation in the testing process? If you check the "YES" box, the human resources staff person coordinating this recruitment will send you a request asking for additional information. (This confidential information is solicited for the purposes of providing reasonable accommodation only).

Required Question

Agency Information

Employer: King County
Address: King Street Center

201 South Jackson Street

Seattle, Washington, 98104
Phone: 206-477-3404
Website: http://www.kingcounty.gov/

Functional Analyst III (SDA/TLT)