Data Warehouse Administrator I/II

Are you passionate about transforming data into meaningful insights that help organizations make better decisions? Join our team as a Data Warehouse Administrator I and help build, support, and improve enterprise data solutions that power reporting, analytics, and operational decision-making across VTA.

In this role, you will contribute to the development and support of data pipelines, ETL/ELT processes, data integrations, and analytical solutions that bring together information from multiple enterprise systems. You will work with SQL, programming languages, modern data tools, and reporting platforms while helping ensure data accuracy, reliability, and quality.

You will collaborate with experienced data engineers, technology teams, and business stakeholders to understand data needs, troubleshoot issues, document solutions, and deliver reliable data products that support reporting, automation, and analytics.

Whether you are starting your career in data engineering or looking to grow your skills in enterprise data platforms, this is an opportunity to work with modern database technologies, cloud data solutions, APIs, automation tools, and analytics platforms while contributing to initiatives that have a meaningful impact on public transportation and the community we serve.

About the Technology Department

The Technology Department strives to provide the highest quality technology-based services and solutions, in the most cost-effective manner, to facilitate the needs of our customers within VTA and the customers VTA serves.  

Definition

Under general supervision, the Data Warehouse Administrator I builds and maintains data processing systems and pipelines that combine core data sources into accessible structures to support reporting and analytical systems.

Distinguishing Characteristics

This is the entry and first working level of the Data Warehouse Administrator series. This class performs work of routine and average difficulty.  Incumbents will initially perform tasks under close supervision. Tasks performed by the Data Warehouse Administrator I will be in a learning capacity. As knowledge and skill increases, the incumbent will perform work more independently.   Incumbents at this level are involved with developing, coding, testing, and implementing data extract, transform, and load (ETL) processes.

The Ideal Candidate

The ideal candidate is a collaborative and analytical data professional with foundational experience developing and supporting data solutions. They have a strong understanding of relational databases, SQL, ETL/ELT concepts, data integration, data transformation, and data quality principles. They enjoy solving data challenges, developing reliable data pipelines, and transforming raw data into accessible information that supports reporting, analytics, and business decision-making.

Successful candidates demonstrate the ability to work with data from multiple sources, troubleshoot data processing issues, validate data integrity, and communicate effectively with both technical and non-technical stakeholders. They are detail-oriented, organized, curious, and committed to continuous learning. They are capable of supporting data initiatives throughout the data lifecycle, including requirements gathering, development, testing, documentation, implementation, and ongoing support.

The ideal candidate has exposure to modern data technologies, including cloud-based data platforms, APIs, automation, scripting languages, and data engineering frameworks. They are eager to expand their technical skills, collaborate with experienced team members, and contribute to improving enterprise data capabilities.

For the Data Warehouse Administrator II, the ideal candidate also brings progressively responsible experience independently designing, implementing, administering, and optimizing enterprise data warehouse solutions.

About VTA 

The Santa Clara Valley Transportation Authority employs more than 2,000 people dedicated to providing solutions that move Silicon Valley. Unique among transportation organizations in the San Francisco Bay Area, VTA is Santa Clara County’s authority for transit development and operations (light rail and bus), congestion management, transportation-related funding, highway design and construction, real estate and transit-oriented development, and bicycle and pedestrian planning. With local, state, and federal partners, VTA works to innovate the way Silicon Valley moves and provide mobility solutions for all. 

Santa Clara Valley Transportation Authority (VTA) is an independent special district that provides sustainable, accessible, community-focused transportation options that are innovative, environmentally responsible, and promote the vitality of our region.

VTA provides bus, light rail, and paratransit services, as well as participates as a funding partner in regional rail service including Caltrain, Capitol Corridor, and the Altamont Corridor Express.

As the county’s congestion management agency, VTA is responsible for countywide transportation planning, including congestion management, design and construction of specific highway, pedestrian, and bicycle improvement projects, as well as promotion of transit oriented development.

