Senior Data Systems Analyst - 132088

Payroll Title:DATA SYS ANL 4 Department:INFORMATION TECHNOLOGY SVCS Hiring Pay Scale$104,900 - $130,000 / Year Worksite:Remote Appointment Type:Career Appointment Percent:100% Union:Uncovered Total Openings:1 Work Schedule:8 hrs/day#132088 Senior Data Systems AnalystFiling Deadline: Tue 9/24/2024Apply NowUC San Diego values equity, diversity, and inclusion. If you are interested in being part of our team, possess the needed licensure and certifications, and feel that you have most of the qualifications and/or transferable skills for a job opening, we strongly encourage you to apply.DESCRIPTIONDEPARTMENT OVERVIEW: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.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 - Cognos. The program is engaging all VC areas in development of data models and BI reporting to address functional requirements.POSITION OVERVIEW: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. The position is also responsible for collecting customer BI requirements, developing related solutions, coordinating testing including user acceptance and overseeing related implementation.Responsible for designing and developing activity hub views, including Final Curated Views (FCVs), to support analytics and operations across the campus. This position involves designing and managing the automation of Activity Hub metadata creation and feedback mechanisms for the Generative AI Platform. Responsibilities include developing and overseeing activity hub stored procedures, tables, and views for API and platform access. The role also encompasses integrating advanced analytics capabilities, including machine learning and AI, within activity hubs. Additionally, the position requires creating autonomic, self-healing routines to enhance BI and database team productivity.Responsibilities:• 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.• 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.• 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.• 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.• 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.• Design and manage the activity hub stored procedures, activity tables and views related to API access as well as Generative AI Platform access. Help design and test SQL and analytic queries for Generative AI Platform.• Design and manage the automation of Activity Hub metadata creation for the campus Generative AI Platform including mechanisms for automated reinforcement feedback from the community.• Design and manage advanced analytics capabilities, including machine learning and AI within activity hubs.• Design and help manage novel approaches to analyzing and alerting based on activity hub data and activity hub logging data.• Help develop autonomic, self-healing routines in activity hubs that improves BI and database team productivity.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. Skilled in developing and managing stored procedures, tables, and views for API and platform access.• Ability to prepare complex data models unassisted. Experience with machine learning and AI related technologies to support analysis and predictive analytics.• 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 QUALIFICATION:• 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 upon satisfactory clearance based on background check results.This position is eligible for full benefits first day of hire:a) Health/Dental/Vision Insurance.b) Vacation/holidays (15 vacation days & 13 paid holidays a year).c) Work/Life Balance.d) UC Retirement Plane) Pet insurance.For more information about UCSD Benefits and Work/Life.To calculate an approximate value of the UC Total Compensation package, please click: http://ucnet.universityofcalifornia.edu/compensation-and-benefits/total-compensation-calculator.phpPay Transparency ActAnnual Full Pay Range: $104,900 - $198,900 (will be prorated if the appointment percentage is less than 100%)Hourly Equivalent: $50.24 - $95.26Factors in determining the appropriate compensation for a role include experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. The Hiring Pay Scale referenced in the job posting is the budgeted salary or hourly range that the University reasonably expects to pay for this position. The Annual Full Pay Range may be broader than what the University anticipates to pay for this position, based on internal equity, budget, and collective bargaining agreements (when applicable).Apply NowIf 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.UC San Diego is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.For the University of California’s Affirmative Action Policy please visit: https://policy.ucop.edu/doc/4010393/PPSM-20For the University of California’s Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-DiscriminationUC San Diego is a smoke and tobacco free environment. Please visit smokefree.ucsd.edu for more information.