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.

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 tools. The program is engaging all VC areas in development of data models and BI reporting to address functional requirements. Join our team of experienced and innovative developers in creating strategic tools that will drive success for students, staff and faculty here at UC San Diego.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.

This position is a blend of a Business Systems Analyst and Data Systems Analyst role, necessitating a high level of technical acumen. The successful candidate will be responsible for gathering and interpreting data requests pertaining to deliverables overseen by the Institutional Research (IR) team. To expedite high-priority deliverables, this role involves designing and creating customized data objects using advanced SQL skills.

A key aspect of the responsibilities includes designing and developing specialized data views, which involve a complex data processing system referred to as "Activity Hubs." These data views, along with the Final Curated Views (FCVs), aid in supporting the analytics and operations for the IR team and associated student data projects. It is essential to have a comprehensive grasp of business processes and data systems, in addition to robust technical skills in data manipulation and analysis.

Working closely with customers, the candidate will use an agile approach to facilitate efficient report development and verification. Direct interaction with customers allows the candidate to gain a better understanding of stakeholders' requirements and priorities, resulting in more accurate and prompt deliverables.

RESPONSIBILITIES

• Work directly with the Institutional Reporting (IR) group both as a liaison with the BIA team and to provide support for high priority requirements that require rapid delivery. This includes training IR staff on the use of Activity Hub views, creation of short term content to support immediate and urgent requirements, assisting in coordination of moving the short term built content into the Activity Hub views, and assisting in transitioning any reports built against the short term content over to the permanent Activity Hub views.
• 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 Institutional Research users of the activity hubs. Responds to issues to assure data is available and understood by IR analysts. Reviews IR 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.
• Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Experience procuring and validating technical design requirements from non-technical business staff.
• Experience developing dashboards in Tableau.
• Demonstrated advanced problem-solving skills. Able to learn effectively and meet deadlines. Ability to effectively prioritize and manage concurrent projects.
• Skilled at optimizing large complicated SQL statements

Preferred Qualifications:

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

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

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.