VTA provides these services throughout the county, including Campbell, Cupertino, Gilroy, Los Altos, Los Altos Hills, Los Gatos, Milpitas, Monte Sereno, Morgan Hill, Mountain View, Palo Alto, San Jose, Santa Clara, Saratoga and Sunnyvale. VTA continually builds partnerships to deliver transportation solutions that meet the evolving mobility needs of Santa Clara County.
As we continue to implement our VTA Forward Plan, we aim to strengthen and increase our workforce to take on future opportunities and challenges by elevating our people and our services. 

For more information about our VTA Forward Plan, visit: https://www.vta.org/VTAForward

Family-Friendly Workplace Certification Program (FFWCP)

The County of Santa Clara FFWCP recognizes VTA as a business that creates supportive workplaces for employees and their families.

Family-friendly workplaces improve health outcomes and job satisfaction for employees and increase work productivity and retention for employers. Employers can create a family-friendly workplace by meeting and exceeding state and federal employment laws relating to parental leave, lactation accommodation, and work/family balance.

Typical Tasks

• Develops, implements, and maintains data transformation and automation process using a variety of technologies to support business systems and data flows;
• Builds and maintains scalable data pipelines to ingest data into data warehouse from various sources;
• Performs data conversions, executes the import and export of data within and between internal and external software systems;
• Analyzes source dataset, and data relationship to automate recurring reports and analytics workflows 
• Troubleshoots data processing tools, systems, and software applications;
• Performs data validation and reconciliation to ensure data accuracy and integrity;
• Monitors system performance and capacity in accordance with defined service level agreements;
• Maintains the quality and integrity of data repositories by adding, modifying, and deleting data in accordance with established policies and business decisions;
• Communicates project status, resolving project issues, problems, and changes;
• Administers data processes and quality, and identifies opportunities to improve data reliability and efficiency
• Administers system performance and capacity, and identifies potential infrastructure improvements as needed;
• Assists in preparing and updating technical documentation, such as data mappings, specifications, data dictionaries, and support materials;
• Develops and maintains application programming interfaces (APIs) to support data accessibility and third-party integration;
• Maintains the data dictionaries and related metadata documentation;
• Supports self-service analytics by publishing certified datasets and reusable pipelines;
• Maintains technical and functional competency in applications utilized by to collect and analyze data in the organization.
• Performs related duties as required.

Employment Standards

Sufficient education and increasingly responsible experience to demonstrate possession of the required knowledge, skills, and abilities.

Development of the required knowledge, skills, and abilities is typically obtained through a combination of training and experience equivalent to graduation from an accredited college or university with a four-year degree in computer science, engineering, business information systems, management information systems, or a closely related field.

Knowledge of:

• Data processing tools, techniques, and methodologies;
• Data warehousing concepts;
• Information systems development across the IT lifecycle, with a focus on systems to perform high-volume and high-velocity data processing;
• Relational and NoSQL database technologies; data extraction, querying, and scripting;
• Implementing business logic using SQL-based transformation frameworks;
• Database management software and defining hardware requirements;
• Principles and practices of integrating data from Enterprise Resource Planning and Enterprise Asset Management systems into enterprise data platforms;
• Relational database theory, structure, principles, and practices; database normalization concepts, data modeling and performance tuning;
• Software components (e.g., specialized UDFs) and analytics applications;
• Methods of extracting and integrating data from various sources, for comparative analysis;
• Troubleshooting techniques for data load or reconciliation;
• Basic networking principles and concepts;
• Scripting languages;
• Software development methodology and release processes;
• Data visualizations and reporting tools;
• Data analytics tools, systems, and software troubleshooting;
• Data management standards, policies, and procedures;
• Disaster recovery procedures.

Ability to:

• Implement statistical modes to identify trends, correlations, and patterns in data sets;
• Improve and maintain data quality and integrity;
• Catalog and manage data sources;
• Maintain, design, and create relational databases and data systems;
• Design and Build reporting dashboards;
• Utilize presentation tools to communicate technical information effectively;
• Mine and analyze data;
• Perform data cleansing;
• Develop and maintain technical documentation records;

• Establish and maintain cooperative and effective working relationships with those contacted in the course of business.

