Business Systems Analyst, Associate

Job Description

Overview

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 direct supervision, provides primary information systems support for Financial Planning & Analysis (FP&A). Assists in the data extraction and cleaning of data from OCTA’s accounting, procurement and human resources systems, and the upload of this data into FP&A’s budget system and dashboards. Provides entry-level business intelligence skills in reporting and dashboard building. Maintains metadata in FP&A systems, synchronizing shared data with external systems.

This is a non-exempt position in Salary Grade 185: Min $38.71 – Mid $46.24 – Max $53.76 hourly. The starting salary will be within this range based on qualifications.

This posting will remain open until filled.

Responsibilities

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.

• Assists in maintaining metadata in FP&A's Financial System, keeps chart of accounts data in-synch with Accounting and maintains title/employee data is in-synch with Human Resources.
• Assists in supporting user security in Microsoft Power Apps and Qlik Sense, enforcing FP&A policies and communicating with users to ensure they know how to log-in and have access as needed.
• Participates in providing ad hoc data extractions as requested by FP&A analysts to support analysis.
• Assists in coordinating and prioritizing on-going development and implementation of database and software features and appropriate software conversions, including the training of employees on new programs.
• Analyzes accounting and/or financial issues.
• Plans and organizes projects and meets multiple deadlines. Communicates clearly and concisely, both verbally and in writing.
• Exercises discretion in the use of confidential information.
• Assists in maintaining SQL Server and Essbase databases, performs daily, weekly, monthly, and annual data extraction, and the transformation from OCTA's Oracle and SQL Server databases into FP&A's databases, business intelligence applications and Essbase databases.
  
  

Solves Problems & Analyzes Issues: Has and applies problem analysis and problem-solving skills on a technical and interpersonal level.

• Responds to requests and inquiries from system users and resolves problems. Assume responsibility for the data integrity and efficient operation of assigned applications.
• Performs analysis and assists with the design and testing of assigned programs.
• Assists in monitoring data integrity between FP&A's systems ensuring that control totals tie across systems, and that, as fiscal periods change, internal variables have been reset accordingly.
  
  

Takes Initiative: Initiates new programs, processes, relationships, or technologies to accomplish goals.

• Participates in creating and maintaining documentation of systems, standard operating procedures, and user instruction materials.
• Adapts to changing technologies and learns functionality of new equipment and systems.
  
  

Customer & External Focus: Markets his/her workgroup effectively and influences others in the organization.

• Establishes and maintains effective working relationships with superiors, peers, and subordinates.
• Participates in providing technical support to special projects relating to the use of specific applications.
• Participates in user training in FP&A’s systems and dashboards; assists in the development of printed and video training materials.
  
  

Qualifications

Any combination of education and experience equivalent to a bachelor's degree in information technology, computer science, business, mathematics, economics, finance, or accounting.

Working Conditions/Physical Activities

(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.
• Requires ability to understand verbal communication and to respond effectively.
• Positions in this class typically require: 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.