DAMA - Puget Sound
The Premier Organization for Data Management Professionals in the Northwest


Data Reporting Analyst (Functional Analyst III) KING COUNTY

  • March 07, 2017 8:43 AM
    Message # 4652986
    Anonymous member (Administrator)


    Data Reporting Analyst (Functional Analyst III)

    Apply online at

    King County is committed to equity and diversity in the workplace. In addition, the county is committed to recruiting and maintaining a quality workforce that shares our guiding principles: collaborative, service-oriented, results-focused, accountable, innovative, professional and fair and just.

    OPENING DATE/TIME: 02/26/17 12:00 AM (GMT -8:00)

    CLOSING DATE/TIME: 03/12/17 11:59 PM (GMT -8:00)

    SALARY:    $82,329.10 - $99,530.08 Annually

    LOCATION: King Street Center - 201 S Jackson St, Seattle

    JOB TYPE: Career Service, Full Time, 40 hrs/week

    DIVISION: Department of Transportation - Transit Division

    JOB NUMBER: 2017RC06659


    Position Summary
    King County Metro Transit is looking for an innovative, technically savvy individual to assist with building and developing reports and analytics in the Operations unit of Transit Systems Development and Operations (SDO-O) section.  The Functional Analyst III will own the design, development, and maintenance metrics and reports to drive key business decisions. The ideal candidate for this position will be a self-starter with advanced statistical analysis, SQL, reporting and automation experience.  Advanced knowledge and understanding of business service systems and the ability to operate complex computer business applications and systems is also required for this position. 
    Applications received may also be used to establish a pool of candidates to fill future career service or long-term temporary vacancies of a similar nature in the same classification (Functional Analyst III) in SDO-O that might occur over the following year.
    Work Environment and Support Systems
    The Functional Analyst III will join a small team of operations technical analysts managing the technology systems used in the daily operation of Metro Transit service. This person will build the reporting and analytics practice based on the data created by the systems the team supports.   
    These systems are on buses, in the Transit Control Center, on the roadside and in the back offices. They support vehicle operations, dispatch and service management, fare payment, passenger information, signal priority, communications and other functions. The Functional Analyst III will be responsible for building from the ground up new streamlined reporting systems. 
    The major systems SDO-O supports are:

    • CAD/AVL: Computer Aided Dispatch/Automated Vehicle Location system handling bus location, schedule, interior and exterior electronic signs and announcements, service coordination and other service operations
    • ORCA: One Regional Card for All electronic fare payment system
    • RTIS: Real Time Information Signs displaying bus arrival times
    • TSP: Transit Signal Priority system providing priority for buses at signalized intersections
    • TRS: Transit Radio System providing data/voice communications between the transit control center and the bus fleet
    • ITS Network: Intelligent Transportation System wireless network providing data communications for buses and roadside systems at transit bases and on some transit service corridors
    • On-site Transit Coordinator support: 24/7 on-call support, user management, basic desktop support, and system problem resolution &/or escalation

    The functional analyst staff in the SDO Operations group performs many tasks and activities in support of these systems and the related business processes. In addition to normal system operations and maintenance, they may also support the development of new systems or support expansion of existing systems.

    An Employer To Be Proud Of
    King County Metro Transit is a regional leader in getting people places quickly, reducing commuter stress, greening the environment and improving urban air quality, by providing safe and comfortable transit services for the thousands of commuters and other residents of King County, Washington. King County Metro's fixed-route service provides more than 110 million passenger trips and carries passengers approximately 500 million miles annually. Metro has pioneered or refined dozens of innovations that have made us a leader in this nation's public transportation industry.
    Ideal Seattle Location 
    Metro Transit's central offices are located in Seattle's historic Pioneer Square district, in easy walking distance to the pier on Elliott Bay, close to popular urban residential neighborhoods, near regional bus lines, and next door to the Sounder (commuter train) Station and LINK (light rail) International District station. 
    Competitive Benefits 
    King County provides our employees with a free transportation pass (good on Metro, Pierce, Community and Sound Transit) and access to the building gym, with lockers, showers and bike room. We offer a competitive benefits package including medical, dental and vision benefits for the whole family and domestic partner. A competitive sick leave and vacation plan, twelve holidays a year, and participation in the State's Public Employees Retirement Plan (PERS) are provided, as well as the option of participating in the County's deferred compensation plan (a 457 plan). 

    Flexible Work Schedule 
    King County values the balance between work and life outside of work.  The standard work week for this position is 40 hours; alternative work hour variations may be possible. This position is exempt from FLSA provisions and may provide some flexibility in scheduling.  The position may share 24x7 on-call responsibilities with other members of the team. 
    Who May Apply
    This career service position is open to the general public and all King County employees.  
    Forms and Materials Required 
    Complete an online King County employment application with employment history going back at least ten years if you have 10 years of experience (or more to include all relevant experience). Please provide detailed answers to the supplemental questions. A resume and cover letter are not required, but recommended.
    For more information regarding this recruitment, please contact:
    Ralph Cady
    Senior Human Resource Analyst


    Build the reporting and analytics practice in the Operations unit of the Transit Systems Development and Operations (SDO-O) unit by assisting business units to evaluate Operations & Maintenance service level agreements; work with the Operations unit to design and develop analytical performance measures such as system performance and reliability, incident management and system recovery time KPI's; collaborate with the Transit Division's Strategic Planning group to evaluate business solution effectiveness.

    Additional job duties include the following:

    • Solve business information and analytics needs and resolve reporting issues by documenting requirements and designing and implementing SharePoint visualization sites
    • Use configuration software tools
    • Design, develop, implement, and maintain reporting tables, metrics, and reports that drive key business decisions using web tools and third party BI applications
    • Communicate status and issues to management on a recurring basis
    • Simplify business processes by automating the gathering, analysis and reporting of metrics
    • Participate in third party tool implementation projects that may involve enterprise-wide deployment
    • Design and conduct report testing
    • Provide technical assistance to IT during detection and resolution of reporting issues
    • Write SQL queries; build and run reports as requested
    • Extract data from disparate sources and warehouse appropriately for use in reporting
    • Identify and complete related efforts and tasks as required
    • Apply data mining, quantitative analysis, and statistics to available data to aid the County in its investment decisions
    • Evaluate available data sources and develop reliable, actionable reporting


    Either a Bachelor's Degree in Information Technology, business, statistics, engineering, economics, mathematics or related subject, or a Data Analytics certification from a recognized program; and 3 years'  experience  mining and reporting on data  using tools such as  MS Power BI, SQL, and Excel against object-oriented databases, with tool implementation experience, OR any equivalent combination of experience and education which demonstrates the skills, knowledge and abilities required to perform the work.
    Additional requirements include: 

    • Skill in analytical thinking, problem solving, resolving conflicts and bringing others to consensus
    • Expert knowledge and experience with SQL, web-based reporting, or business intelligence (BI)
    • Ability to distill large amounts of data and communicate effectively to executive decision makers
    • Knowledge of process management and experience improving processes
    • Skill in performing and interpreting quantitative statistical analysis
    • Strong understanding of relational database systems, data modeling concepts and data structures and the ability to analyze and identify trends, patterns and anomalies
    • Knowledge of data warehouse design and implementation
    • Demonstrated attention to detail and accuracy in work
    • Ability to lead by influence in a matrix environment and work with peers in areas such as Vehicle Maintenance, Radio Maintenance, the Command Center and KCIT data reporting
    • Excellent written and verbal communication skills
    • Ability to understand challenges or underlying concerns, share ideas, and develop effective responses or escalate issues for resolution

    Desired Qualifications:

    • Experience with "big data"
    • Knowledge and/or work experience with transportation statistics
    • Experience with business intelligence reporting systems, such as Power BI, Business Objects, Tableau, Crystal Reports and/or others
    • Knowledge of database query tools such as SSMS, SQL Developer and Power Query
    • Experience with data warehouse and ETL processes
    • Dashboard design experience
    • Experience with modern programming languages
    • Knowledge of scripting and macro programming languages
    • Knowledge of GIS and spatial data
    • Knowledge with Networking infrastructure


    Application/Selection Process
    An application and answers to the supplemental questions are required for this position. A resume and cover letter are not required, but recommended.  If you need an accommodation in the recruitment process or an alternate format of this announcement, please inquire directly with the Human Resources contact for this job announcement, Ralph Cady, at 206-477-5998 or

    Applicants should complete all requested information in the online application, and provide at least the last ten years of employment if you have ten years (or more to include all relevant experience). Applications should not state "refer to resume" instead of completing requested information.
    Application materials will be screened for qualifications, clarity, appropriate written communication skills and completeness.  The most competitive candidates may be invited to one or more interviews and written or performance exercises.  Reference checks will also be conducted.
    Union Representation
    This position is represented by the Professional and Technical Employees, Local 17, Professional and Technical bargaining unit. 
    Metro Transit is committed to promoting equal employment opportunity, affirmative action and diversity in the workplace
    Class Code: 7304300 (Functional Analyst III)

    Note: Online applications are preferred. However, if you cannot apply online, go to www.kingcounty.gov/jobs for other options.

    If you need an accommodation in the recruitment process or an alternate format of this announcement, please inquire directly with the contact listed on the job announcement or the department's Human Resources Service Delivery Manager.

© DAMA Puget Sound 2013

Powered by Wild Apricot Membership Software