UCSD Layoff from Career Appointment: Apply by 10/25/17 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor. Eligible Disability Counseling and Consulting services (DCC) or Special Selection clients should contact their Vocational Rehabilitation Counselor for assistance.
Posting/Position will remain "Open Until Filled"
This Data Systems Analyst provides technical and analytical skills and applied programming experience in support of the Business Services Division of the San Diego Supercomputer Center (SDSC).
Applies data, information management concepts, department and campus policies and procedures to resolve a variety of data and information management issues. Works on data of moderate scope and complexity where analyses of situations or data require a review of a variety of factors. Participates in the preparation of logical data models, dimensional data models and schemas for a component of a project. Implements database structures in support of data needs and writes SQL code to query databases.
Analyzes customer reporting needs and designs and implements BI systems architecture to meet those needs. Designs and implements capture of metadata from technical processes such as software design and database management. Assists with implementation of business processes. Extracts data from multiple campus data sources and integrates with local data.
Applies professional programming concepts for small to medium-sized projects or portions of larger projects. Develops web-based financial, HR, payroll, and facilities management reports in support of business processes. Prepares training materials and documentation of internal processes for end users and programming staff. Trains and assists users in the use of customized software pertaining to administrative functions.
For more information, please visit www.sdsc.edu
Knowledge of data management systems, practices and standards. Knowledge of business intelligence tools concepts and structure. Intermediate knowledge of administrative, financial, payroll, and facilities management systems, principles, and processes in a university setting.
Knowledge relating to logical data design, data warehouse design, data integration or the management of web content or other unstructured data.
Ability to prepare simple data models under guidance of more senior professionals. Experience using scripting languages such as Perl to process data, perform ETL functions, and generate reports.
Familiarity with important types of data models such as logical / relational models, dimensional models and document models. Intermediate knowledge of Oracle, DB2, PostGres, Sybase, SQL Server, and MySQL database systems.
Ability to effectively design and create database tables, indexes, triggers, and other database structures that effectively model complex data relationships. Intermediate experience in manipulating and managing data using SQL queries.
Experience developing and maintaining written document regarding technical specifications, protocols, and coding comments. Experience translating technical documentation into user instructions.
~ Background check required.
The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age, protected veteran status, gender identity or sexual orientation. For the complete University of California nondiscrimination and affirmative action policy see: http://www-hr.ucsd.edu/saa/nondiscr.html
UC San Diego is a smoke and tobacco free environment. Please visit smokefree.ucsd.edu for more information.