PROGRAMMER ANALYST AND DATABASE ADMINISTRATOR

RECORDS

CLASSIFICATION: Level 3 / Class 2997 / Non-Exempt / Full-Time / Benefited / Represented

HIRING SALARY RANGE: commensurate with qualifications

ABOUT THE RECORDS OFFICE

The Records Office is the College's registrar's office and is responsible for maintaining students' records, grades and transcripts, manage registration, exams and grades, and provide academic-related services, information and student data to various departments within College with the highest level of integrity and according to FERPA, Federal, state and the College's regulations. To do so, the office utilizes a variety of software systems including Ellucian College and Self-Service, Entrinsik Informer, ExamSoft and others. The department employs administrative and professional staff, is supervised by the Registrar who in turn is a direct report to the Academic Dean of the College. 

THE ROLE AND RESPONSIBILITIES

The Programmer Analyst and Database Administrator (PADA) is a link between Records - the data ‘owner' of Colleague - and Information Technology (IT), and thus reports to the Registrar and the Associate Dean for the UC Hastings Library and Technology, Information Technology and Library. Within the Records Office, PADA works closely with the Registrar and Associate Registrars; together, their work ensures the day-to-day business operations of the Records Office are seamless and efficient.  Additionally, the PADA works closely with the IT department to support vendor-supplied, open source, and in-house developed software as it relates to Records functionality. Finally, the PADA serves as the user liaison between the departments, facilitating knowledge, needs, a communication, and identifying solutions.  The Records office is modernizing the department and are thus looking for someone who can assist with data cleanup, instituting data input and security standards and user training, and finding software solutions or writing program processes to improve operations within the Records office and the IT department and between all departments as they related to all Colleague modules and Records processes.

Responsibilities include all tasks necessary to support the College's student information needs and the Record's Office software especially pertaining to Ellucian Colleague, including but not limited to:

• Generate reports;
• Function as a member of the development team in departmental application testing and implementation, taking initiative and responsibility when required;
• Design, write and test programs for administrative and academic departments that use Colleague and associated applications;
• Modify existing programs and procedures, applying vendor-supplied upgrades/modifications; providing guidance and assistance to user community during implementation of new processes;
• Analyze user application/programming requests and develop/recommend solutions and time estimates;
• Troubleshoot administrative software technical issues;
• Assist in the development interfaces to integrate Colleague with third party software applications;
• Assist end-users with the appropriate use of Colleague and associated applications;
• Recommend changes/enhancements that improve program performance and/or application processing;
• Assist and advise users in report generation, including writing data queries for accreditation reports and other purposes as is appropriate for their role; and
• Assist in facilitating implementation training for process improvement, user interface, communication management, correspondence control, and rules processing.

The PADA leads software implementation decisions, representing and clearly articulating the Record's office needs and expectations, coordinating with IT throughout implementation processes and during maintenance periods.  This individual will assist IT & Records staff to promote and publicize new technology resources that pertain to Records services to faculty, staff, and students. To do so, this individual will need to fully understand the application software, code files, parameters, and data files for their areas.  They will become a strong user of query language and will produce many of the reports the office regularly needs or provides to faculty or staff.  To be successful, the PADA will need to learn:

• To understand and translate the office's goals, policies, programs, and standard procedures
• How courses are created and the pieces of information that are associated with each course (course number, title, credit value, prerequisites, cross-listed courses, etc.), that can be subject to change at any point in time.
• General and major requirements (not all the specifics, but an understanding of what we mean by those terms).
• How our curriculum fulfills the general and major requirements and that the requirements are subject to change each year.
• Common AACRAO guidelines for standards of practice, FERPA and other related regulatory compliance mandates;

To facilitate this understanding, the PADA will perform a small portion of regular work (related to registration, exams, grading, etc.) and may sit with other users in their work environment to observe and become familiar with system processes, timelines, and procedures and pain-points.

REQUIREMENTS

EDUCATION AND EXPERIENCE

• Bachelor's or Associates Degree (with a preference for IT related field) and professional programming and database management experience is desired; or minimum 18 months of professional programming experience utilizing relational databases in a customer service environment will be considered in lieu of a degree.
• Experience with relational databases is required. Experience with Ellucian Colleague, UniData is highly preferred.
• Experience with Entrinsik Informer is highly desired.
• Experience in a higher education (Registrar's Office preferred) or non-profit sector is desired.

KNOWLEDGE, SKILLS & ABILITIES

• Ability and strong desire to understand the end-user experience, their processes and their needs by establishing relationships and speaking with the end-users.

• Demonstrated ability to translate complicated technical analysis and information to non-technical end-user audience and vice versa.

• Must have an investigative mindset and an intrinsic desire for ensuring the quality of the data. Must be customer service focused, a pro-active communicator, and solution oriented.

• Ability to exhibit a manner of professional behavior that will promote positive interactions between faculty, staff, students, and external clients, and enhance the public image of the College.

• Ability to think logically, learn and troubleshoot software applications and integrate them with existing systems.

• Must be a self-starter, work independently, as well as function effectively in a team within a diverse group of people.

• Ability to follow through on multiple, concurrent projects with minimal direction, setting priorities that accurately reflect the relative importance of the job responsibilities, while meeting strict deadlines;

• Advanced skills in Microsoft Office Suite, Adobe PDF, and highly adept Excel skills;

• Exercise independent judgement in complex and new situations.

• Exemplary interpersonal, oral, and written communication skills.

• Detail-oriented and willing to work in a fast-paced, changing environment.

• Maintain strict confidentiality.

• Must be committed to diversity and inclusion, and to UC Hastings Vision, Mission, and Values.

• Web authorizing experience, a sense of humor and the ability to engage with the Records team are desired!

BENEFITS

HEALTH AND WELFARE

• Comprehensive medical, dental and vision insurance coverage
• Flexible Spending Accounts for transportation-related, healthcare, and dependent care expenses
• Employee Assistance Program
• Commuter Benefits Program
• Tuition Reimbursement

FOR YOUR FINANCIAL FUTURE

• Life Insurance
• Disability Insurance
• Legal Insurance
• University of California Retirement Plan (defined benefit)
• Deferred Compensation Plans/Pre-tax Retirement Savings Programs

WORK/LIFE BALANCE

• Fourteen paid holidays per year
• Generous vacation and sick leave

THE HIRING PROCESS

FAILURE TO PROVIDE THE INFORMATION AS REQUIRED ON THE APPLICATION FORM INCLUDING ATTACHING A COVER LETTER AND A RESUME SHALL IMMEDIATELY DISQUALIFY AN APPLICANT FROM EMPLOYMENT CONSIDERATION.

PLEASE NOTE: **THIS POSITION HAS BEEN DESIGNATED AS “SENSITIVE” AND REQUIRES A PRE-EMPLOYMENT BACKGROUND CHECK.

Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please contact Human Resources if you require a reasonable accommodation to apply for a job. Examples of reasonable accommodation include making a change to the application process, providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

WHAT TO EXPECT

Applicants who meet the position requirements will be competitively evaluated to identify the individuals whose breadth and depth of experience and education most closely relate to the stated requirements and the needs of the College. Depending on the quality and number of the applications received, only the better qualified applicants may be contacted for an interview. THE POSITION IS OPEN UNTIL FILLED.

UC Hastings College of the Law is an Equal Opportunity Employer