Scheduling Systems Associate - Los Angeles, United States - Los Angeles County Metropolitan Transportation Authority

Los Angeles County Metropolitan Transportation Authority

Verified Company

Los Angeles, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Public Transportation Services Corporation (PTSC)
PTSC is an equal employment opportunity employer

Non-Represented EMPLOYMENT OPPORTUNITY

Bulletin No:

Job Title:
SCHEDULING SYSTEMS ASSOCIATE (
TRANSPORTATION OPERATIONS DATA SCIENCE SPECIALIST)

Specialty:

TRANSPORTATION OPERATIONS DATA SCIENCE SPECIALIST

Closing Date:24-MAY-24

Salary Grade:
H1H

Salary Range:
$61,069 - $76,294 - $91,562

External/Internal:

EXTERNAL

Basic Function

Example Of Duties

Maintains and modifies departmental computer software systems
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 ongoing 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
Generates automated reports using client/server and personal computers
Conducts special studies/research projects as assigned
Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out

May be required to perform other related job duties

Requirements For Employment

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

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 jobrelated essential functions
May work overtime as required

Knowledge:

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

Skills:

Designing data queries and useroriented reports
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

Abilities:

Compile, analyze, and interpret complex data
Follow oral and written instructions
Travel to offsite locations
Read, write, speak, and understand English

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

Telephone:
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.(OM)

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.