Employee Stories
IT at UCLAImage of IT at UCLAFind Out More
Weather and Surf Report

Santa Monica
H: ° L: °


5 Day

Programmer/Analyst III

Job Duties

Lead database development for clinical research projects including schema design, security, administration, backup procedures, and ETL procedures from SQL data repositories, web services, and HL7 feeds. Develop software tools that interface with the database to facilitate clinical data collection, retrieval, and analysis for research projects. Assist users (faculty, staff, students) with development of reports from developed research databases. Coordinate and assist in efforts to perform quality control of data being captured in databases.Assist users in extracting information from large data set for analysis in third-party data analysis tools such as Excel, SPSS, and SAS. Participate in planning meetings and provide expertise in database design, development, and maintenance. Serve as a resource to users in areas of new and developing database and data collection technologies and research systems. Maintain a current knowledge of application computing and programming technologies needed to meet the changing requirements of research projects. Perform general system management on Windows and Linux computers, including but not exclusive to: managing user accounts, storage, installing and configuring new hardware and software, ensuring systems are updated with latest security patches, performing web server/mail system maintenance, and ensuring network security. Maintain a catalogue of computer hardware systems, manage the ordering and setup of new systems, and interface with users and vendors to troubleshoot hardware and software issues. Provide knowledge of best practices for system and network management, including software license management, troubleshooting, maintenance, and security. Provide back-up to other Department/Section staff. Produce reports and contribute to Department surveys: Analyze and direct responses to questionnaires and statistical studies from School of Medicine, Hospital Administration, and outside private and public agencies, meeting deadlines as stipulated. Assemble and organize accurate information to meet deadlines for the School of Medicine. Participate in teams, Perform special projects and other duties as assigned.

Job Qualifications

Extensive experience with and detailed knowledge of the principles of database management, including development of entity-relationship models and proper relational database management design. Experience with and knowledge of enterprise-level relational database systems such as Oracle, SQL Server, MySQL, and Postgres. Experience with and knowledge of SQL. Demonstrated experience with designing and implementing databases in response to and in anticipation of user needs. Solid understanding of data collection methodologies and experience developing reports from large, complex (clinical) data sets. Knowledge of system administration fundamentals in Windows and Linux, including demonstrated skills with shell scripting. Knowledge of network administration fundamentals, TCP/IP protocol and networking concepts. Proven strong customer service/interpersonal skills, including (but not limited to) strong verbal and written communication skills and a demonstrated ability to clearly and concisely communicate detailed information in person, by e-mail, or over the phone. Ability to prepare effective technical and training materials for technical and non-technical users and demonstrated skill to communicate technical information to non-technical users. Understanding of, and ability to comply with, regulatory policies surrounding protected health information and security best practices. Ability to ensure projects meet all user-defined requirements and conform to development standards and guidelines. Demonstrates broad technical knowledge and strong problem solving skills. Knowledge of and experience with programming in an object-oriented language. BS in Computer Science or related field or 4 years of industry experience in lieu of degree. MS in Computer Science or related field or an additional 2 years of industry experience. Demonstrated ability to design, develop, direct, and manage the implementation of systems for complex web-based computing applications, including (but not limited to) having a working knowledge of RESTful services, JSP, Javascript, JSON, HTML, CSS, XML, SQL, PHP, AJAX, and other common web-enabling and database technologies. Experience with clinical data collection and trial management systems such as REDCap. Knowledge or experience with health information technologies and infrastructure (e.g., Epic/CareConnect, DB2) used at UCLA or comparable academic medical centers. Knowledge mining systems such as i2b2 and patient registries. Experience designing user interfaces.

Back to Search Result Bookmark Job Search Again

Summary Information

  • Job Title: Programmer/Analyst III
  • UCLA Title: Programmer/Analyst III
  • Job Num.: H68463
  • Work Hours: M-F/8:00am-5:00pm
  • Work Location: 924 Westwood Blvd. Suite 420
  • Job Type: Career
  • Duration: Indefinite
  • Minimum Salary: $26.76 / $4656
  • Maximum Salary: $52.81 / $9188
  • Layoff Referral Deadline: 09/18/2013
  • Bargaining Unit: 99

Please be advised that ALL new hires will be required to successfully complete a criminal background investigation and a medical examination, which includes a drug screening, prior to employment at UCLA Health. The receipt of satisfactory responses to reference requests, and the provision of satisfactory proof of an applicant's identity and legal authority to work in the United States are also required. Any misrepresentation, falsification or material omission may result in a candidate's failure to receive an offer, or if already hired, an immediate dismissal from employment.

In an effort to promote and maintain a healthy environment for our patients, visitors, and employees, UCLA Health is a smoke-free site.

At UCLA Health, we achieve excellence in patient care consistently by following the steps outlined in CICARE.

CICARE is an acronym that describes specific behaviors that are guaranteed to result in excellent communication with patients, families and colleagues.

Every UCLA Health employee, physician and volunteer holds themselves and their colleagues accountable for practicing these six steps with everyone on every encounter.


Please confirm that you
agree with CICARE

Connect with the patient and their family members by addressing them as Mr./Ms., or by the name they prefer.

Introduce yourself and your role.

Communicate what you are going to do, how long it is going to take, and how it will impact the patient.

Ask permission before examining the patient and anticipate patient and/or family needs, questions or concerns.

Respond to patient and/or family questions and requests with immediacy.

Exit courteously and/or with an explanation of what will come next (or when you will be back to check on them).