|The Database and Enrollment Specialist in the Financial Aid unit provides support to the Law SchoolÃs Financial Aid Office. The position manages and coordinates the flow of data between various applications and databases designed to package and provide financial aid information to students; creates specialized reporting structures for various units and campus departments and coordinates the receipt and transfer of electronic data from various sources. |
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. Applies sophisticated analytical approach to utilizing the data in standard and novel ways. Traditionally not an application developer.
Responsible for data management and analysis of BerkeleyÃs LawÃs financial aid programs which include Loan Repayment Assistance Program (LRAP).
Applies professional data management concepts and defined IT and data management policies and procedures in completing assignments.
Ã¯ Responsible for all facets of financial aid data management, including financial aid reporting on all Berkeley Law financial aid programs. Ã¯ Partners with Associate Directors in Financial Aid and Information Technology departments to assess and improve existing data management, reporting and business processes. Ã¯ Supports data management and communication plans to financial aid recipients and Loan Repayment Assistance Program (LRAP) participants. Ã¯ Supports Associate Directors and CFO in data reporting and analysis. Ã¯ Manages multiple in-house databases including LRAP, Grants, Scholarships databases, used year-round, and task-oriented databases such as ABA Reporting processing; maintains and ensures secure data storage and integrity of data relationships. Ã¯ Working with Berkeley Law IT unit, develops and manages recovery systems for all data to a point of known consistency in case of system failure Ã¯ Conducts intra-office data retrieval, collection, modification, and output Ã¯ Develops & builds customized reporting structures for Financial Aid Office needs Ã¯ Combines and organizes data from external sources into in-house databases to assist with internal processes Ã¯ Creates reports from Grant/Scholarship/Loan/LRAP data in various formats as requested Ã¯ Downloads, installs, and troubleshoots access to external databases for Financial Aid staff
Produces management reports and analysis of financial aid programs for senior management and financial aid staff, including Dean, CFO, and Director of Admissions Ã¯ Produces ad-hoc analysis, forecasts and reports for senior management on key financial aid trends, such as average student loan debt, loan repayment expense projections as well as yield and other data. Ã¯ Develops & builds customized reporting structures for Financial Aid Office needs Ã¯ Develops, implements, and administers datasets using multiple data tables and criteria for generating reports and tracking information from multiple sources Ã¯ Builds additional database components as necessary; works with a variety of database components for addressing emerging and ongoing needs Ã¯ Conducts data analysis for annual cost modeling and ABA survey, and statistical research in response to internal/external requests; coordinates data-input and calculations for grants
Assists with implementation of financial aid business processes Ã¯ Developing query to identify population of students for communication messages. Ã¯ Supporting data processes for institutional aid packaging programs.Ã¯ Requires knowledge of data management systems, practices and standards. Must have advanced SQL experience and advanced experience in Microsoft Excel and Access. Ã¯ Must have knowledge relating to logical data design, data warehouse design, data integration and the manipulation of unstructured data. Ã¯ Must have working knowledge of statistical and financial concepts Ã¯ Must be able to prepare simple and complex data models under guidance of more senior professionals. Ã¯ Must be familiar with important types of data models, such as logical/relational models, dimensional models and document models. Ã¯ Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. Ã¯ Must have ability to analyze data and verbally communicate resulting analysis appropriately based on audience Ã¯ Critical thinking skills and attention to detail. Ã¯ Good interviewing and listening skills. Ã¯ Strong written and oral communication skills. Ã¯ Excellent interpersonal skills; ability to interact effectively with a diverse population. Ã¯ Ability to work independently as well as a critical member of the Financial Aid team. Ã¯ Ability to successfully complete a conviction history check.