Data Warehouse Administrator Jobs (NOW HIRING)

Salary : $89,233.56 - $116,035.92 Annually
Location : 3331 N First St, San Jose, CA 95134, CA
Job Type: Full-Time
Job Number: 26-CK-20213
Division: Finance & Budget
Department: Technology
Opening Date: 08/04/2026
Closing Date: 8/18/2026 11:59 PM Pacific
Job Description
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 , 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:
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.
Essential Job Functions
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.

Minimum Qualifications
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.
Supplemental Information
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:

• Develop, analyze, troubleshoot, and maintain data engineering solutions, including ETL/ELT processes, data pipelines, automation workflows, and supporting application code;

• 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;

• Implement data validation and reconciliation checks to ensure data integrity and Data quality standards;
• Collaborate with analysts and business stakeholders;

• 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