Job Requisition Number: 25025. Advancement Operations Unit Overview: Advancement Operations develops and delivers the centralized business systems and services that support the work of UC Berkeley’s 30 decentralized fundraising units—helping 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 unit offers services that include advancement data management and enhancement, business intelligence and analytics, business process analysis and design, and customer support. Advancement Operations also oversees information technology systems and tools, including the Cal Advancement Data System (CADS), the database and tools used by advancement professionals to conduct research and record fundraising activity. Advancement Operations encompasses three units: Advancement Information Management, Information Technology, and Advancement Planning and Analysis.
Advancement Information Management Unit Overview: Advancement Information Management (AIM) is the office of record for data related to alumni, donors, and friends of UC Berkeley. AIM helps the advancement community meet programmatic and campaign goals by providing accurate, complete data that documents the campus’s relationship with its constituents. AIM archives, enhances, and manages the data and delivers it through efficient processes and effective systems in a secure environment. In addition, AIM supports the campus advancement community with customer service on all CADS-related issues and works with campus units to provide meaningful information about that data through reporting and analysis services.
Involves planning, designing, developing, implementing and administering databases to acquire, store and retrieve data; ensures accuracy and completeness; establishes and maintains data security; migrates data to new systems; optimizes/tunes data system performance; develops database dictionaries, specifications, tables and data elements. Usually not an application developer.
Applies professional data management concepts and defined data management and IT policies and procedures in completing assignments.
Ensures accuracy, completeness, and timeliness of information maintained on alumni, donors, prospects, students, parents and friends. Identifies information requiring enhancement or correction. May identify, develop, and oversee data specializing in specific segments of data and/or data management techniques. This could include data cleanup of targeted sectors, global data enhancement projects by outside vendors, interdepartmental projects, and other initiatives with campuswide impact.
Provides service to campus partners with data management, reporting and access requests, and advises users inappropriate procedures and sources to resolve issues. Identifies data issues and trends in user requests. Works with the Data Management Lead and Director to identify and develop new customer service guidelines and resources in response to trends in user needs.
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. Researches, gathers, and analyzes information requirements and documents them using formal data definition techniques and naming standards.
Provides in-depth investigation, work and data flow analysis, uses well-developed problem-solving skills to identify data issues, gaps or needs. Provides comprehensive documentation to clearly articulate issues and opportunities and contextualize user requirements to improve data integrity and streamline processes. Utilizes or develops audit and reporting processes to investigate and detail the impact of projects and procedures, and monitors ongoing data integrity and quality. Provides feedback on the impact of system issues or improvements for data quality and delivery, and brings corrective strategies and recommendations to the Data Management Lead and other colleagues for project approval and development.
Participates in analysis, documentation and testing of data for integration, exchange or migration projects; designs, administers, and executes test and requirement scenarios. Works with the Data Management Lead to document data access gates and provide issue and risk management proposals to ensure compliance to data security and privacy policies.•Bachelors degree in related area and/or equivalent experience/training •Requires knowledge of data management systems, practices and standards. •Must have knowledge relating to logical data design and data integration strategies •Must be able to prepare simple data models under guidance of more senior professionals. •Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. •Good critical thinking skills and attention to detail. •Good interviewing and listening skills; ability to extract the details of customer requests to ensure successful completion of the request. •Strong written and oral communication skills; empathetic and collegial with demonstrated ability to engage with customers, partners and colleagues successfully.
The University of California was chartered in 1868 and its flagship campus - envisioned as a "City of Learning" - was established at Berkeley, on San Francisco Bay. Today the world's premier public university and a wellspring of innovation, UC Berkeley occupies a 1,232 acre campus with a sylvan 178-acre central core. From this home its academic community makes key contributions to the economic and social well-being of the Bay Area, California, and the nation.