Data Engineer

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:

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.
• 7-9 years: Equivalent experience/training with an emphasis in computer science, data processing, computer information systems, or in a related field.
• 7-9 years: Experience using SQL Server technologies, or comparable database management systems.
• 4-6 years: Experience designing, developing, documenting, and testing (including unit testing and test plan creation) database solutions.
• 4-6 years: 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.
• 4-6 years: Experience designing and developing data pipeline solutions with SSIS, Python, Informatica or other comparable tools, using continuous development and continuous integration best practices.

Preferred Qualifications:

• 4-6 years: Experience using Snowflake to design and develop data warehouse solutions.
• 1-3 years: Experience with Power BI, or comparable Business Intelligence tools.
• Demonstrated ability to design highly complex data systems and integrations.
• Knowledge of relevant application development technologies and tools, including SQL Server, Snowflake, SQL Integration Services, Python, REST API, Visual Studio, Azure DevOps, Git, Power BI.
• Project management skills to lead the implementation of complex data analytics solutions and other data projects.
• Expert knowledge of Microsoft SQL Server development, security model, and performance optimization.
• Expert knowledge of data pipeline methodologies and solutions with Python, SSIS, and/or Informatica.
• Expert knowledge of data warehousing principles and design concepts.
• Expert knowledge of Power BI setup, security model, and development.
• Knowledge with AWS data solutions development.
• Knowledge with Snowflake 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:

• Satisfactory conviction history background check
• UCSB is a Tobacco-Free environment
• Visa sponsorship is not available for this position.

Misconduct Disclosure Requirement:

As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegation or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

"Misconduct" means any violation of the policies or laws governing conduct at the applicant's previous place of employment, including, but not limited to, violations of policies or laws prohibiting sexual harassment, sexual assault, or other forms of harassment, discrimination, dishonesty, or unethical conduct, as defined by the employer. For reference, below are UC's policies addressing some forms of misconduct:

• UC Sexual Violence and Sexual Harassment Policy
• UC Anti-Discrimination Policy
• Abusive Conduct in the Workplace

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 uses 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:

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

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 University of California Policy on Vaccinations - https://policy.ucop.edu/doc/5000695/VaccinationProgramsPolicy

*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 Employment Opportunity:

UC Santa Barbara is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status or other protected status under state or federal law.

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:

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

Payroll Title: DATA SYS ANL 4 (000599)

Job Code: 000599

Job Open Date: 1/30/26

Application Review Begins: 2/17/26; open until filled

Department Code (Name): INFO (OIST)

Percentage of Time: 100

Union Code (Name): 99

Employee Class (Appointment Type): Staff: Career

FLSA Status: Exempt

Classified Indicator Description (Personnel Program): MSP

Salary Grade: Grade 25

Pay Rate / Range: The budgeted salary range that the University reasonably expects to pay for this position is $122,620-$156,500/yr. 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 $108,100-$204,900/yr.

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

Benefits Eligibility: Full Benefits

Type of Remote or Hybrid Work Arrangement, if applicable: Eligible for Fully Remote Work Arrangement

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