City of El Monte- systems Administrator ( Data)
11/5/2019 8:06:48 PM 748
- Salary$4,950.83 - $7,072.67 Monthly $59,410.00 - $84,872.00 Annually
$59,410.00 - $84,872.00 Annually
Location El Monte, CAEl Monte, CA
Job Typefull-time
DepartmentInformation Technology
Job Number2019-10
Closing date and timeContinuous
Max Number of Applicants75
Are you looking for a challenge? Do you want to contribute to your community and help make an impact in the paratransit industry? Access Services is seeking a highly skilled and analytical Systems Administrator (Data). When you join Access Services, you can expect a fast-paced environment, ongoing projects to improve paratransit service, and you will find a cohesive and committed workforce environment.
The Systems Administrator (Data) is an essential contributor to Access Services' IT team. Reporting to the Director of Information Technology, the Systems Administrator (Data) is responsible for supporting, expanding and optimizing our data and data pipeline architecture, optimizing data flow and collection for cross-functional teams. This position performs critical database maintenance, converting paratransit data for business presentation utilizing Tableau and Rider360 and different systems according to business needs. Additionally, the Systems Administrator(data) will be responsible for ensuring data is accurate, presentable, and completed on time.
Technology is the core to Access Services' operations; extending to operations, finance, human resources, fleet, customer services, planning, services providers and most importantly, our riders utilizing paratransit services. Access Services' IT plays a crucial roles in the public transit industry by leading the assistive technology implementation to enhance the life of disabled communities and riders. We have successfully introduced real-time vehicle location mobile apps, online reservation systems and an online eligibility registration system to mobilize our riders. We are continuing with our focus on accessible and autonomous vehicles, artificial intelligence and machine learning, in conjunction to wayside guidance and BLE beacon to enhance our services. Be part of the technology team at Access Services where your contributions will directly help enhance our community.
SUPERVISORY RESPONSIBILITIES:
None.
WHO WE ARE:
Access Services, a local public entity, is the Los Angeles County Consolidated Transportation Services Agency ("CTSA") and administers the Los Angeles County Coordinated Paratransit Plan ("Plan") on behalf of the County's 45 public fixed route operators (i.e., bus and rail). Pursuant to the Plan, Access facilitates the provision of complementary ADA paratransit services to certain persons with disabilities as required by 42 U.S.C. §12143 under the name "Access Paratransit." Paratransit is an alternative mode of flexible passenger transportation that does not follow fixed routes or schedules.
OUR LOCATION:
Access Services headquarters is located in METRO's Division 9, El Monte Station. The new El Monte Station, which opened on October 14, 2012, was expanded to more than double its size, with a two-level bus terminal station with 29 bays. The state-of-the-art facility, the largest west of Chicago, is a major regional transfer center serving 22,000 Metro, Foothill Transit, El Monte Transit and Greyhound passengers daily, with the potential to accommodate nearly twice that capacity. The El Monte Station connects the San Gabriel Valley to Downtown LA and the rest of the Metro bus and rail system via the Metro Silver Line. Additionally, adjacent to the El Monte Station a new development, Gateway Plaza, is in the construction process and will be a complex combining residential and commercial spaces. Transportation, shopping, and dining – all within short walking distances.
WHAT WE BELIEVE:
Mission: Access Services promotes access to all modes of transportation and provides quality and safe ADA paratransit service on behalf of public transit agencies in Los Angeles County.
Vision: Access Services serves the community as the leader in promoting accessible and innovative transportation solutions. We accomplish this vision by:- Providing quality, efficient, safe and dependable ADA paratransit service.
- Leading the national dialogue as an advocate for universal access to transportation.
- Partnering with other entities to secure alternate funding sources and legislation that expands transportation options.
IMPORTANT APPLICATION INFORMATION AND INSTRUCTION
Applications will be accepted on a continuous basis until a sufficient number of qualified applications have been received. The deadline for the first review of applications is on Friday, November 15, 2019 at 12:00 PM. Applicants are encouraged to apply early. Applicants that apply after the first review are not guaranteed to be considered for this recruitment. This recruitment may close at any time without notice after the first review date.
The selection process will consist of a minimum of an oral interview. Tentative Interviews are scheduled the week of November 21, 2019, and November 25, 2019. - Examples of Duties
- Duties may include, but are not limited to, the following:
- Create and maintain optimal data pipeline architecture;
- Assemble large, complex data sets that meet functional and non-functional business requirements;
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.;
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL;
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics;
- Work with stakeholders including the Executive and Operations teams to assist with data-related technical issues and support their data infrastructure needs;
- Keep our data separated and secure across different service regions;
- Work with data and analytics experts to strive for greater functionality in our data systems;
- Manage Tableau application;
- Maintain/create reporting requirement via Tableau to fulfill business needs; and
- Other duties as assigned.
- Typical Qualifications
- QUALIFICATIONS: A combination of education, experience, and training that has provided the necessary knowledge, skills, and abilities is required for entry into the classification. Reasonable accommodations to enable qualified individuals with disabilities to perform the essential functions may be made. A typical combination includes:
EDUCATION: Bachelor's Degree (BA, BS) from an accredited four-year college or university with major coursework in business, mathematics, information systems, computer science or a closely related field.
EXPERIENCE: Three years of increasingly responsible database management experience, which includes designing schemas, maintaining databases, analyzing data, and SQL-programming or equivalent for public sector or transit agencies. A combination of education and experience may be considered. An advanced graduate degree is highly desirable.
CERTIFICATES: Certification in the following programs is highly desirable:
PMP, Tableau, ESRI Developer/Enterprise Associate.
Preferred Qualifications:- Experience with big data tools: Hadoop, Spark, Kafka, etc.;
- Experience with relational SQL and NoSQL databases, including Postgres and Cassandra;
- Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.;
- Experience with Azure cloud services: Kubernetes;
- Experience with .Net, C#, Python, Ruby development tools;
- Experience with ESRI web application development and Enterprise Geodata Management; and
- Have a strong appreciation for customer service and service quality improvement.
KNOWLEDGE, SKILLS, AND ABILITIES:
KNOWLEDGE OF:- SQL and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
- Message queuing, stream processing and highly scalable 'big data' data stores.
- Tableau administration and reporting.
- MS SQL database integration with geospatial maps.
SKILL IN:- Communicating effectively in English, both written and verbally.
- Drafting reports, business correspondence and procedural manuals.
- Working with unstructured datasets, building processes to support data transformation, data structures, metadata, dependency and workload management.
- Project management, organization, and meeting timelines.
- Present information and responding to questions from a variety of groups from managers, to clients, customers, and the general public.
ABILITY TO:
- Define problems, collect data, establish facts, and draw valid conclusions.
- Interpret an extensive variety of technical instructions.
- Perform root cause analysis on internal and external data.
- Find business solutions and identify opportunities for improvement.
- Build and manage relationships across functional areas and services providers.
- Supplemental Information
- Application Procedure: All applicants are required to complete and submit Access Services application form online. Resumes or faxed copies will not be accepted in lieu of the online application. To apply, click on the "Apply" link located at the top of this page. New users must create an account first.
Selection Procedure: Applicants will be screened and evaluated for relevant training and experience. Only those applicants determined to be among the most qualified may be invited to participate in the selection process. The selection process may consist of any combination of written, performance, and/or oral appraisal exams. Examination parts will be weighed according to their relevancy to the job performance criteria. Applicants passing the selection criteria will be placed on an eligibility list. Eligible lists may exhaust at any time.
Vacancy information: The resulting eligible list will be used to fill vacancies as they occur. Eligible lists may expire or exhaust when the eligibility pool is insufficient to draw from.
OTHER REQUIREMENTS:
Pre-employment: All potential employees are required to successfully pass a post offer pre-employment medical examination (which will include a drug/alcohol screening) and satisfactory results from an administrative screening.
Immigration and Reform Control Act: In compliance with the Immigration and Reform Control Act of 1986, Access Services will only hire individuals who are legally authorized to work in the United States. Access Services does not provide sponsorship.
E -Verify: Access Services is an E-Verify employer. E-Verify is an internet based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA) that allows participating employers to electronically verify the employment eligibility of newly hired employees in the United States. Access Services does not sponsor H-1B or related work visas.
An Equal Opportunity Employer: Access Services is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, Access Services will provide reasonable accommodations to qualified individuals with disabilities.
The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this class. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical Demands: The position requires constant sitting and occasional walking and
standing. The employee is expected to talk and hear, with staff, vendors, and the public in person and by telephone. Specific vision abilities required by this job include close vision and the ability to adjust focus. The employee uses hands to operate, finger, handle or touch office equipment; and reach with hands and arms. The employee bends, stoops, or squats to access, place and retrieve files, supplies and records, and reaches, lifts, and move records and documents weighing up to 20 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus to read and operate office equipment as necessary during the course of the work assignments.
Mental Demands: Employees are regularly required to use written and oral communication skills; read and interpret data; use math and mathematical reasoning; analyze and solve problems; learn and apply new information; perform highly detailed work on multiple, concurrent tasks; meet intensive and changing deadlines and interact with staff, customers, vendors, contractors, and the public.
WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job:
Noise Level: The noise level in the office environment is usually quiet or moderately quiet; at or below 85 decibels. In the course of employment, employee may visit service provider or other contractor's premises, which may include limited exposure to outdoor weather conditions, or fumes or airborne particles from motor vehicles.
Note: The statements herein are intended to describe the general nature and level of work being performed by employees to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, skills, or abilities required of personnel so classified.
- Agency
- Access Services
- Phone
- 213-270-6000
- Website
- http://www.accessla.org
- Address
- PO Box 5728
El Monte, California, 91734
图片翻摄自网路，版权归原作者所有。如有侵权请联系我们，我们将及时处理。