SCHEDULING SYSTEMS ASSOCIATE

Metro’s mission is to provide a world-class transportation system that enhances the quality of life for all who live, work, and play within LA County.

Description

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.

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

Examples of Duties

• Maintains and modifies departmental computer software systems
• Designs, develops, and maintains several web applications using Visual Basic .NET (VB.NET) programming language
• Writes, debugs, and optimizes complex SQL (Structured Query Language) and stored procedures in SQL Server Management Studio software
• Designs and programs departmental utility programs, macros, data queries and reports
• Serves as backup support for the GIRO's HASTUS scheduling module
• Compiles and analyzes transit surveillance data for use in developing and updating departmental automated reports regarding Transit Operations
• Provides on-going support on data extractions and loading processes
• Prepares departmental computer systems documentation and reports, including charts, flowcharts, diagrams, and code comments
• Coordinates with and assists Information Technology Systems department staff in developing and modifying client/server and personal computer programs for departmental use
• Works with the infrastructure teams to upgrade SQL server
• Identifies, documents, and corrects performance problems in data files or other data sources
• Evaluates data management procedures and recommends system improvements
• Trains department personnel in use of client/server, network, and personal computer hardware and software applications
• Serves as technical resource and assists team members and users with questions and problem solving related to client/server, personal computer systems, and software applications
• Generates automated reports using client/server and personal computers
• Conducts special studies/research projects as assigned

May be required to perform other related job duties

Minimum Qualifications

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, Business, or a related field

Experience

• One year of relevant experience programming and developing reports using windows application programming languages, database management, and spreadsheet software

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
• May work overtime 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 Power BI, or similar software

Essential Knowledge

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

• Theories, principles, and practices of personal computer business software applications, such as spreadsheet and database applications
• Computer programming languages, such as Java, C, C++, C#, Visual Basic, and SQL
• Data processing terminology and acronyms
• Graphic user interface standards
• Data communications
• Database management systems and database objects, such as stored procedure, view and tables
• Client/server enterprise network
• Applicable business software applications

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

• Performing basic programming in windows application languages and application macros
• Designing data queries and user-oriented reports
• Organizing and maintaining data files and process records in a business application area
• Analyzing situations and identifying problems
• Communicating effectively orally and in writing
• Preparing reports and correspondence
• Preparing user and systems documentation to industry standards
• Interacting professionally with various levels of Metro employees and outside representatives
• Using various input devices for extracting and utilizing data
• Operating personal computers, general office equipment, and data processing applications

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

• Compile, analyze, and interpret complex data
• Follow oral and written instructions
• Understand, interpret, and apply laws, rules, regulations, policies, and procedures
• 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
• Type and use a keyboard and mouse to perform necessary computer-based functions
• Communicating through speech in the English language required

NW

Metro is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, ancestry, national origin, gender, marital status, sexual orientation, religion, age, veteran status, or disability. Learn more about Metro’s Equal Employment Opportunity Program . Metro does not deny participation in the application process to anyone with prior justice system involvement, in line with Fair Chance hiring practices.

Selection Procedure

Applicants who best meet job-related qualifications will be invited to participate in the examination process that may consist of any combination of written, performance, or oral appraisal to further evaluate job-related experience, knowledge, skills and abilities.

Application Procedure

To apply, visit Metro's website at www.metro.net and complete an online Employment Application.
Computers are available to complete online Employment Applications at the following Metro locations:

METRO Headquarters, Employment Office
One Gateway Plaza
Los Angeles, CA 90012
Open: Monday through Friday, 8am-4pm
(Closed Sat & Sun)

Metro Talent Hub
8501 S. Evermont Place
Los Angeles, CA 90044
Open: Monday through Friday, 9am-5pm
(Closed Sat & Sun)

East Los Angeles Customer Center
4501 B Whittier Blvd
Los Angeles, CA 90022
Open: Tuesday through Saturday, 10am to 6pm
(Closed Sun & Mon)

Wilshire/Vermont Customer Center
3183 Wilshire Blvd, Ste 174
Los Angeles, CA 90010
Open: Monday through Friday, 10am-6pm
(Closed Sat & Sun)

Rosa Parks Customer Center
Willowbrook/Rosa Parks Station
11720 Wilmington Ave
Los Angeles, CA 90059
Open: Monday through Friday, 6am to 6:30pm
(Closed Sat & Sun)

Telephone: (213) 922-6217 or persons with hearing or speech impairments can use California Relay Service 711 to contact Metro.

All completed online Employment Applications must be received by 5:00 p.m. on the closing date. Late applications will not be considered.

*Open to the public and all Metro employees

This job bulletin is not to be construed as an exhaustive list of duties, responsibilities, or requirements. Employees may be required to perform other related job duties.

*Please refer to the applicable benefit type (Regular or Temporary)*

BENEFITS FOR REGULAR EMPLOYEES

Benefits cover probationary or regular full-time (working at least 40 hrs/week) employees of Metro.

We offer a range of high-quality medical, dental and vision plan options as well as health care spending accounts for you and your family. Metro will cover a significant portion of your health care premiums.

Medical/Dental/Vision Plan - Employee has the choice of 3 separate medical plans and 3 dental plans. A separate vision plan is included in each medical plan.

Group Life Insurance - PTSC pays for an amount equal to your annual salary, rounded up to the nearest $1,000. Minimum amount of life insurance is $30,000.

Accidental Death & Dismemberment Insurance - PTSC provides $50,000 coverage for each employee. Additional voluntary coverage in amounts up to $500,000 is available at favorable premium rates.

Long-Term Disability Insurance - 100% employer paid. Provides employees with a minimum income of 60% of earnings after six months of disability. Buy up or buy down options available.

Holidays - 12 days a year: New Year's Day, Martin Luther King, Jr. Day, Presidents' Day, Memorial Day, Independence Day, Labor Day, Veterans' Day, Cesar E Chavez, Juneteenth,Thanksgiving Day, Day After Thanksgiving, and Christmas Day.

Time off with Pay (TOWP) - Compensates employees who are on approved absence from work for reasons such as illness, injury, medical and dental appointments, personal business, vacation, or observance of (a) religious holiday.
Years of Service Annual Accrual
Hire date - 5 years 20 days
Beginning of 6th - 10th year 25 days
Beginning of 11th - 15th year 30 days
Beginning of 16th + years 35 days

Pension Plan - PTSC retirement plan is the Public Employees' Retirement System (PERS). Vesting is five (5) years. Minimum retirement age is 52, based on the 2% at 62 formula.

Other Benefits: Transportation passes for employees and/or eligible dependents; Medicare; Tuition reimbursement; credit union membership; SDI; Deferred Compensation Plan; 401(K) Thrift plan; EAP; Medical and Dependent Care Flexible Spending Accounts; Flexible work schedules; and Jury Duty Pay.

BENEFITS FOR TEMPORARY EMPLOYEES

Temporary (Contingent) employees are eligible for the following benefits only:

• Kaiser medical insurance
• Public Pension Plan
• 457/401K Plan
• Flex Spending
• Paid Sick Time
• Fare Media
• Rideshare Subsidies
• Metro One Fitness membership

For more information on the Benefits Enrollment for Contingent Employees, please visit LA Metro’s Pension & Benefits website at benefits.metro.net

Closing Date/Time: 8/18/2026 5:00 PM Pacific

Los Angeles County Metropolitan Transportation Authority - LA Metro

Show more