Section Manager, Senior - Data Warehouse - Orange County Transportation Authority

Why OCTA:

Discover work that moves you in a dynamic and innovative setting. Be part of a team delivering Orange County’s transportation network of today and creating a vision for the future.

OCTA is the county’s transportation planning commission and public transit operator. With a focus on safety and accountability, we plan, fund, and implement countywide projects that include bus and rail transit, freeways and express lanes, rideshare, microtransit, paratransit, active transportation, and environmental programs.

We’re passionate about creating a balanced, equitable and sustainable transportation system that reflects the diverse travel needs of the county’s 34 cities and 3.2 million residents. 

Our employees rated OCTA as a top workplace in Orange County. Come join us on our mission of keeping Orange County moving.

Overview:

Under minimal direction, is responsible for overseeing highly complex projects in the areas of Data Warehouse.  As a technical leader, oversees and applies advanced data analytics techniques to highly technical organizational projects with large budget responsibilities, requiring critical oversight of consultants, contractors, third parties, vendors, and suppliers.  Projects have high visibility with the Board, external agencies, and the public.  Responsible for managing and providing direction to the Data Warehouse team.

This is an exempt position in Salary Grade ­­245: Min $140,619.00 – Mid $168,742.00 – Max $196,866.00 annually. The starting salary will be within this range based on qualifications.

This position will remain open until filled.

This list is intended to indicate the general nature and level of work performed by employees within this classification and is not designed to be interpreted as an exhaustive listing of all tasks required of employees assigned to this job.

Displays High Integrity & Honesty: Takes personal responsibility, acts with honesty and consistency.

Has Technical and Professional Expertise: Has the technical skills, product knowledge and professional skills to do the job.

• Develops and implements a comprehensive strategy for the data warehouse team that aligns with the organization's goals. Manages and leads the planning, design, and operations of the data warehouse to ensure it supports reporting, analysis, and data science initiatives.
• Manages and mentors a team of data warehouse professionals, including data architects and data analysts. Ensures the team has the necessary resources and training to be successful.
• Oversees the design and maintenance of data warehouse architecture, data modeling, and ETL processes to ensure they meet business requirements and performance standards.
• Implements and maintains data governance and data quality standards across the data warehouse. Ensures data accuracy, consistency, and security.
• Leads and delivers complex data warehouse projects, including setting timelines, budgets, and resource allocation. Ensures projects are completed on time and within budget.
• Works closely with IS leaders, business stakeholders, and external partners to identify opportunities for data integration and to support data-driven decisions. Effectively communicates the strategic vision and operational status of the data warehouse.
• Continually assesses the data warehouse technology landscape for improvement opportunities. Implements innovations that enhance data accessibility, analysis, and reporting capabilities.
• Ensures the data warehouse complies with all legal and regulatory requirements related to data handling and privacy.  Implements robust security measures to protect data integrity and confidentiality.

Communicates Powerfully & Prolifically: Shares insights on issues/problems, clarifies purpose and links that purpose to actions.

• Presents project status information and project items requiring approval to the Board of Directors, agency executives, and committees.
• Acts as liaison and representative with the agency's Board of Directors and executives as well as elected officials, executives, and decision makers from external consultants, and contractors.
• Communicates and gains consensus through development of good relationships and strong verbal and written communication, including report preparation and presentation skills.

Develops Others: Provides on-going feedback in a helpful manner to develop skills and talents of others.

• Directs, reviews, and approves the work of staff, professional contractors and consultants who are under contract to provide technical services during the planning, design, implementation, and delivery project phases.
• Motivates and leads teams to deliver projects that meet requirements on time and on budget.

Drives for Results: Operates with speed and intensity, translates long-term goals into immediate actions.

• Manages the overall development and maintenance of the Data Warehouse. Provides oversight to data governance procedures. 
• Resolves critical issues, which may arise during active assigned Data Warehouse projects with internal customers, contractors, consultants, and stakeholders. Identifies and corrects conditions that may adversely affect the completion of Data Warehouse project phases on schedule and within budget. 
• Uses advanced technical knowledge and judgment to identify solutions and resolve issues, as necessary.
• Uses technical knowledge and experience to identify and forecast risks and manages those risks to achieve delivery commitments.

Bachelor’s degree in computer science, information systems, or related field.  At least 8 years of experience in data warehousing, four of which are in management.  Strong understanding of data warehouse design principles, including data modeling, ETL processes, and SQL.  Experience with cloud-based data warehousing solutions (e.g., AWS and Azure) is highly desirable.  Demonstrated ability to lead and manage a team of technical professionals.  Excellent problem-solving skills and the ability to think strategically.  Strong communication and interpersonal skills, with the ability to engage effectively with both technical and non-technical stakeholders.  Knowledge of data governance, data quality management, and data security practices.  A master’s degree is preferred.

Working Conditions/Physical Conditions: 

(The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job. OCTA provides reasonable accommodation to enable individuals with disabilities to perform the essential functions.)

  Positions in this class typically require:

• Work may be performed in a stressful, fast-paced office environment, depending upon assignment.
• Ability to understand verbal communication and to respond effectively.
• Reaching, Finger Dexterity, Grasping, Feeling, Talking, Hearing, Seeing, and Repetitive Motions in computer use.

Compensation and Benefits:

OCTA offers an attractive compensation and benefits package that includes medical, dental and vision health insurance programs, flex time (may be available), paid sick leave, paid vacation and holidays, short-term and long-term disability, life insurance, flexible spending accounts, retirement, deferred compensation plan, educational reimbursement, excellent in-house training programs, free transportation passes for the employee and dependents, wellness and ergonomic programs, and much more. OCTA has a hybrid remote work program. Eligibility is dependent on manager’s approval.

OCTA is an equal employment opportunity employer that recruits, hires, and promotes qualified people without regard to race, color, religion, creed, ancestry, national origin, age, sex, pregnancy, gender, gender identity and/or expression, sexual orientation, marital status, medical condition, disability, genetic information, military and veteran status, or other legally protected status.