DATA ENGINEER Job Listing at University of California in Santa Barbara, CA (Job ID 65243)

Description

Job Posting Details

Department Marketing Statement:

There is a reason UC Santa Barbara has been named "Best Place to Work" by our local media for several years. Whether our employees are on our stunning campus or working remotely, 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. UCSB 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 that makes 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

Brief Summary of Job Duties:

Technical leader with a high degree of knowledge in the data services area and recognized expertise in the UCSB central Data Warehouse systems. Applies problem-solving skills that require analysis of unique issues without precedent or structure. Manages data services programs that include formulating strategies and administering policies, processes, security and resources to ensure safe data use and to transform legacy UCSB data systems to effective data analytics systems. Functions with a high degree of autonomy. Having significant experience in the UCSB data warehouse systems, applies advanced data and information management concepts and campus 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.

Required Qualifications:

• Bachelor's degree in related area and / or equivalent experience / training.
• Experience designing, developing, documenting, and testing database solutions using SQL Server technologies.
• Experience designing and developing data pipeline solutions with Python and SSIS using continuous development and continuous integration best practices.
• Expert knowledge and experience implementing data warehousing principles and design concepts.
• Experience using GitHub or Azure DevOps for development and deployment.
• Equivalent experience/training with an emphasis in computer science, data processing, computer information systems, or in a related field.
• Experience designing, developing, documenting, and testing (including unit testing and test plan creation) database solutions. 
• Experience analyzing business processes and information systems to ensure systems meet the business needs, and identifying opportunities for system improvement to better align with the business needs. 

 Preferred Qualifications:

• Experience designing and developing data warehouse solutions with Snowflake or comparable cloud data platforms.
• Experience developing data models and reports with Power BI, or comparable Business Intelligence tools. 
• Experience consuming data with REST APIs.
• Knowledge of AWS data solutions development.
• Ability to learn and adopt new technologies.
• Ability to communicate well with management, customers, developers within the organization and across UCSB IT organizations.

Special Conditions of Employment:

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

Job Functions and Percentages of Time:

35% Technical Leadership and Project Management 

• Applies professional and broadly defined business analysis, data administration, and data design and use concepts to manage and perform complex assignments. 
• Independently analyzes complex information requirements and documents them using formal data definition techniques and naming standards.
• Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel.
• Researches relevant problem-domain literature and information standards and develops recommendations for data management solutions including approaches, trends, sources and uses. 
• 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 pipelines. 
• Works closely with users and constituents to provide data solutions. 
• Assigns and verifies work to other resources to ensure successful project execution.

35% Business Intelligence Engineer

• Maintains, expands, and improves current data reporting and data infrastructure environments. 
• Develops, optimizes and monitors data pipelines using continuous development and continuous integration best practices. 
• Plans, schedules, tests and coordinates all data platform changes and upgrades through Change Management Requests. 
• Develops solutions to design and monitor customer security permissions, performs audits and monitors usage. 
• Identifies problem areas, recommends solutions and establishes and documents standards. 
• Works closely with users to design, support, improve and maintain Data Warehouse services. 
• Designs, develops, maintains, data catalog, documents and supports clear and effective reporting applications and solutions. 
• Constructs interface prototypes for iterative user testing and verification. 
• Engages with clients to understand scope and criticality of new change requests.

25% Operational Support

• Provides customer support as needed. 
• Provides training to developers and users on UCSB data concepts and systems. 
• Administers user privileges in accordance with established security and access policies. 
• Troubleshoots and resolves reporting and data pipeline issues as required.

5% Administrative Tasks 

• Tracks project time. 
• Provides project status to manager. 
• Meets with supervisor and team. 
• Other duties as assigned.

UC Vaccination Programs Policy - With Interim Revisions:

As a condition of employment, you will be required to comply with the University of California Policy on Vaccinations Programs – With Interim Revisions.*

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 – With Interim Revisions - https://policy.ucop.edu/doc/5000695/VaccinationProgramsPolicy 

*Note: The Policy on Vaccination Programs – With Interim Revisions was updated effective August 16, 2023. A systemwide review of this policy will take place in Fall 2023 with an expected issuance/effective date in early 2024. 

**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 and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Reasonable Accommodations:

The University of California endeavors to make 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

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

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'.

Payroll Title: Data Systems Analyst 4

Job Code: 000599

Job Open Date: 3/1/24

Application Review Begins: 3/18/24; open until filled

Department Code (Name): INFO (OIST)

Percentage of Time: 100%

Union Code (Name): 99 Non-Represented

Employee Class (Appointment Type): Staff (Career)

FLSA Status: Exempt

Classified Indicator Description (Personnel Program): MSP

Salary Grade: Grade 25

Hiring/Budgeted Salary Range: $114,780 to $146,700/yr.

Full Salary Range: 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 $101,100 to $ 192,300/yr. The budgeted salary range that the University reasonably expects to pay for this position is $114,780 to $146,700/yr.

Work Location: Student Affairs & Admin Svs - 4101

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

Benefits Eligibility: Full Benefits

Type of Remote or Hybrid Work Arrangement, if applicable: Fully Remote (Non UC location)

Special Instructions:

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