Search for University Jobs in Staff & Non-Managerial Professionals

BI Engineer (7199U), Campus Applications & Data - 64809

About Berkeley

At the University of California, Berkeley, we are committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome and included. Our culture of openness, freedom and belonging make it a special place for students, faculty and staff.

The University of California, Berkeley, is one of the world's leading institutions of higher education, distinguished by its combination of internationally recognized academic and research excellence; the transformative opportunity it provides to a large and diverse student body; its public mission and commitment to equity and social justice; and its roots in the California experience, animated by such values as innovation, questioning the status quo, and respect for the environment and nature. Since its founding in 1868, Berkeley has fueled a perpetual renaissance, generating unparalleled intellectual, economic and social value in California, the United States and the world.

We are looking for equity-minded applicants who represent the full diversity of California and who demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community. When you join the team at Berkeley, you can expect to be part of an inclusive, innovative and equity-focused community that approaches higher education as a matter of social justice that requires broad collaboration among faculty, staff, students and community partners. In deciding whether to apply for a position at Berkeley, you are strongly encouraged to consider whether your values align with our Guiding Values and Principles, our Principles of Community, and our Strategic Plan.

At UC Berkeley, we believe that learning is a fundamental part of working, and our goal is for everyone on the Berkeley campus to feel supported and equipped to realize their full potential. We actively support this by providing all of our staff employees with at least 80 hours (10 days) of paid time per year to engage in professional development activities. To find out more about how you can grow your career at UC Berkeley, visit grow.berkeley.edu.

Departmental Overview

Berkeley IT believes in and fosters a workplace environment where people can bring their diverse skills, perspectives and experiences toward achieving our goals through a process of critical inquiry, discovery, innovation, while simultaneously committing to making positive contributions towards the betterment of our world.

In addition, members of the Berkeley IT community have created and endorse the following values for our organization to augment and amplify the campus principles:

• We champion diversity.
• We act with integrity.
• We deliver.
• We innovate.

Diversity, Inclusion, and Belonging are more than just suggestions for us. They are the guiding principles underlying how we come together, develop leaders at all levels of the organization, and create an environment that unites us. We affirm the dignity of all individuals, call upon our leaders to address critical issues with integrity and intention, respect our differences as well as our commonalities, and strive to uphold a just community free from discrimination and hate.

Team Overview:

Data Solutions resides within the broader Berkeley IT Campus Applications & Data unit, which ensures that the University's mission-critical applications and data are aligned, designed, integrated, and managed together. Data Solutions consists of the Data & Analytics team, responsible for campus-wide analytics and reporting, as well as Engineering & Integration Services, responsible for data integration and architectural considerations across campus applications.

UC Berkeley's Data & Analytics team seeks a BI Engineer who will develop and support BI solutions to turn data into actionable insights supporting university decision-making, analytics, and research. The team supports tw analytics platforms built using Oracle Analytics Service and Tableau. An ideal candidate will have solid experience developing reports. As the BI Engineer, the candidate should have solid skills in Report development, writing complex SQL queries, security, testing, troubleshooting, metadata management, and documentation.

Application Review Date

The First Review Date for this job is: February 26, 2024

Responsibilities

Design:

• Contributes to the design of new architectural components, developing documentation and translating functional requirements into technical specifications for self-service and curated BI projects.
• Plans and conducts data analysis efforts, participates in design sessions and collaborates with business ETL developers, architects, technical staff, and critical business sponsors to identify and recommend solutions.
• Works closely with senior team members to update data models supporting data warehouse/data lake solutions.
• Helps to maintain data models and data definitions.

Development:

• Creates and maintains optimal BI solutions under the mentorship of senior analysts.
• Assembles large, complex data sets that meet functional/non-functional business requirements.
• Works with data architects and subject matter experts to design and develop data models, security structures and reports across subject areas and technical domains.
• Identifies, designs, and implements internal process improvements, including automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Under the guidance of architects and senior engineers, implements the infrastructure required for supporting a wide variety of business domains and the growing needs of the campus analytics community.

Standards:

• Maintains best practices for the design, development and support of BI solutions including self-service analytics; documentation; metadata creation, use and maintenance; and data naming standards.

Support:

