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.
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.
• 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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)