Scheduling Data Administrator
Company: AC Transit
Posted on: January 17, 2023
$111,825.00 - $133,567.00 Annually
Downtown Oakland, CA
Regular Full Time
Planning & Engineering
AC Transit is actively recruiting for the position of Scheduling
Data Administrator in the Scheduling Department. Under general
supervision; serves as the technical administrator and advanced
user of the HASTUS computer assisted scheduling system for the
Traffic and Schedules unit of the Service Development department..
This is an excellent opportunity to work in Scheduling at one of
the largest bus agencies in California. In addition to working with
some of the best in the business, AC Transit also has an
outstanding benefits package that includes pension, medical, dental
and vision coverage, flexible spending and a 457 savings plan.
- Serves as the Scheduling unit's primary technical
administrator, and coordinates with appropriate Information
Services (IS) staff to ensure seamless transmission of scheduling
data to and from the various IS systems.
- Monitors, maintains, and reports data using the advanced
functions of the Hastus scheduling software.
- Designs data solutions, and generates data files to provide
HASTUS data to downstream computer systems and other District
departments and stakeholders.
- Designs data queries using the HASTUS desktop, structured query
language (SQL), and the HASTUS OIG/d programming language. Develops
applications and uses software functions in the scheduling system
to analyze and recommend changes for scheduling procedures and/or
distribution of scheduling reports, both in hard copy and
- Serves as the Scheduling Department's desktop computer
administrator in coordination with the HASTUS IS Project
- Collects, prepares and analyzes on-time performance, ridership,
and other data in support of the National Transit Database
reporting requirements; including the timely delivery of monthly,
quarterly, and annual deliverables.
- Confers with staff of the Traffic & Schedules unit, Service
Development department, and Operations to track quarterly route,
stop, and system improvements for the preparation of accurate data
in support of the quarterly sign-up; as well as other technology
systems using scheduling data.
- Reports, monitors, and documents HASTUS system functions and
customizations; and resolves data errors identified by systems
using HASTUS scheduling data, and supports system testing.
- Performs related duties as required.
Education/Training: Equivalent to a Bachelor's Degree from an
accredited college or university with major coursework in
Transportation, City, or Regional Planning; Urban Studies;
Geography; Geographic Information Systems (GIS), Public
Administration; computer programming, or a related field.
Experience: Four (4) years of increasingly responsible experience
in Transportation Planning or systems/scheduling analysis in a
large urban public transportation system, including at least two
(2) years in a professional capacity working with HASTUS, CAD/AVL,
raw data files, GIS software, and GIS based scheduling
Desired Qualifications: Extensive experience using large and
complex data sets; analyzing solutions to ensure data integrity and
quality; demonstrated ability with SPSS statistical software;
experience supervising subordinate staff and/or consultants; and
excellent verbal and written communication skills.
Must maintain the physical condition necessary to: (1) perform
tasks in an office setting operating a personal computer,
keyboards, and other peripheral equipment; and (2) possess physical
mobility in order to conduct field studies.
THIS POSITION IS A UNION POSITION, REPRESENTED BY AFSCMEThe
Selection Process: The Human Resources department must receive a
completed online application by the filling date. If this
recruitment is "Continuous," it may be closed at any time without
notice. Applications will be screened for job related
qualifications, and those candidates who best meeting the
qualifications listed on this Job Announcement will be invited to
participate in an examination process that may include written,
oral and/or performance segments. Current District employees must
have satisfactory attendance and performance records. Finalists
will be placed on an Eligibility List. When filling vacancies, the
Human Resources Department will refer the top candidates to the
hiring department for final screening and recommendation.
Vaccination Requirement for Candidates Seeking Employment:
Alameda-Contra Costa Transit District has implemented a requirement
that requires all candidates for District employment to be fully
vaccinated for COVID-19, including variants, prior to being
employed by the District, subject to limited exceptions. AC Transit
adopted this vaccination policy as an emergency public health
response to mitigate the negative public health consequences
associated with increased incidence and test positivity rates and
the prevalence of new virus variants, including increased
hospitalizations, intensive care unit admissions, and deaths.
As such, candidates seeking District employment will be required
to: (1) be fully vaccinated (two weeks after completion of the
entire recommended COVID-19 vaccination series) and (2) submit a
copy of their COVID-19 vaccination card prior to their start date,
unless a reasonable accommodation request for a medical or
religious exemption has been approved.
Benefits: The transit professionals who call AC Transit home
represent the rich cultural diversity of the Bay Area. For more
than 60 years, we have been an equal opportunity employer honoring
religion, ethnic background, national origin, gender, gender
expression, genetic information, disabilities, age, and veteran
status. We are not only an inclusive employer but also offer a
comprehensive benefits package rooted in choice, flexibility, and
affordability. Most benefits are effective the first of the month
following your hire date. Employees and eligible dependents have
access to the following benefits*:
- Medical - Choice of two Health Maintenance Organizations
(HMOs): Kaiser Permanente and Health Net. $10.00 office visit
co-pays; $5.00 - $35.00 prescription co-pays.
- Dental - MetLife Preferred Provider Organization (PPO) $50
annual deductible per person/$150 per family; $3,000 per person
annual maximum; preventative care covered at 100%; basic and major
care covered at 90%; $4,000 lifetime maximum orthodontia covered at
- Vision - Vision Service Plan - $10.00 copay; eligible for an
exam, lenses, frames or contact lenses every 12 months - based on
the last date of service. $200 frame allowance or $120 allowance
for contact lenses.
- Employer paid Basic Life Insurance
- Employee paid Voluntary Term Life Insurance
- Employee Assistance Program (EAP)
- Retirement - employees automatically participate in a lifetime
defined benefit plan and have the option to contribute to a 457
deferred compensation plan via payroll deductions. All employees
hired on or after January 1, 2016 may be in the District's Tier II
pension plan covered by the Public Employees' Pension Reform Act of
2013 (PEPRA). As such, employee may be required to contribute a
small portion of annual income towards the cost of the
- Flexible Spending Accounts (FSA) for Health Care, Dependent
Care, Parking, Transit
- AC Transit contributes up to $50.00/month towards an employee's
FSA Transit costs
- Free AC Transit Bus Pass
- Federal Credit Union
- Vacation and Sick Leave or Personal Time Off
- Nine (9) paid holidays; 2 paid floating holidays; 1 paid
- Tuition Reimbursement - up to $2500 per fiscal year on approved
- Wellness Program*AC Transit benefits are negotiated and subject
to change based on collective bargaining agreements.
Pension: All AC Transit employees participate in a lifetime defined
benefit pension. All employees hired on or after January 1, 2016,
may be in the District's Tier II pension plan covered by the Public
Employees' Pension Reform Act of 2013 (PEPRA). As such, he/she may
be required to contribute a small portion of annual income towards
the cost of his/hers District pension.
ADA Compliant and Drug Free Workplace: The Human Resources
Department will make reasonable efforts in the
recruitment/examination process to accommodate applicants with
disabilities. If you have a need for an accommodation, please call
Human Resources at (510) 891-4783.
The Alameda Contra Costa Transit District has established the goal
of a 100 percent drug and alcohol-free workplace. Applicants will
be required to undergo drug and alcohol testing prior to employment
and those in safety sensitive positions will be subject to further
drug and alcohol testing through their period of employment,
including random drug and alcohol testing.
In accordance with federal requirements, all job applicants
selected for appointments in a safety sensitive position are
subject to pre-employment drug and alcohol testing. A final job
applicant will be tested for five prohibited drugs: Cocaine, PCP,
Amphetamines, Marijuana and Opiates. During employment, employees
holding safety sensitive positions are subject to random,
reasonable suspicion, post-accident, return-to-duty, and follow-up
drug and alcohol testing. Additionally, in the event of an absence
of more than 90 days from a safety sensitive position,
pre-employment drug testing will be performed.
Equal Opportunity Employer
Keywords: AC Transit, Oakland , Scheduling Data Administrator, Other , Oakland, California
Didn't find what you're looking for? Search again!