• Works with other team members to continually improve production operations, including independently working on code deployments, bug fixes and overall release management and coordination.
• Ensures resilient operations stability via disaster recovery and business continuity planning and documentation.
• Coordinates with database, network and platform services teams on infrastructure capacity planning and implementation.
• Manages production support for critical BI applications on a rotation basis.
• Monitors and takes appropriate action to maintain the integrity of the reporting solutions, including security and data quality issues.
• Responds to and resolves operational problems as necessary.
• Documents, troubleshoots and resolves day to day data issues.
• Works with DBA's, system administrators, and other IST support staff to complete scheduled hardware and software maintenance activities.
• Works with data security officers and auditors to ensure quality assurance programs are compliant with corporate standards.
• Responds to customer concerns and potential issues.
• Enforces strategies to ensure the stability and availability of the data warehouse/data lake environment.
• Completes professional development and training and other duties as assigned.

Required Qualifications

• Experience in the installation, configuration and security of BI environments; report development best practices and standards; and data lake/warehouse architectures.
• Ability to collect basic business requirements and build reporting solutions to convert raw data into usable information for analysts and business users
• Adept at developing and maintaining reports and dashboards.
• Robust curiosity across multiple data domains, including student, finance and HR.
• Ability to communicate technical concepts to non-technical users.
• Working knowledge of data visualization techniques and tools.
• Ability to write complex SQL queries across extensive data sets.
• Experience in scripting languages, e.g. Python.
• Strong analytic skills related to working with various source data systems, both structured and unstructured.
• Experience in projects that deliver relevant insights / analytics.
• Ability to identify, analyze, and interpret trends or patterns in complex data sets and tell data "stories" via dashboards and reports.
• Knowledge relating to logical data design, data lake/warehouse design, data integrations, as well as the management of web content or other unstructured data.
• Strong written and documentation skills for communicating specifications, processes and metadata to both technical and non-technical audiences.
• Agile, quick self-learner, highly self-motivated with a strong sense of product ownership, and creative problem solver.
• Demonstrated commitment to the advancement of diversity, equity, inclusion, belonging, and justice at UC Berkeley and Berkeley IT.
• Demonstrated commitment to the advancement of diversity, equity, inclusion, belonging, and justice.

Education/Training:

• Bachelor's degree in related area and/or equivalent experience/training.

Preferred Qualifications

• Understanding of Oracle/PeopleSoft Financials, HCM and/or Campus Solutions systems and data.
• Experience maintaining and developing Oracle Analytics RPD, reports and dashboards.
• Experience developing Tableau data extracts and dashboards.
• Experience with data engineering concepts and tools like AWS Glue.
• Familiarity with Cloud data technology stacks (AWS, Snowflake, etc.) and associated analytics services
• Familiarity with Data Science concepts.
• Experience with Master Data Management and communicating its value.

Salary & Benefits

For information on the comprehensive benefits package offered by the University, please visit the University of California's Compensation & Benefits website.

Under California law, the University of California, Berkeley is required to provide a reasonable estimate of the compensation range for this role and should not offer a salary outside of the range posted in this job announcement. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, analysis of internal equity, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience.

The budgeted salary or hourly range that the University reasonably expects to pay for this position is $95,000.00 - $122,000.00.

• This is a 100%, full-time (40 hours per week), career position that is eligible for full UC benefits.
• This position is exempt and paid monthly.
• This position is eligible for flexible, hybrid or fully-remote work (telecommuting) based on candidate availability and business needs.

How to Apply

To apply, please submit your resume and cover letter.

Conviction History Background

This is a designated position requiring fingerprinting and a background check due to the nature of the job responsibilities. Berkeley does hire people with conviction histories and reviews information received in the context of the job responsibilities. The University reserves the right to make employment contingent upon successful completion of the background check.

Equal Employment Opportunity

The University of California 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, or protected veteran status. For more information about your rights as an applicant, please see the U.S. Equal Employment Opportunity Commission poster.

For the complete University of California nondiscrimination and affirmative action policy, please see the University of California Discrimination, Harassment, and Affirmative Action in the Workplace policy.

Referral Source info

This job is part of the Employee Referral Program. If a UC Berkeley employee is referring you, please ensure you select the Referral Source of "UCB Employee". Then enter the employee's Name and Berkeley email address in the Specific Referral Source field. Please enter only one name and email.



To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucb/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=21&JobOpeningId=64809&PostingSeq=1