SENIOR SCHEDULING SYSTEMS ANALYST

Provides on-going paraprofessional computer programming support on numerous software applications in the preparation, compilation, and reporting of scheduling Transit Operations data; provides information to users and upper management by collecting, analyzing, and transforming data from various system sources and uploading to database tables; and troubleshoots and provides solutions to address issues as needed. Performs lead work in systems development, data storage, and technical analysis in support of complex computerized scheduling systems.

Recruitment Timelines: Interviews are projected to be scheduled for the week of August 31, 2026. This date is subject to change. We encourage you to monitor your governmentjobs.com profile and emails for the latest updates.

• Reviews, integrates, and analyzes transit operations databases needed to produce meaningful reports to be used in evaluating and improving transit service, as well as reporting performance measures
• Develops, enhances, tests, maintains, and supports computer applications for schedule planning and data collection systems
• Monitors, maintains, and enhances performance and reliability of automated systems through programming, development, and modifications
• Provides lead support to staff for data processing of raw data
• Creates ad hoc queries, macros, and procedures for computerized automation
• Coordinates with consultants, inter-organization departments, and operating divisions to collect National Transit Database (NTD) and scheduling data to build better scheduling systems
• Complies with requests for regular or ad hoc reports
• Performs computer systems analysis and design for performance reporting and operations planning application systems
• Interacts with and provides subject matter expertise to Operations Management staff, consultants, and IT (Information Technology) staff for developing, testing, and implementing new systems and enhancing existing systems
• Contributes to the development of Requests for Proposal (RFPs), including assisting in the development of Scope of Work, participating in the procurement process, and overseeing project after award
• Represents supervisor as directed

May be required to perform other related job duties

A combination of education and/or experience that provides the required knowledge, skills, and abilities to perform the essential functions of the position. Additional experience, as outlined below, may be substituted for required education on a year-for-year basis. A typical combination includes:

Education

• Bachelor's Degree in Computer Science or a related field

Experience

• Five years of relevant experience developing, operating, or supporting application systems in a client/server environment with at least two years of experience in relational database management; transportation planning or scheduling experience preferred

Certifications/Licenses/Special Requirements

• A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions
• On-call work and travel as required

 Preferred Qualifications

Preferred Qualifications (PQs) are used to identify relevant knowledge, skills, and abilities (KSAs) as determined by business necessity. These criteria are considered preferred qualifications and are not intended to serve as minimum requirements for the position. PQs will help support selection decisions throughout the recruitment. In addition, applicants who possess these PQs will not automatically be selected.

The following are the preferred qualifications:

• Experience analyzing large sets of data to identify trends and inform strategic decision-making
• Experience writing SQL queries to create custom reports and to facilitate data movement between servers
• Experience creating reports using Business Intelligence tools such as PowerBI, or similar software

Knowledge of (defined as a learned body of information that is required for and applied in the performance of job tasks)

• Current relational database management techniques
• Applicable local, state, and federal laws, rules, and regulations governing transportation policies for a public agency
• Theories, principles, and processes required in database design, development process, entity-relationships, business rules, structural constraints, and data administration and warehousing
• Web application development
• Products used in Business Intelligence Reporting
• Project management techniques

Skill in (defined as the proficient manual, verbal, or mental utilization of data, people, or things)

• Coordinating application development and programming activities
• Writing complex computer programs using SQL (Structured Query Language), Visual Basic, .Net, and other languages
• Creating Business Intelligence (BI) Analysis, dashboards, and Key Performance Indicators (KPIs)
• Analyzing situations, identifying problems, and recommending solutions
• Communicating effectively orally and in writing
• Preparing comprehensive reports and correspondence
• Interacting professionally with various levels of Metro employees and outside representatives

Ability to (defined as a present competence to perform an observable behavior or produce an observable result)

• Learn and use a programming language to formulate job queries and ad hoc codes for data extraction
• Understand, interpret, and apply laws, rules, regulations, policies, procedures, contracts, budgets, and labor/management agreements
• Provide leadership to staff
• Travel to offsite locations
• Read, write, speak, and understand English

Special Conditions

• This job specification is not to be construed as an exhaustive list of duties, responsibilities, or requirements
• The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job
• Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions
• This classification is at-will and the incumbent serves at the pleasure of the hiring authority when classified as an Intermittent, Emergency, Annuitant, or Temporary employee, is assigned to the Office of Inspector General (OIG) or Board Clerk's Office, and/or reporting directly to the LACMTA Board of Directors
• Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out

Working Conditions

• Typical office situation
• Close exposure to computer monitors and video screen

Physical Effort Required

• Sitting at a desk or table
• Operate a telephone or other telecommunications device and communicate through the medium
• Type and use a keyboard and mouse to perform necessary computer-based functions
• Communicating through speech in the English language required

NW