Data Systems Analyst (7199U) #87317

At the University of California, Berkeley, we are dedicated to fostering a community where everyone feels welcome and can thrive. Our culture of openness, freedom, and belonging make it a special place for students, faculty, and staff. As a world-leading institution, Berkeley is known for its academic and research excellence, public mission, diverse student body, and commitment to equity and social justice. Since our founding in 1868, we have driven innovation, creating global intellectual, economic, and social value. We are looking for applicants who reflect California's diversity and want to be part of an inclusive, equity-focused community that views education as a matter of social justice. Please consider whether your values align with our Guiding Values and Principles, Principles of Community, and Strategic Plan.

At UC Berkeley, we believe that learning is a fundamental part of working, and provide space for supportive colleague communities via numerous employee resource groups (staff organizations). 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 full-time staff employees with at least 80 hours (10 days) of paid time per year to engage in professional development activities. Find out more about how you can grow your career at UC Berkeley.

Departmental Overview

University Development and Alumni Relations (UDAR) strengthens Berkeleys excellence through engagement with alumni, parents, undergraduate and graduate students, and friends of the University, raising public awareness about Berkeley and increasing private philanthropy. UDAR provides overall direction for the campus philanthropic advancement strategies and works to strengthen unit development in partnership with campus fundraisers. The Division handles a range of central activities and services encompassing communications, stewardship, prospect development, data management, gift management, reporting and analytics, and more.

Advancement Operations develops and delivers the centralized business systems and services that support the work of UC Berkeleys 30 decentralized fundraising unitshelping them collaborate and communicate in order to maximize their collective results. Advancement Operations also provides governance through its role as the official source of alumni and fundraising data.

The Advancement Information Services (AIS) unit develops and delivers the primary business data and systems that support the work of UC Berkeleys centralized and decentralized fundraising activities. AIS oversees several interrelated information technology systems and tools, including the Cal Advancement Data System (CADS), the database in which advancement professionals research and record fundraising activity. AIS encompasses three units: Data and Business Solutions, Technology Services, and Strategic Planning and Management.

Data Management (DM) is the office of record for data related to alumni, donors, and friends of UC Berkeley. DM helps the advancement community meet programmatic and campaign goals by providing accurate, complete data that documents the campuss relationship with its constituents. DM protects, archives, enhances, and manages the data and delivers it through efficient processes and effective systems in a secure environment. In addition, DM supports the campus advancement community with customer service on all CADS issues.

Position Summary

The Data Systems Analyst plays a key role in leveraging data to drive alumni engagement, donor relations, and fundraising strategy. This position ensures the integrity, accessibility, and strategic use of advancement data across platforms and tools University Development and Alumni Relations (UDAR) uses daily to engage constituents. Serving as a bridge between technical teams and advancement professionals, the Data Systems Analyst manages and/or develops data practices, guidelines, dictionaries, and services that support data standardization in alignment with UDAR's data and governance strategies. The Data Systems Analyst ensures compliance with data privacy standards (such as FERPA and donor confidentiality) and partners closely with business units to enable data-driven strategies that enhance institutional fundraising and engagement efforts.

Application Review Date

The First Review Date for this job is: July 20, 2026. For full consideration, please apply on or before the first review date.

Responsibilities

• Applies professional and broadly defined business analysis and data / information administration and data use concepts to manage and perform complex assignments.
• Identifies data sources, target populations, and/or new constituencies to be enhanced or established.
• Develops methodology for data enhancement or retrieval in assigned specialty area(s).
• Protects integrity, authenticity, and security of data in all assignment activities.
• Independently designs and implements regular data audits to identify and resolve issues related to data quality, completeness, consistency, and accuracy.
• Develops audit methodologies, recommends corrective actions, and collaborates with business partners to ensure continuous data integrity improvements.
• Independently manages documentation, including data dictionary, business rules, practices, and processes.
• Translates legacy processes and practices to future state.
• Provides ongoing CRM training and support for business units as it pertains to data uploads, standards, and maintenance.
• Independently designs information transformation and upload processes.
• Utilizes programming skills to clean, prepare, and optimize data sets, creating efficiencies and improving data quality.
• Conducts complex data management research and plans metadata acquisition for sets of unstructured data objects such as collections of images, documents or recordings.
• Coordinates student worker schedules and assignments.
• Systematically reviews their work for accuracy and completeness.
• Proactively meets with student workers to identify, resolve, and prevent errors.
• Continuously works on skill building and professional development to advance their role.

Required Qualifications

• Minimum two years experience working with data quality and governance issues and requirements.
• Minimum two years experience applying knowledge of data management systems, practices and standards.
• Demonstrated proficiency in writing SQL, programming/scripting languages (e.g., Python, R), or utilizing advanced spreadsheet automation tools (e.g., Excel Power Query, Google Apps Script) for data analysis, transformation, and process automation.
• Demonstrated ability to conduct work using relevant state, federal, and global rules and regulations as it pertains to data management and privacy.
• Demonstrated ability to work with others from diverse backgrounds.
• Demonstrated effective communication and interpersonal skills.
• Demonstrated service orientation skills.
• Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
• Self-motivated and works independently and as part of a team.
• Demonstrated strong problem-solving skills.
• Able to learn effectively and meet deadlines.
• Strong organizational skills.
• Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.
• Ability to represent relevant information in abstract models.
• Critical thinking skills and attention to detail.
• Ability to conduct quality assurance testing with attention to detail.

Preferred Qualifications

• Familiarity with Salesforce platform and object structures.
• Familiarity with logical data design and data mapping or data conversion.

Education / Training

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

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 annual salary range that the University reasonably expects to pay for this position is $102,000 - $112,000.

• This is an exempt, monthly-paid position.
• This is a full-time (40 hours/week) Career position eligible for UC benefits.

How to Apply

To apply, please submit your resume and cover letter.

Other Information

• This position is eligible for up to 90% remote work within the United States. Exact arrangements are determined in partnership with your supervisor to meet role responsibilities and department needs and are subject to change.
• This is not a visa opportunity. This position does not include sponsorship of a new consular H-1B visa petition that would require payment of the $100,000 supplemental fee.

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.

Misconduct

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 allegations 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

Equal Employment Opportunity

The University of California 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, age, protected veteran status, or other protected status under state or federal law.