#101957 Sr. Data Integration and Development Analyst

La Jolla, CA
Sep 30, 2019
Administrative Jobs
Technology, Analysts & Programming
Institution Type
Four-Year Institution

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.

  • Advanced analytical and design skills. Ability to abstract information requirements from real-world processes to understand information flows in computer systems.

  • Ability to adopt new technology and adjust to new strategies.

  • Columnar database experience.

  • UNIX script writing skills.

  • Experience in HANA development.
  • Experience with Kafka development.
  • Experience in NiFi development.
  • API development experience.

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


Must pass a background check.Employee must be available to work evenings and weekends.Employee must be available to travel as required.

Similar jobs

Similar jobs