Senior Data Warehouse Administrator

Santa Clara Valley Transportation Authority • San Jose, CA

4d • Onsite

About The Position

Are you passionate about building modern data platforms that turn complex operational data into trusted insights that improve decision-making? The Santa Clara Valley Transportation Authority (VTA) is seeking an experienced Senior Data Warehouse Administrator to play a key technical role in designing, building, and evolving our enterprise data platform. This position will help establish the foundation for how VTA integrates, manages, and leverages data to support operational excellence and strategic initiatives. In this senior technical role, you will design and develop scalable data pipelines, integrate data from complex enterprise systems, build analytical data solutions, and support cloud-based data platform capabilities. You will provide technical leadership, establish best practices, and help shape the future of VTA's enterprise data ecosystem. The ideal candidate is a seasoned data professional who enjoys solving complex business challenges through modern data engineering practices, data modeling, automation, cloud technologies, and platform optimization. You will collaborate with business leaders, analysts, developers, and technology teams to deliver trusted, high-quality data products that enable better planning, reporting, and operational decision-making. If you are excited about leading technical initiatives, mentoring others, and building reliable data solutions that create measurable impact for a major public transportation agency, we encourage you to apply.

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 direction, the Senior Data Warehouse Administrator leads, designs, builds, and maintains data platform and processing systems that combine core data sources into accessible structures to support reporting and analytical systems.

Distinguishing Characteristics
This is the advanced journey-level in Data Warehouse Administrator series. Incumbents in this class work closely with technology staff and business stakeholders to identify appropriate data requirements and develop data solutions that integrate information from multiple systems into well-modeled datasets for reporting and analytics. Incumbents perform highly complex and critical duties, including leading projects and guiding staff in partnership with functional stakeholders. Assigned responsibilities include defining the scope of deliverables, designing and developing solutions, and overseeing the end-to-end delivery of data products to meet analytical needs. Incumbents also perform complex data analysis activities, including conceptualization, modeling, and data presentation to support informed decision-making and planning. This class differs from the lower-level class of Data Warehouse Administrator II in that the former is an advanced journey level classification and performs the most difficult, complex, and responsible types of duties assigned to this class series, including serving as project lead over other staff.

The Ideal Candidate
The ideal candidate is an experienced data engineering professional who combines deep technical expertise with strong technical leadership and project delivery skills. They have extensive experience designing data models, developing scalable ETL/ELT pipelines, and integrating data from multiple business systems to build enterprise data warehouse and modern data platform solutions. They have successfully delivered analytical solutions, reporting, and business intelligence capabilities that enable data-driven decision-making. They also have experience implementing, administering, and supporting data platform environments, including platform configuration, security and access management, monitoring, troubleshooting, performance optimization, and ongoing operational support. They have successfully delivered complex data initiatives from concept through implementation while building strong partnerships with business stakeholders, subject matter experts, and cross-functional teams. They are skilled at understanding business and operational needs, translating requirements into sustainable technical solutions, and communicating complex technical concepts to both technical and non-technical audiences. They have experience with modern data architecture, dimensional modeling, cloud data platforms, API integrations, automation, data governance, data quality, and performance optimization. The successful candidate views data as an enterprise asset and applies best practices for scalability, security, reliability, documentation, and long-term maintainability. They balance technical excellence with business value, demonstrate strong problem-solving skills, mentor team members, lead cross-functional initiatives, and continuously improve enterprise data capabilities to enable data-driven decision-making.

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.

Requirements

• 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 and a minimum of four (4) years of professional data analytics experience that included designing, implementing, and integrating data analytics and cloud technology components.
• Extensive knowledge of data processing tools, techniques, and methodologies;
• Expert-level understanding of data warehousing concepts, including ETL vs. ELT, dimensional modeling, and star and snowflake schema design;
• Modern cloud-based data warehouses;
• Information systems development across the IT lifecycle, with a focus on systems to perform high-volume and high-velocity data processing;
• Modern data modeling techniques, including medallion architecture and data product design;
• Relational and NoSQL databases, including data extraction, querying, and scripting, with experience implementing business logic using SQL-based transformation frameworks’
• 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;
• Design and development of data pipelines;
• Data governance standards and role-based access control (RBAC) policies;
• Modern data lakes and advanced storage platforms supporting cross-platform data access, handling CDC, and ingesting diverse file formats;
• Basic networking concepts;
• Scripting languages;
• Data visualizations and reporting tools to present information to a variety of audiences using presentation layer tools;
• Data analytics tools, systems, and software troubleshooting;
• Uses source control and CI/CD practices to support version control, collaboration, and efficient development in data engineering and reporting tasks;
• Troubleshooting data systems and issue resolution practices;
• Principles and practices of lead supervision and training;
• Disaster recovery procedures.
• Manage multiple projects involving personnel from multiple departments, as well as consultants and vendors;
• Lead and direct the work of subordinate personnel;
• Train customers, staff and others, as needed;
• Think Data as a product with cost, scalability, and maintainability as a first Principle;
• Design, develop, analyze, troubleshoot, and maintain data engineering solutions, including ETL/ELT processes, data pipelines, automation workflows, and supporting application code;
• Effectively design data pipelines and accurately forecast future data growth;
• Implement statistical modes to identify trends, correlations, and patterns in data sets;
• Support information governance in collaboration with various stakeholders and departmental data stewards;
• 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;
• Develop and maintain technical documentation records;
• Lead the implementation of data validation and reconciliation processes to ensure data integrity, accuracy, and adherence to data quality standards across systems;
• Effectively collaborate with business stakeholders to maintain appropriate data practices and standards;
• Establish and maintain cooperative and effective working relationships with those contacted in the course of business.

Responsibilities

• Leads and participates in team efforts in managing projects and developing or enhancing data warehouse and analytical solutions; Defines, designs, and owns data transformation and automation processes, and ensures the successful delivery of scalable solutions using a variety of technologies; Designs, builds and maintains scalable data pipelines to ingest data into data warehouse from various sources; Designs and executes data conversions and manages the import and export of data across internal and external systems, with a focus on reusable frameworks and scalable design; Designs and develops data processing systems that integrate core data sources into centralized repositories supporting reporting and analytical functions; Identifies and resolves production and/or application development issues related to the database management systems; Collaborates with technology staff, business analysts, and other stakeholders to translate business requirements into data workflows; Troubleshoots data processing tools, systems, and software applications; Performs data validation and reconciliation to ensure data accuracy and integrity; Defines performance and capacity standards in alignment with service level agreements, and maintains systems to meet those expectations Maintains the quality and integrity of data repositories by adding, modifying, and deleting data in accordance with established policies and business decisions; Leads project planning activities and oversees workflows to ensure deliverables are completed within established timelines; Identifies and implements improvements to enhance data reliability, efficiency, and quality; Leads performance and capacity analysis to support scalability and reliability; Establishes and maintains technical documentation, templates and best practices, including data mappings, specifications, data dictionaries, runbooks, and production support materials; Designs, 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior