This is a contract position which may be extended or converted to career status based on the needs of the department.
UC San Diego Policy will not allow this position to receive work visa sponsorship.
Job offer is contingent upon a satisfactory clearance based on background check results.
UC San Diego is ranked the 9th best public university in the nation by U.S. News and World Report and is the largest employer based in San Diego County. Reporting to the VC-CFO, Information Technology Services (ITS) delivers Enterprise information technology services to the University of California, San Diego (UCSD) under the leadership of the campus Chief Information Officer (CIO).
Information Technology Services (IT Services) uses world-class services and technologies to empower UC San Diego's mission to transform California and the world as a student-centered, research-focused, service-oriented public university. As a strategic member of the UC San Diego community, IT Services embraces innovation in their delivery of IT services, infrastructure, applications, and support. IT Services is customer-focused and committed to collaboration, continuous improvement, and accountability.
The Business Intelligence team develops, maintains and implements applications and capabilities that support the easy and timely access and utilization of enterprise data through a source of reference central repository and supporting toolsets. Our primary goal is to provide high quality and timely support and services to our client base in response to Business Intelligence requirements. This includes delivery of quality services that encourage client independence through timely access of all Data Warehouse information.
The Business Intelligence team is directing a BI Modernization program that includes the creation of new centralized data stores and rollout of an enterprise level BI tool. The program is engaging all VC areas in development of data models and BI reporting to address functional requirements. Having significant experience, applies advanced data/information management concepts and campus/medical center/OP objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Selects methods and techniques to obtain desired results.
This position is responsible for designing and creating extraction, transformation and load (ETL) of data functions for the data warehouse stored on HANA 2.0 in support of BI/Analytic functions. Also must test the designs to ensure data accuracy and loads efficiently. Furthermore, must be expert at taking a big-picture view of a university's data situation. Must be able to read, analyze and digest what a business wants to accomplish with its data, and design the best possible ETL process around those goals.
RESPONSIBILITIESPlans and conducts data analysis efforts for highly complex small and medium-sized projects that may include managing partnerships between multiple institutions. Establishes or maintains information documentation standards such as data naming standards and value domain descriptions. Schedules and conducts analysis sessions. Needs to be able to read, analyze and digest what the business wants to accomplish with its data, and design the best possible ETL process around those goals. Develops and implements highly complex activity hub next generation data warehouse systems serving the entire UCSD campus.
Responsible for the design, integration and implementation of one or more sub-systems of the activity hub supporting the entire campus, ensuring correctness and consistency with overall DW architecture and design. Analyzes requested changes for most appropriate technical solution. Implements and migrates approved software modifications and assures effective installation with users. Designs and implements detailed interfaces between computer systems. Initiates, designs, executes and sustains metadata for collections of digital objects. Collaborates with all developers and business users to gather required data and execute ETL programs. Analyzes and interprets complex data on target systems and provides resolutions to data issues.Provide support for resolution of incidents related to new and legacy data warehousing environments.
Advanced SQL development skills
Experience in data integration and the specification of data services. Must have a minimum of five (5) years experience with hands on development on complex transformations.
Demonstrated modeling and information design skills.
Advanced problem-solving skills. Able to learn effectively and meet deadlines.
UC San Diego is an academic powerhouse and economic engine, recognized as one of the top 8 public universities by U.S. News and World Report. Innovation is central to who we are and what we do. Here, students learn that knowledge isn't just acquired in the classroom - life is their laboratory. UC San Diego's rich academic portfolio includes six undergraduate colleges, five academic divisions and five graduate and professional schools. The university's award-winning scholars are experts at the forefront of their fields with an impressive track record for achieving scientific, medical and technological breakthroughs.