Data and Reporting Analyst

Job: Development

Location: Office of Development

Schedule: Full-time

Classification Level: I

Data & Reporting Analyst

Position Summary:

The Office of Development is one of higher education’s premier fundraising organizations, raising over $1.5 billion last year to support University endeavors. The Development Services department within the Office of Development is responsible for processing all donations, over 130,000 in 2015, and managing over 1.5 million records of information for donors, alumni, and friends of the University.

Reporting to the Manager, Strategic Projects & Data Management, in Development Services, the Analyst is responsible for managing donor and fundraising data, granting access and authorities for this data, creating and analyzing reports, and helping to maintain data tables. This position helps to prioritize and manage projects to standardize and update existing data. The Analyst also supports the Biographic Services team with data update projects as needed.

Major Responsibilities:

Work independently to assess and produce relevant, standard, or custom information from PostGrads, Salesforce, and Oracle on gift, pledge, prospect tracking and volunteer data by querying data repositories and generating the associated information. Distribute and disseminate reports to applicable agencies, researchers, management and other internal end-users
Develop expertise in how the Alumni and Donor data is structured in PostGrads, Salesforce, and Oracle and the ways this information can provide value to business units across Office of Development (OOD). This includes developing a thorough understanding of detailed reporting needs for audiences across OOD
Support TST (Help Desk) in responding to inquiries from OOD staff about the context and use of the data
Assist in the effort to maintain a high level of data integrity within the core gift and entity record information that is maintained by the Development Services (DS) team. Identify potential issues with data accuracy, access, and use. Oversee process management on primary DS systems
In collaboration with the technical teams that support the database, resolve data issues as they arise. Work collaboratively with the appropriate staff to develop and execute project plans, escalate and resolve issues, manage project timelines
Write and execute data cleanup plans. Maintain documentation including overviews, query specifications, and processes and procedures
Partner with Manager and Associate on variety of efforts to enhance knowledge among OOD staff about gift and pledge data, including participation in Q&A sessions, preparation of report or process documentation, and training sessions
Provide assistance to data managers and staff when they are challenged by particularly difficult data queries pertaining to gift, pledge and prospect tracking data
For new database and system functionality, work with IT Business Analysts and users to understand business goals, needs, and requirements. Review specifications, with a focus on creating user-friendly solutions and comply with University policies. Develop test cases and review product prior to release
Write and execute test plans, develop and deliver training materials. Maintain documentation including application overviews, requirements specifications, processes and procedures, and user guides
Support the Biographic Services team in organizing and coordinating data update projects, including, preparing and standardizing data files received from campus partners to be compatible with DS’s Batch Data Input application. May require negotiation with campus partners to obtain data in a useable format.
Contribute to development and maintenance of process documentation for a range of maintenance tasks required to support the alumni/donor database
Grant authority for system access to the database. Understand, apply, and ensure compliance with internal policies and external regulations which may require interpretation and conferral with DS and OOD management

Knowledge, Skills, and Abilities:

Bachelor’s degree and three years of relevant experience or combination of education and relevant experience
Proficiency in business applications, such as Microsoft Office suite, especially Excel
User knowledge and demonstrated experience with financial systems and complex databases; specific experience with Oracle Business Intelligence, Salesforce, or PostGrads (BSR Advance) a plus.
Understanding and ability to apply basic accounting skills and concepts
Ability to prepare clear and accurate materials and reports for internal customers
Experience acting in a service role and providing excellent customer service to clients
Ability to effectively educate and inform internal audiences, which includes well-developed listening skills and understanding of how to adapt communications to meet internal customer needs
Experience documenting work and adhering to defined policies and procedures
Basic project management skills and ability to contribute as part of a project team, which includes possessing a collaborative work style
Superior organization skills and attention to detail in all aspects of work
Solid interpersonal skills and the ability to work well with a variety of colleagues and comfortably within the culture of the Office of Development

Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.

Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of the job.