Working Environment/Conditions and Physical Demands 

 

Work Environment and Physical Effort:

Good Conditions 

Primarily Sedentary Work 

Work Locations:

Office or similar indoor environment – Frequently  

Exposures: 

Minimal exposure to environmental factors

General Application Instructions

Please read this job announcement in its entirety before applying. We recommend printing or saving a copy for future reference.

To be considered, applications must be submitted online through the Human Resources department by the posted deadline. If the job posting is listed as “continuous,” we encourage you to apply as soon as possible, as the posting may close without prior notice. Once your application is submitted, you will receive an immediate email confirmation.

Personalized responses to Supplemental Questions that connect your past experiences to this specific role are the most effective. AI-generated content may lack the specificity required to address the key criteria outlined in the job description. While we encourage the use of AI as a tool to enhance your work, we want to evaluate your non-AI-assisted communication skills. You may use AI to generate ideas, but please ensure your final responses are in your own voice and reflect your unique experience. Overreliance on AI-generated content is discouraged and may diminish your chances of success.

Important: Only online applications will be accepted for this recruitment. We do not accept paper applications, resumes, Job Interest Notification Cards, or incomplete/unsubmitted applications in place of a fully completed application.

Communication & Contact Information

All updates regarding your application—including notices for testing and interviews—will be sent via email. Be sure to select email as your preferred method of communication and maintain a valid, up-to-date email address. Applicants are also responsible for keeping their phone numbers and mailing addresses current in their online profiles.

Due to the high volume of applications, we are unable to provide individual updates. Please check your application status through your online account. For technical support, contact NEOGOV at (855) 524-5627, Monday through Friday, 8:00 AM – 5:00 PM (PST), excluding holidays.

Application Review & Processing

All current and prior relevant work experience—including experience with VTA—must be fully detailed in the Work Experience section of your application. Entries such as “see resume” are not acceptable. Incomplete or improperly completed applications may be rejected, even if you meet the minimum qualifications.

While you are welcome to upload a resume, it does not substitute for completing the online application in full. Be sure that your application accurately reflects the education and experience necessary for the position.

Applications are reviewed throughout the recruitment process to determine whether candidates meet the minimum qualifications. Meeting these minimums or advancing through any stage does not guarantee further consideration. Any misrepresentation or falsification of qualifications, experience, education, or training may result in disqualification and/or exclusion from future employment opportunities with VTA.

This classification is represented by Service Employees International Union (SEIU), Amalgamated Transit Union. Wages, hours, and other terms and conditions of employment are governed by the applicable collective bargaining agreement between VTA and the union.

                                                                                                                    Tentative Examinations:

                                                                    Oral Panel: Tentatively expected to be scheduled around the fourth week in August.

Conditions of Employment

Final candidates must successfully complete a Livescan background check, reference checks, verification of education or certifications, and a criminal history review before appointment. 

For sensitive positions, VTA requires all safety-sensitive positions to have a 6-month DOT physical clearance. Obtained at the time of preboarding from a VTA-contracted Concentra Location.

Eligibility List

The established Eligible List from this recruitment will be used to fill the current vacancies and additional vacancies that may occur.  Eligible Lists typically remain in effect for six (6) months. However, Human Resources may abolish Eligible Lists at any time during the six (6) month period. Human Resources may extend eligible Lists for up to two (2) years. Eligible Lists may be used for more than one recruitment. 

Americans with Disabilities Act Accommodations 

VTA is committed to providing reasonable accommodations to individuals with disabilities in the recruitment and examination process. To request an accommodation, please contact the Human Resources Department at (408) 321-5575 or email [email protected] at least five business days before the test.

Equal Employment Opportunity

VTA is an equal employment opportunity employer. VTA does not and will not tolerate discrimination against applicants or employees on the basis of age, ancestry, color, marital status, mental or physical disability, genetic information, national, origin, immigration status, political affiliation, race, religion, creed, sex, gender identity, gender expression, sexual orientation, pregnancy, medical condition, disabled veteran or veteran status, etc.