Senior Data Systems Analyst - 135923

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. This position will additionally support others looking to assist part time in the effort, providing mentorship, training and oversight. 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.

* Provide training, mentorship and overall support for approved Activity Hub Distributed Developers. Complete code review prior to migration of distributed developer code to higher HANA environments.

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.

* Ability to communicate requirements to, mentor, and review work from other developers.

Preferred Qualifications:

* Experience with columnar, in memory databases.* Experience with data models supporting self-service reporting.

Employee must be available to work evenings and weekends.Employee must be available to travel as required.Job offer is contingent upon satisfactory clearance based on background check results.

If employed by the University of California, you will be required to comply with our Policy on Vaccination Programs, which may be amended or revised from time to time. Federal, state, or local public health directives may impose additional requirements.

To foster the best possible working and learning environment, UC San Diego strives to cultivate a rich and diverse environment, inclusive and supportive of all students, faculty, staff and visitors. For more information, please visit UC San Diego Principles of Community.

The University of California is an Equal Opportunity Employer. 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 status under state or federal law.

For the University of California's Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination

UC San Diego is a smoke and tobacco free environment. Please visit smokefree.ucsd.edu for more information.