Functional Analyst III - Transit Facilities
- The closing date for this recruitment has been extended to 10/4/22. If you already submitted an application, you do not need to re-apply.*This opportunity is open to all King County employees and the general public. *
Metro Transit’s Facilities Division (TFD) is seeking a candidate who will bring a high level of skill and passion to the role of Functional Analyst III (FAIII.) This fast-paced and collaborative team serves as the link between the technical side of systems support and the end-user experience.
Overall responsibilities consist of providing business intelligence, continuous improvement support, and advanced analysis of complex systems by gathering, refining, and translating business requirements into technical specifications. Key focus areas include: business intelligence, assisting with systems upgrades, designing and mapping system interfaces, developing project and system integration test plans, and monitoring systems functionality. The FAIII will be a subject matter expert of a data-based Monthly Business Review (MBR) and sub-metering systems for TFD and work with the TFD MBR Lead and Metro MBR Business Intelligence (BI) team.
About the Facilities Division
TFD is responsible for the management of transit facilities, equipment, and infrastructure. The Facilities Division oversees Transit's fixed-assets management plan, where timely maintenance and renewal of assets are critical to keeping transit facilities safe and in good condition for employees and transit customers.
We are filling one Career Service and one Special Duty Assignment/Term-Limited Temporary.
- SDA’s are open to current King County Career Service employees who have passed their initial probationary period or Appointed employees and may be given first consideration in the hiring process.
- TLT’s are open to the public. King County values diverse perspectives and life experiences.
- Job 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 the FAIII, you will:
- Design, develop, implement, and maintain reporting tables, metrics, and reports that drive key business decisions using third-party BI applications.
- Prepare performance dashboards, regular performance reports, summaries of results, and interpretations of findings for a wide range of audiences, including agency leadership, employees, and community representatives.
- Help manage the agency’s Monthly Business Review program, which requires meeting facilitation, providing support and guidance to key contributors, and monitoring the progress of the program at the department and division levels.
- Lead the education and training of multidisciplinary team members in the use of performance feedback systems and visual management tools.
- Interface between elements of the business and King County IT to help manage the continuous development cycle of Metro’s Business Intelligence and reporting data platform.
- Establish and implement effective analysis practices and facilitate the continuous improvement of how the impact is measured. Utilize excellent verbal and written communication skills to interact professionally with diverse groups, senior leaders, managers, and subject matter experts, and convey technical information to non-technical users.
- Support advanced reporting strategies for Performance and Facility Condition Assessments.
- Maintain system data and system integrity by evaluating and coordinating the correction of system problems, developing solutions, and creating resolution documentation.
- Identify and develop measurement tools and indicators; collect, analyze, and evaluate data to determine inefficiencies or weaknesses; provide recommendations for corrective measures.
- Analyze and design system functionality. Gather, define, and translate complex system requirements into functional specifications. Document findings and specifications, develop system integration test plans, and propose efficiencies and business process improvements.
- Monitor system functionality. Troubleshoot, track, resolve, and document significant system problems and issues requiring advanced technical expertise.
- Research, design, data map, develop, test, implement, train and document by utilizing industry standard of SDLC (System Development Life Cycle) to support enterprise application systems, BI reports, application modifications, business process improvements, system configuration changes, and other related application functions.
- Analyze and test proposed system interfaces, enhancements, and upgrades prior to implementation. Develop acceptance criteria.
- Establish system security, access portal, call, and change management processes.
- Facilitate complex system changes by identifying, analyzing, and prioritizing system change requests. Assess potential system-wide impacts of proposed module configuration changes.
- Prepare system documentation. Draft business cases, complex technical analysis, and data/work-flow documentation; conduct gap and cost/benefit analyses; conduct conceptual review, working closely with IT management in the development of these materials.
- Provide support, troubleshoot problems, and training to end users on system software.
- Experience, Qualifications, Knowledge, Skills
Successful candidates must possess advanced knowledge of information systems, processes, techniques, technology principles, and advanced skills in Power BI. Three years of increasingly responsible technical experience working with information technology, providing business system support/enhancement, and technical problem resolution for system users OR an equivalent combination of education and experience is required.
Minimum qualifications for this position include:
- Demonstrated ability to simultaneously prioritize workload while maintaining a collaborative and problem-solving environment.
- Strong ability to write complex system documentation and technical reports using tools to analyze large amounts of data.
- Experience in creating interactive business intelligence reports that encourage business literacy and curiosity, utilizing BI tools such as MS Power BI or Tableau.
- Customer service skills such as follow-up, discretion, patience, etiquette, communication, and professionalism.
- Ability to maintain confidentiality of sensitive information.
- Ability to deal with others with tact, diplomacy, and courtesy.
- High level of initiative, self-starter, desire to improve processes.
- Demonstrated skill in planning, organizing, time management, handling competing priorities, and producing quality detailed work within tight timeframes.
- Demonstrated skill in applying project management principles and practices.
- Demonstrated skill in analytical thinking, problem-solving, resolving conflicts, and bringing others to a consensus.
- Ability to manage and prioritize a diverse workload to accomplish tasks on defined timelines.
- Ability to present complex research findings and topics in a clear and accessible manner to all audiences. Demonstrated ability to tell a compelling story with data.
- Ability to identify, evaluate, and recommend service and workplace business process improvements.
- Skill in working effectively and cooperatively with a variety of individuals from diverse backgrounds.
- A strong team leader with the ability to lead a team.
- Demonstrated skills in oral and written communication, including conducting technical training and presentations. Ability to provide clear, understandable training and support to customers and end-users.
- Advanced skill in relational databases, automated systems data modules, data models, table relationships, and views.
- Intermediate skills in MS Office Suite and 365: Excel, Word, Adobe Acrobat, SharePoint, and OneDrive.
Desirable qualifications include: (This experience is not required; applicants with this experience should highlight it; however, applicants without this experience are not meant to be dissuaded from applying. If you don’t already have this experience and you are hired for this position, you can look forward to expanding your skillset as a Metro employee!)
- Experience with Asset Management Systems/CMMS (Computerized Maintenance Management Systems).
- Knowledge and experience using EAM Cognos reporting and Oracle/EBS.
- Programming and SQL query knowledge.
- Knowledge and experience in advanced metering software and hardware integration, configuration, and programming.
A valid Washington State Driver's License and acceptable driving record.
- Supplemental Information
Who May Apply
This position is open to the general public and current King County employees that have fulfilled their initial King County probation period.
How to Apply
Applicants will be screened for competitiveness, completeness, and written communication skills. The most competitive candidates may be invited to participate in one or more interviews.
REQUIRED Forms and Materials:
- An online King County application, updated with accurate contact information and relevant work history going back 10 years (or more, if necessary), with all duties, dates of employment, and reasons for leaving explained clearly.
- Completed supplemental questions
- Cover Letter
Current King County Employees: Be sure to include your current position and separately list each previous position you held at King County.
For guidance on how to complete these required materials, be sure to check out the Career Support Services website for tips and examples on how to make your application materials more competitive: Career Support Services - King County.
This recruitment will be used to fill one Career Service/TLT and one Special Duty Assignment. Applications received may be used to establish a list or pool of eligible candidates to fill future vacancies in the same classification that might occur over the following 12 months at the discretion of the hiring authority.
This position is exempt from the provisions of the Fair Labor Standards Act and is not overtime eligible. Normal work hours (start and end time) vary between 6:00 am and 6:00 pm, Monday through Friday.
The work associated with these positions will be performed predominantly in a hybrid work environment working in the office and at home. Employees will have access to shared workspaces at various King County facilities. Employees must reside in Washington state and within a reasonable distance to their King County worksite to respond to workplace reporting requirements.
Employees will be provided with a County 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. Please note that when an employee conducts work that is likely to bring them in contact with another individual, safety precautions are required, including the wearing of masks in some situations. King County is doing its part to reduce the spread of COVID-19 and remains committed to reducing our carbon footprint.
King County has a robust collection of tools and resources to support working remotely. The individuals selected for these opportunities will be joining innovative and progressive teams that are redefining how we work as we transition to the department's hybrid environment.
Positions in this classification are represented by Professional and Technical, Local 17.
7304300 Functional Analyst III
For more information regarding this recruitment, please contact:
Tracy Bylund (she/her), Talent Advisor, firstname.lastname@example.org
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.
COVID-19 Vaccination Requirement
King County Executive Branch employees are required to be fully vaccinated against COVID-19. If you are the successful candidate for the position you applied for, the County will send you a conditional offer letter.
As a condition of employment, prior to a final offer of employment, you will be required to:
- submit proof of vaccination, or
- have an approved request for medical or religious exemption and an approved accommodation. Philosophical, political, scientific, or sociological objections to vaccination will not be considered for an exemption or accommodation.
People are considered fully vaccinated against COVID-19 two weeks after receiving the final dose of a vaccination approved by the Center for Disease Control and Prevention (CDC).
The Executive Branch includes employees in the Executive branch, the Assessor's Office, Elections, the King County Sheriff's Office, and the Executive Office.
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.
If you are interested in pursuing this position, please follow the application instructions carefully. 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 the recruiter listed on this job announcement.
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:
- Medical, dental, and vision coverage: King County pays 100% of the premiums for eligible employees and family members
- 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: King County employees are eligible to 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
- 10 paid holidays each year (plus 2 personal holidays)
- Generous vacation and paid sick leave
- Paid parental leave, family and medical leaves, and volunteer leave
- Flexible Spending Account
- Wellness programs
- Onsite gyms and activity centers
- Employee giving program
- Employee assistance programs
- Flexible schedules and telecommuting options, depending on position
- Training and career development programs
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. Also, in the event of any incorrect information in this document, applicable laws, policies, rules, CBAs, or official plan documents will prevail.
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.
01Please describe the reporting tools and types of data sources you have used. Note which job(s) the experience was gained in and approximately what percentage of time you spent doing these duties. If you do not have this experience, reply "N/A".02Describe your experience performing technical problem resolution for system users. Be detailed, describing the systems, types of problems, your trouble-shooting process, the approximate number of users supported, and which job provided this experience. If you do not have this experience, type "N/A".03How many years of experience do you have providing end-user support and technical problem resolution?
04Which, if any, of the desirable skills do you possess? Please check all that apply.
- Three or more years
- More than two, but less than three years
- More than one, but less than two years
- Some experience, but less than one year
- No experience
05Do you currently possess a valid Driver License? (Note: if your license was issued by any state other than Washington, you will need to convert it prior to receiving a formal offer for this position. Driving abstracts will be reviewed prior to hire.)
- Experience with Asset Management Systems/CMMS (Computerized Maintenance Management Systems)
- Knowledge and experience using EAM Cognos reporting and Oracle/EBS
- Programming and SQL query knowledge
- Knowledge and experience in advanced metering software and hardware integration, configuration, and programming
- I do not have any of the additional desirable skills, but am looking forward to learning
06Have you been terminated, or have you resigned in lieu of termination, from any position in the last ten years? (This does not include layoff.)
07If you answered yes to the previous question, provide the name of the employer(s) and a complete explanation of the reason for termination. If not, answer "N/A". (Noting, "will explain in interview" is NOT a valid response and could result in your application not being considered.)08As a reminder, a cover is required as part of your application package for this position. If you haven't attached a cover letter yet, you are able to go back and attach it. Can you confirm you've attached your cover letter?
09If 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 resource staff person coordinating this recruitment will contact you asking for additional information. This confidential information is solicited for the purposes of providing reasonable accommodation only.
10Are 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?
11If 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
- 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.