Job Requisition Number: 26250. Berkeley Social Welfare trains our students for a range of leadership, research, teaching and practice roles in the profession. Students are prepared to practice at specific intervention levels and are thoroughly grounded in the knowledge of social and psychological concerns, social welfare policies and social service organizations.
Berkeley Social Welfare houses several programs designed to provide educational and training opportunities to social work students and professionals; contribute impactful research informing service delivery; and foster relationships among institutions, students and service providers in California, the United States and throughout the globe.
The Database & Finance Support Specialist reports to the Department Manager. This role is integral in the support to the School of Social Welfare. The incumbent manages financial reporting, serves as effort coordinator for the School, prepares invoice documentation for instructional grant programs, and manages the SONIA database system that supports the field program. The incumbent serves as back up support for facilities issues and coordination of desktop support with CSS IT.
Manages, plans and administers a range of administrative operations in a small to medium academic department, or a small to medium non-academic department or program. Administrative operations include budgetary financial management and human resources and some of the following functions: IT, facilities, student services, and/or contracts and grants. •Effectively maintain database (SONIA) to support tracking and organization of data/files related to field placements, students, agencies, and field faculty--this includes data entry, cleaning and maintenance and ensuring data accuracy. •Draft and edit communication templates for communications with students and agency partner contacts. •In collaboration with Administrative Director and Field Director: draft, test, and update forms, ad-hoc reports, and training guides and handouts. •Collaborate with other staff to create and develop reports, as needed. •Provide training and support to database users, including other staff, field faculty, students, and agency contacts. •Serve as primary contact for troubleshooting database-related issues.
Develops and prepares budgets and financial reports for funding which may be complex. Performs recharge administration. •Review monthly School of Social Welfare (SSW) financial reports and works with financial manager to determine chartfield errors and correct as needed. •Prepare and submit financial journals with appropriate documentation that supports the correction of chartstring errors or movement of expenses. •Perform and assist with internal controls through analysis of financial and security reports. •Deposit checks as received. •Acquire and maintain solid working knowledge of CalAnswers Financials, Campus Deposit System (CDS) and Berkeley Financial System (BFS). •Oversee the maintenance of SSW accounting files: Coordinate and train student support and clerical personnel in the file maintenance of required expense transaction documentation; Maintain archive and confidentially destroy old files as per retention policy.
Provides input into non-technical portions of grant and contract proposals. •Prepare annual Title I-VE, Mental Health, and Summer Sessions budgets and monitor and address significant budget to actual expense variances throughout the year. •Prepare quarterly billing for stipend programs and reports for departmental budget managers. •Administer departmental research and sponsored projects within the School’s Instructional Program, which primarily involves endowed chairs and Title IV-E and Mental Health awards totaling $1.8M annually. •Serves as the School’s Effort Reporting System (ERS) administrator.
Coordinates and participates in a variety of human resources activities including employment, training, classification and ensuring the completion of forms and documents related to HR and Payroll for unit/department.
Acts as back-up safety coordinator.
Other duties as assigned•Bachelor's degree in related area and/or equivalent experience/training •Thorough knowledge of University rules and regulations, processes, protocols and procedures for budget, account and fund management, personnel management or demonstrated ability to learn such topics. •Thorough knowledge of financial analysis and reporting techniques, human resources policies and procedures for staff and academic employees. •Knowledge of a variety of administrative operations activities such as events planning, basic fundraising processes, risk management planning, website design, accounting and payroll, and contracts and grants regulations and guidelines. •Knowledge of common University-specific computer application programs or demonstrated ability to learn such topics.. •Interpersonal communication skills to include verbal and written, active listening, critical thinking, persuasiveness, advising and counseling skills. •Strong skills in short term planning, analysis and problem-solving and customer service. •Demonstrated experience with database architecture and management. •Demonstrated ability to communicate technical information to technical and non-technical audiences at different levels of the organization. •Solid organizational skills, including skills in effectively coordinating and organizing multiple details within demanding time frames. •Strong verbal and written communication skills, active listening, critical thinking, multi-task and time management skills. •Good interpersonal communication skills and political acumen, including skill in effectively representing the campus publicly. •Good judgment and effective decision-making and problem resolution skills. •Must be flexible in order to respond to changing priorities effectively. •Ability to learn, understand and comply with the policies and procedures of the School. •Solid office skills and prior general office work experience. •Detail oriented with attention to accuracy.
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.