Scheduling Systems Associate

Los Angeles County Metropolitan Transportation Authority • Los Angeles, CA

6d • Onsite

About The Position

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.

Requirements

• 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.
• Bachelor's Degree in Computer Science, Business, or a related field
• One year of relevant experience programming and developing reports using windows application programming languages, database management, and spreadsheet software
• 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
• Knowledge of theories, principles, and practices of personal computer business software applications, such as spreadsheet and database applications
• Knowledge of computer programming languages, such as Java, C, C++, C#, Visual Basic, and SQL
• Knowledge of data processing terminology and acronyms
• Knowledge of graphic user interface standards
• Knowledge of data communications
• Knowledge of database management systems and database objects, such as stored procedure, view and tables
• Knowledge of client/server enterprise network
• Knowledge of applicable business software applications
• Skill in performing basic programming in windows application languages and application macros
• Skill in designing data queries and user-oriented reports
• Skill in organizing and maintaining data files and process records in a business application area
• Skill in analyzing situations and identifying problems
• Skill in communicating effectively orally and in writing
• Skill in preparing reports and correspondence
• Skill in preparing user and systems documentation to industry standards
• Skill in interacting professionally with various levels of Metro employees and outside representatives
• Skill in using various input devices for extracting and utilizing data
• Skill in operating personal computers, general office equipment, and data processing applications
• Ability to compile, analyze, and interpret complex data
• Ability to follow oral and written instructions
• Ability to understand, interpret, and apply laws, rules, regulations, policies, and procedures
• Ability to travel to offsite locations
• Ability to read, write, speak, and understand English

Nice To Haves

• 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

Responsibilities

• 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

Benefits

• Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions
• Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out
• 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.
• Metro does not deny participation in the application process to anyone with prior justice system involvement, in line with Fair Chance hiring practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level