Data Warehouse Administrator III

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

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 2000 people dedicated to providing solutions that move Silicon Valley. Unique among transportation organizations in the San Francisco Bay Area VTA is Santa Clara Countys 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 countys 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: 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.

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:

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.

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 Monday through Friday 8:00 AM 5:00 PM (PST) excluding holidays.

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 positionsVTA 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 or email 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.