SCHEDULING SYSTEMS ASSOCIATE (TRANSPORTATION OPERATIONS DATA SCIENCE SPECIALIST)

La Métro (Grenoble Alpes Métropole) - Los Angeles, CA

Full-time - Mid Level

Los Angeles, CA

1-10 employees

About the position

The Scheduling Systems Associate (Transportation Operations Data Science Specialist) at LA Metro is responsible for providing ongoing computer programming support for various software applications related to Transit Operations data. This role involves collecting, analyzing, and transforming data from multiple sources, troubleshooting issues, and generating automated reports to assist management and users in decision-making processes.

Responsibilities

• Maintains and modifies departmental computer software systems.
• Designs, develops, and maintains several web applications using Visual Basic .NET (VB.NET).
• Writes, debugs, and optimizes complex SQL and stored procedures in SQL Server Management Studio.
• 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 automated reports regarding Transit Operations.
• Provides ongoing support on data extractions and loading processes.
• Prepares departmental computer systems documentation and reports, including charts and flowcharts.
• Coordinates with Information Technology Systems department staff for program development.
• Works with infrastructure teams to upgrade SQL server.
• Identifies, documents, and corrects performance problems in data files.
• Evaluates data management procedures and recommends system improvements.
• Trains department personnel in client/server and personal computer applications.
• Serves as a technical resource for team members and users.
• Generates automated reports using client/server and personal computers.
• Conducts special studies/research projects as assigned.

Requirements

• 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 alternative transportation.

Nice-to-haves

• Experience with Java, C, C++, C#, and Visual Basic programming languages.
• Familiarity with data processing terminology and database management systems.

Benefits

• Dental insurance