Data Engineer

AC Transit is recruiting for a qualified Data Engineer. Under general direction, this position, performs moderate to complex duties in the development, installation, and administration of enterprise database platforms; Implements databases, data warehouses, big data streams, data lake, data mart, and application programming interface data integration; architects, builds and tests enterprise data warehouse, data ingestion, and data models including statistical methodologies to enable machine learning and artificial intelligence with training, scoring and predictive analytics; optimizes database performance, reliability and security of enterprise platforms for structured and unstructured data; conducts upgrades, migrations, programming, quality assurance, backup recovery, proactive monitoring, troubleshooting, and automation adhering best practices while serving as subject matter experts in database technologies.

This is an excellent opportunity to work 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.

• Implements and analyzes database and warehousing architecture, processes, and usage, typically in SQL Server,andidentifies and corrects database design and programming issues; establishes and monitors standards for the management of District databases; serves as a technical expert consulting with vendors,and District staff on database-related concerns including software patches, upgrades, and migrations.
• Engineers,enhances, integrates, and administers various enterprise application databases, data warehouses, big data streams, data lakes, data mart, application programming interface integrations, continuous integration/continuous delivery (CI/CD), and operations (DevOps) pipelines; architects, builds and tests enterprise data warehouse, data ingestion and data models including statistical methodologies to enable machine learning and artificial intelligence with training, scoring, and predictive analytics.
• Develops algorithms, routines, scripts, and data queries for programming interfaces among disparate sources; design data extracts, data normalization processes, and related automation for District-wide analysis; translate business requirements into technical solutions for business intelligence, machine learning, artificial intelligence, and data science harnessing statistics, software components, data models, simulation, descriptive and predictive analytics to identify trends, patterns.
• Uses a variety of analytics and tools for enterprise data reporting; creates, migrates, and enhances analytics and reporting platforms such as for cross-business systems and processes; sources interprets, and cleanses data banks to enrich data mining with the implementation of new mathematical methods and models to surface constructive patterns for data science exploration.
• Ensures the availability and integrity of enterprise database solutions and business applications to deliver high-level, business continuity; optimizes performance, reliability, and security of enterprise data platforms end-to-end for both structured and unstructured data; augments data warehouse, data lake, and big data streams; utilizes advanced database constructs including dynamic table partitions, indexed or materialized views, declarative or common language runtime objects, memory-based tables and geographic, spatial, hierarchical data models, and schema design.
• Safeguards database security, health, availability, regulatory compliance, capacity planning, coding standards, quality controls, backup recovery, access privileges, and overall database system long and short-term requirements in collaboration with management adhering toindustry best practices.
• Attends and participates in professional group meetings; stays abreast of new trends and technologies; researches emerging innovations for their applicability to the District.
• Performs related duties as required.
  
  

Education: Equivalent to a bachelor’s degree in computer science, mathematics, or a closely related field.

Experience: Five (5) years of progressively responsible experience in database technology, including development, administration, architecture, or data warehousing.

Desirable Skills:

• Experience with very large transactional systems, production support, database clustering, disaster recovery, storage, partitioning, Lambda Architecture
• Data Lakehouse architecture, Microsoft Data Platform and Warehousing, Power Platform, Azure DevOps, Salesforce Agentforce, and MuleSoft,
• Experience with Public Transit Software systems is preferred.
• Microsoft Certifications on Data Platform, Machine Learning, Large Language Model, and/or related certifications are preferred.

Special Requirements: Must be willing to: (1) work outside regular business hours as required and (2) travel between the various District locations

Physical Requirements:(1) Must maintain the physical condition necessary to perform tasks in an officesettingoperating a personal computer, keyboards, and other peripheral equipment. (2) Must possess the mobility necessary to transport oneself to other locations within the District, as required by the position.

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.

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)
• 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
• Ten (10) 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, 2020, 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