![University of California](https://assets.careerarc.com/companies/2018/logos/primary_4129_thumb_med.jpg?1477401689)
Description
Required Qualifications
Job Opening ID: 69525 Reports To: Director, Decision Support Services Working Title: REPORT PROGRAMMER AND TECHNICAL DATABASE ANALYST Department: SOM-Decision Support Services Bargaining Unit: 99 FLSA: Exempt Payroll Job Code: 007300 Job Location: UCI Campus- Irvine Percent of Time: 100% Work Schedule: 8-5, M-F Employee Class: Career
In addition to the salary range listed below, we offer a wealth of benefits to make working at UCI even more rewarding. These benefits may include medical insurance, sick and vacation time, retirement savings plans, and access to a number of discounts and perks. Please utilize the links listed here to learn more about our compensation practices and benefits
Required:
- Knowledge or experience of reporting/analysis tools such as Tableau, Cognos, etc.
- At least 2 years reporting programming experience or building experience by using database in MS SQL, Oracle, DB2, Sybase, MySQL, or MS Access or any SQL coding experience.
- Demonstrate significant experience in data extraction and query tools.
- Knowledge of using embedded procedural languages (SQL scripting) to access, update, and transfer data.
- Significant knowledge of and experience with import techniques and file formats (Excel, Access, SQL, CSV, Oracle, etc.) for moving data from one platform to another.
- Demonstrate skill to contribute technical and non-technical discussions and to recommend solutions to technical problems.
- Demonstrate skill to work as an independent, self-motivated productive members of a team, and a good team player.
- Demonstrate skill and experience in deploying new software solutions including user training, operational training, system maintenance and recovery.
- Experience in help desk or production support environment to technical and non-technical users.
- Knowledge and experience of Tableau is plus.
- Knowledge of UC account, finance, HR or any data warehouse is plus.
- Knowledge of UCI data warehouse and business systems, or any higher education data is plus.
- Experience in supporting Finance, Accounting, or HR team is plus.
- Knowledge of and experience in School of Medicine or Medical Center business functions and systems supporting those functions (accounting, payroll, research, students, physician billing) is plus.
- Working experience or knowledge of SQL language, Data Modeling, database, table design, Cognos, Kuali or UCPath is plus.
- Knowledge of DBA functions, such as SQL database backup/restore, query tuning, scheduled jobs, or execution monitor, is plus.
- At least 4 to 5 years of relevant work experience with a BA/BS; or at least 2 to 3 years of relevant work experience with MA/MS; or equivalent work experience.
- Intermediate knowledge of secure software development.
- Advanced skills associated with software design, modification, implementation and deployment, including object-oriented programming concepts.
- Demonstrated ability to understand functional needs and how systems can support those needs.
- Demonstrated ability to develop conversion and system implementation plans.
- Demonstrated ability to contribute technical narrative to grant proposals.
- Demonstrated software repository skills.
- Demonstrated testing and test planning skills.
- Thorough experience with common programming tools.
- Demonstrated ability to follow software specifications.
- Demonstrated effective communication and interpersonal skills.
- Self-motivated and works independently and as part of a team.
- Able to learn effectively and meet deadlines.
- Demonstrated broad problem-solving skills.
- Demonstrated ability to interface with management on a regular basis.
- Thorough experience with identification and use of code libraries and open-source forums.
- Experience with planning for deployment and creation of feedback mechanisms.
- Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
Conditions of Employment:
The University of California, Irvine (UCI) seeks to provide a safe and healthy environment for the entire UCI community. As part of this commitment, all applicants who accept an offer of employment must comply with the following conditions of employment:
- Background Check and Live Scan
- Legal Right to work in the United States
- Vaccination Policies
- Smoking and Tobacco Policy
- Drug Free Environment
The following additional conditions may apply, some of which are dependent upon business unit or job specific requirements.
- California Child Abuse and Neglect Reporting Act
- E-Verify
- Pre-Placement Health Evaluation
Details of each policy may be reviewed by visiting the following page - https://hr.uci.edu/new-hire/conditions-of-employment.php
Closing Statement:
The University of California, Irvine is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.
We are committed to attracting and retaining a diverse workforce along with honoring unique experiences, perspectives, and identities. Together, our community strives to create and maintain working and learning environments that are inclusive, equitable, and welcoming.
UCI provides reasonable accommodations for applicants with disabilities upon request. For more information, please contact Human Resources at (949) 824-0500 or eec@uci.edu
Apply on company website