Business Intelligence Developer

Department Marketing Statement:

There is a reason UCSB has been named the Best Place to Work by our local media for several years running. Whether our employees are on our stunning campus, or working remotely or hybrid, they tell us they value the flexibility, stability and rich benefits we offer. Come join us as we support the mission of one of the finest public institutions in the nation. UC Santa Barbara is consistently recognized for excellence across broad fields of study. Set alongside the glorious California coast, our dynamic environment inspires scholarly ambition and creativity. Information Technology Services (ITS), the Campus' central IT unit, contributes to UC Santa Barbara's mission of research, teaching, and community service by partnering with the Campus community to efficiently deliver IT infrastructure and enterprise application services to faculty, students, staff, and affiliates. Join us in supporting the technology making world class research possible!

Benefits of Belonging:

Working at UC means being part of this vibrant institution that shines a light on what is possible. People make UC great, and UC recognizes your contributions by making this a great place to work. Excellent retirement and health are just one of the rewards. Learn more about the benefits of working at UC and why You Belong at UC.

Brief Summary of Job Duties:

Applies skills as an experienced data management professional with full understanding of industry practices and campus and department methodologies, policies and procedures to resolve complex and wide-ranging issues where analyses of situations or data requires a review of a variety of factors. Demonstrates competency in selecting methods and techniques to obtain solutions. Responsible for the planning, coordination, technology leadership and management of data analytics and business intelligence solutions. Supports users in their effort to analyze data, provides training to developers and users on Business Intelligence tools and data, and works with functional departments to analyze their Business Intelligence needs and implement solutions.

Required Qualifications:

• 1-3 years of experience developing data models, reports and dashboards with Oracle Fusion Analytics and the Fusion Autonomous Warehouse.
• 1-3 years of knowledge and experience implementing data warehousing principles and design concepts and developing dimensional data models.
• 1-3 years of experience analyzing business processes and information systems and creating specifications for business intelligence solutions.
• 1-3 years of experience with software development in SQL Server or Oracle database environments.
• Bachelor's Degree or equivalent work experience in programming and business analysis or equivalent experience and/or training.

Preferred Qualifications:

• 1-3 years of experience designing and developing data pipeline solutions using continuous development and continuous integration best practices.
• 1-3 years of experience designing and developing data warehouse solutions with Snowflake or comparable cloud data platforms.
• 1-3 years of knowledge of Oracle Financial Cloud data structures.

Special Conditions of Employment

• Satisfactory conviction history background check
• UCSB is a Tobacco-Free environment

Job Functions and Percentages of Time:
45% Business Intelligence Development

• Works with business and technical staff to analyze and provide Business Intelligence solutions to meet operational and decision-making needs.
• Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel.
• Uses established data platforms and business intelligence tools to develop reporting solutions.
• Coordinates with data engineers in the design and development of data models to support reporting implementations.
• Creates and maintains data definitions.
• Provides knowledge sharing and training of data concepts, business intelligence tools, processes, and standards.
• Provides oversight and support to BI developers across campus with development and deployment standards and security implementations.

30% Data Systems Development and Data Integration

• Applies professional and broadly defined business analysis and data administration and data use concepts to manage and perform complex assignments.
• Independently analyzes complex information requirements and documents them using formal data definition techniques and naming standards.
• Implements related business processes, develops logical data models, dimensional data models and schemas for the scope of a project or a component of a project.
• Develops data mapping specifications and data transformation pipelines using continuous development and continuous integration best practices.
• Develops solutions to design and monitor customer security permissions, performs audits and monitors usage.

20% Production Support

• Supports users in their effort to analyze data.
• Trains developers and functional experts on UCSB data and implemented business intelligence technologies and best practices.
• Updates existing business intelligence solutions with required changes.
• Troubleshoots report and data analytics issues.
• Monitors reporting solutions and ensures data refresh consistency.
• Ensures integrity and completeness of data and workflows.

5% Other

• Completes mandatory UCSB training.
• Keeps skills up to date with new relevant technologies.
• Provides documentation in support of the maintainability and reusability of database objects and applications.
• Other duties as assigned.

Policy on Vaccination Programs

As a condition of employment, you will be required to comply with the University of California Policy.

As a condition of Physical Presence at a Location or in a University Program, all Covered Individuals* must participate in any applicable Vaccination Program by providing proof that they are Up-to-Date with any required Vaccines or submitting a request for Exception in a Mandate Program or properly declining vaccination in an Opt-Out Program no later than the Compliance Date (Capitalized terms in this paragraph are defined in the policy.). Federal, state, or local public health directives may impose additional requirements.

For more information, please visit:

• UC Santa Barbara COVID-19 Information https://www.ucsb.edu/COVID-19-information
• University of California Policy on Vaccinations https://policy.ucop.edu/doc/5000695/

* Covered Individuals: A Covered Individual includes anyone designated as Personnel or Students under this policy who Physically Access a University Facility or Program in connection with their employment, appointment, or education/training. A person accessing a Healthcare Location as a patient, or an art, athletics, entertainment, or other publicly accessible venue at a Location as a member of the public, is not a Covered Individual.

Equal Opportunity/Affirmative Action Statement

UC Santa Barbara 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-20.

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

Reasonable Accommodations

The University of California endeavors to make the UCSB Job site (https://jobs.ucsb.edu) accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact Katherine Abad in Human Resources at 805-893-4664 or email katherine.abad@hr.ucsb.edu. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications.

Privacy Notification Statement and Notice of Availability of the UCSB Annual Security Report Disclosures

Payroll Title: Data Systems Analyst 3

Job Code: 007199

Job Open Date: 9/20/24

Application Review Begins: 10/7/24; open until filled

Department Code (Name): INFO (OIST) Information Technology Services

Percentage of Time: 100%

Union Code (Name): 99 (Non-Represented)

Employee Class (Appointment Type): Staff (Career)

FLSA Status: Exempt

Classified Indicator Description (Personnel Program): PSS

Salary Grade: Grade 23

Pay Rate/Range: The budgeted salary range that the University reasonably expects to pay for this position is $96,110 to $121,100/year. Salary offers are determined based on final candidate qualifications and experience; the budget for the position; and the application of fair, equitable, and consistent pay practices at the University. The full salary range for this position is $85,400 to $156,800/year.

Work Location: SAASB, 4th Floor

Working Days and Hours: M-F, 8am-5pm

Benefits Eligibility: Full Benefits

Type of Remote or Hybrid Work Arrangement, if applicable: Hybrid (Both UC & Non-UC locations)

Special Instructions:

For full consideration, please include a resume and a cover letter as part of your application.

Application Status: If you would like to check the status of your application, please log into the Candidate Gateway where you applied and click on 'my activities'.