Seattle, Washington

SALARY: $‎28.85 - $‎43.27


Under general direction, analyzes, develops, prepares, produces, and provides oversight for the content, format, and production of a wide range of operational reports, ad hoc queries, and data analysis for the Operations Department. Assists business and decision making processes and interprets data and results using a variety of techniques ranging from simple data aggregation and statistical analysis to more complex data mining. Assists in the preparation of periodic service performance reporting for both internal and external audiences. Supports National Transit Database reporting and agency business intelligence initiatives.

For a look into our culture, look here.

The following duties are a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.

• Prepares a wide range of monthly, quarterly, and annual operational performance reports including, but not limited to monthly and quarterly service reports for the Board of Directors, National Transit Database reports, and data in support of benchmarking commitments; performs peer comparison and industry research to evaluate reporting alternatives.
• Develops, implements, and oversees performance reports and data definitions based on industry best practice for service planning, benchmarking, and regulatory requirements.
• Works with IT and business representative on the support, implementation or enhancement of reporting tools such as business intelligence initiatives. Coordinates data activities with external partners to ensure consistency of data and integration with ST business needs.
• Extracts and organizes data for analysis and trending and compares against industry and management metrics and best practices; presents findings and works to identify and implement strategies that will address tactical and strategic goals.
• Develops, tests, and rolls-out queries and ad hoc report writing to respond to requests for service performance information from management, employees, and public disclosure requests or to validate, interpret, and verify accuracy of system data and reporting.
• Implements tools and techniques to validate performance reporting results. Assists with preparation of annual Service Implementation Plan data elements.
• Evaluates processes and procedures in assigned areas, makes recommendations, and assists in the design and implementation of solutions. Demonstrates continuous effort to improve activities, decrease turnaround times, streamline work processes, and work cooperatively and jointly to provide quality seamless customer service; makes recommendations for needed training for internal customers.
• Serves on assigned committees; partner with other department on possible reporting and assessment needs; attends and participates in professional group meetings; stays abreast of new trends and innovations in assigned field; maintains awareness of federal, state, and local regulations and impact of changes on the Agency.
• It is the responsibility of all employees to follow the Agency safety rules, regulations, and procedures pertaining to their assigned duties and responsibilities, which could include systems, operations, and/or other employees.
• It is the responsibility of all employees to integrate sustainability into everyday business practices.
• Other duties as assigned.


Education and Experience:
Bachelor’s Degree in service planning, management, information management or related field and at least two years of experience preparing performance reporting or benchmarking data, familiarity with reporting and query tools such as Access or Crystal Reports and large company systems or equivalent combination of education and experience.

Required Licenses or Certifications:

Required Knowledge of:
• Governmental budget development, monitoring, and reporting principles and practices.
• Generally accepted accounting principles issued by FASB and/or GASB.
• Complex chart of account structures, subsidiary ledgers, and reporting tools and techniques to categorize information.
• Report preparation and presentation using report writing software tools, such as Crystal Reports.
• Financial data analytics and presentation, mathematical principles, and data processing techniques.
• Advanced Microsoft Excel and reporting applications; basic to intermediate skill in Microsoft Access, Microsoft PowerPoint, Microsoft Work, Microsoft Visio, and Crystal Reports.
• Deep understanding of database technology and design concepts.
• Industry principles and practices of assigned area.
• Principles and procedures of financial record keeping, storage, and document management.
• Pertinent local, state, and federal laws, regulations, and ordinances.
• Office procedures, methods, and equipment.
• Customer service methods and techniques.

Required Skills:
• Financial statement preparation and developing and monitoring divisional, program, operating, and capital project budgets, costs, and schedules.
• Applying appropriate analysis, judgment, logic, and communication methods when solving problems.
• Interpreting and applying technical and industry concepts to analyze, research, and present results.
• Understanding and interpreting end user requirements; ability to develop/document business, analysis, and reporting requirements.
• Responding to inquiries or presentation of information clearly and concisely using effective oral and written communication.
• Utilizing advanced personal computer software programs affecting assigned work.
• Establishing and maintaining effective working relationships with other department staff, management, vendors, outside agencies, community groups, and the general public.
• Utilizing quality control techniques related to final product completion to ensure accurate results.
• Planning, implementing, completing, and reporting on progress, reviews, and end results.
• Managing multiple tasks, setting objectives/goals, and re-prioritize work to meet changing deadlines and priorities.
• Applying project management techniques and principles.

Physical Demands / Work Environment:
• Work is performed in a standard office environment with occasional field operations.
• Subject to standing, walking, bending, reaching, stooping, and lifting of objects up to 25 pounds.
• The Agency promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required.

Sound Transit is an equal employment opportunity employer. No person is unlawfully excluded from employment action 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.

Seattle, Washington

Sound Transit is transforming how the Central Puget Sound region moves by planning, building and operating regional transit systems that give millions of riders an alternative to sitting in traffic. As the agency prepares for nearly a million new Central Puget Sound residents by 2040, transit services are expanding to meet today’s growing needs. Thanks to voter approval of the largest mass transit expansion in the region’s history, Sound Transit’s light rail system will grow to four times the size it is today. When complete, the 116-mile light rail system will stretch from Everett to Tacoma and connect major job and population centers in Seattle including South Lake Union, Seattle Center, Ballard and West Seattle. It will also extend east to Bellevue, Redmond, Issaquah and Mercer Island. As Sound Transit grows, we seek innovative, technical and creative professionals who are ready to come on board and make a difference. Career opportunities include Information Technology, finance, construction management and engineering positions. Apply today at

Similar jobs