Job Description

Payroll Title:
DATA SYS ANL 4
Department:
INFORMATION TECHNOLOGY SVCS
Hiring Salary Range
$100,000 - $120,000 /year
Worksite:
Remote
Appointment Type:
Career
Appointment Percent:
100%
Union:
Uncovered
Total Openings:
1
Work Schedule:
Days, 8 hrs/day, Mon-Fri

#115701 Senior Data Systems Analyst

Initial Review Date: Wed 4/27/2022

For the safety and well-being of the entire university community, the University of California requires, with few exceptions, that all students, faculty and staff be vaccinated against the COVID-19 virus and influenza before they will be allowed on campus or in a facility or office. For more information visit: Flu Vaccine Mandate / COVID Vaccine Policy

UC San Diego Policy will not allow this position to receive work visa sponsorship.

Fully remote or Hybrid work will be considered.

DESCRIPTION

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.

Equity, Diversity, and Inclusion are core values at UC San Diego and within Information Technology Services. Crafting a culture around these values allows us to more deeply connect with and appreciate our employees, students, and campus partners. Information Technology Services is continuously working to build a community where we all feel safe, empowered, and encouraged to bring our authentic selves to work. We do this not only because it is what’s right, but because we know that diversity drives insight and innovation. We are proud to partner closely UC San Diego’s Office for Equity, Diversity, and Inclusion, as their dedication to this mission helps us all to drive change.

Workplace Technology Services (WTS) is responsible for adopting, deploying, and maintaining campus-wide workplace services for faculty, staff, and students. This includes email, calendaring, web content management, signature, mobile technologies, collaboration services, and business intelligence.

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 read-only central repository and supporting toolsets.

This position will work on our dynamic team of developers designing and developing innovative views leveraging state of the art environments with groundbreaking strategies. The Final Curated Views (FCVs) our team rolls out support all levels of analytics and operations throughout UCSD. We are working with a columnar, in memory database in the cloud and recreating the world of data warehousing in our new activity hub structures. Streaming data is combined with slower moving data to deliver critical information just in time. If you like challenging, diverse and fast paced work, and want a chance to explore the possibilities, then come join us in moving UCSD into a data forward, predictive rather than reactive world of data analytics. Help us unleash the power of fast moving data.

RESPONSIBILITIES

  • Initiates and designs for diverse date and data systems. Initiates, designs and implements detailed interfaces between computer systems. Initiates, designs, executes and sustains metadata for collections of digital objects.
  • Responsible for design and development of activity hub views that support campus analytics and integration across all enterprise data systems.
  • Plans 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. Documents ownership, custody and access requirements for data subject areas.
  • Responsible to A) Identify data sources B) Identify specific source objects C) Document data relationships required for sourcing and D) Coordinate data sourcing information with local SMEs.
  • Initiates and designs for diverse data and data systems. Initiates, designs and implements detailed interfaces between computer systems. Initiates, designs, executes and sustains metadata for collections of digital objects.
  • Coordinates reviews of data models and data definitions. Develops both conceptual and detailed data models for projects. Develops dimensional models for data subject areas. Creates and manages workflows (including ETL, data curation and others). Documents curated view design and stored procedure process flows. Creates detailed design documentation depicting data flow from ingestion through final curated view (FCV) including relevant metadata setup and materialization implementation strategy.
  • Develops full data / information documentation for highly complex small and medium-size projects. Responsible for documenting requirements for new and enhancements for existing Activity Hub views. This process involves in depth review of disparate data sources containing all types of institutional information. Full review of each piece of data from a business perspective followed by the technical review and design. These systems range from all sizes of home grown applications to large, complex systems such as Oracle Financial Cloud (OFC) and UC Path.
  • Provides escalation level support for users of the activity hubs. Responds to issues escalated from first tier support to assure data is available and understood by campus analysts. Reviews campus analyst input on a large variety of data sets and determines if there is additional knowledge / training that needs to be provided to the analyst or whether there is an actual issue with the data being delivered via the Activity Hub in question. Confirms any reported bugs and resolves. This work ranges across the full set of activity hubs and the hundreds of views delivered as part of this environment to analysts conduct any variation of analysis on the data provided. It includes a requirement for both technical knowledge of how the activity hubs are constructed as well as an understanding of each business use case.

QUALIFICATIONS

  • Bachelor's degree in related area and / or equivalent experience / training.

  • Excellent SQL skills including development and performance tuning.

  • Proven modeling and information design skills.

  • Ability to prepare complex data models unassisted.

  • Familiarity with highly complex logical data design and data mapping or data conversion. Design concepts should include layered, object oriented approaches.

  • Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.

Preferred Qualifications:

* Experience with columnar, in memory databases.

* Experience with data models supporting self-service reporting.

SPECIAL CONDITIONS

Employee must be available to work evenings and weekends.

Employee must be available to travel as required.

Job offer is contingent on clear background check.

Our employees enjoy competitive compensation packages and educational opportunities in a diverse, stimulating workforce.
This position is eligible for full: - Health/Dental/Vision Insurance - Vacation/Holidays - Life Insurance - UC Retirement Plan.

For more information about UCSD Benefits visit - http://blink.ucsd.edu/HR/benefits/index.html and UCSD Work/Life visit https://blink.ucsd.edu/HR/benefits/work-life/index.html

To calculate an approximate value of the UC Total Compensation package, please click here: http://ucnet.universityofcalifornia.edu/compensation-and-benefits/total-compensation-calculator.php


Job offer is contingent on successful engagement in the UC COVID-19 Vaccination program (fully vaccinated with documented proof or approved exception/deferral).

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.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online