Job posting has expired

Scheduling Data Administrator

AC Transit
$111,825.00 - $133,567.00 Annually
United States, California, Oakland
January 29, 2023
Salary $111,825.00 - $133,567.00 Annually Location Downtown Oakland, CA Job Type Regular Full Time Department Planning & Engineering Job Number 22-00417 Summary 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. Representative Functions 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 electronic media. Serves as the Scheduling Department's desktop computer administrator in coordination with the HASTUS IS Project Manager. 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. Minimum Qualifications 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 applications. 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. Additional Information 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 AFSCME The 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 50%. 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 pension. 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 birthday holiday Tuition Reimbursement - up to $2500 per fiscal year on approved courses 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