The Database Analyst/Report Writer (Analyst) manages the Office of College Advancement’s (OCA) relational database system, including database programming, data retrieval and customized report writing to support the fundraising and relationship-building mission of the department. Reporting directly to the Director of Advancement Services (Director), this position plays an essential role in bridging the gap between the data elements and the high-level needs of various team members throughout the OCA and Harvey Mudd College (HMC). The Analyst will play a significant role in the conversion to and implementation of a new Advancement CRM database (Blackbaud Raiser’s Edge NXT), including developing new data models and reports.
The Analyst must be a highly collaborative, customer centric individual who has a proven track record of effective communication skills, both verbal and written, and will thrive in a fast-paced team environment. OCA currently utilizes Jenzabar CX, a relational database in which all constituent and giving information is stored; IBM Cognos Analytics, OCA’s main reporting tool; and relies heavily on a set of highly customized data tables and scripts, which have been designed to fit OCA’s reporting needs. The analyst will work closely with consultants to determine the best transition path from Jenzabar CX to Blackbaud Raiser’s Edge NXT.
Paramount to the work of the Analyst – as a member and representative of Advancement and as a member of the broader HMC community – is the appreciation for and commitment to a clearly articulated set of core departmental values that were established in 2011 by all members of the Advancement Office, and which align closely with the HMC Student Honor Code. Specifically, the Advancement Office core values include a commitment to act – personally and professionally – in a manner that demonstrates Integrity, Compassion, Accountability, Respect, and Excellence (ICARE).
About Harvey Mudd College:
Located in the heart of Claremont, California, 35 miles east of Los Angeles, Harvey Mudd College is a highly selective undergraduate liberal arts college offering degrees in science, technology, engineering and mathematics. HMC enrolls about 800 students and is a member of The Claremont Colleges, which comprises five undergraduate colleges and two graduate institutions. According to students, professors, and alumni, what makes Harvey Mudd distinctive is its collaborative, cross-disciplinary nature. The working environment is built on collaborative relationships between and among all members of the campus community and a deep commitment to the College’s mission to educate students “so that they may assume leadership in their fields with a clear understanding of the impact of their work on society.”
Summary of Job Responsibilities:
Provide day-to-day oversight and maintenance of database stored procedures and custom tables, including the organization, import, and extraction of data to/from database tables. Manage the security of data and report access for database users. Develop and maintain clear and complete documentation for all reports, stored procedures, and custom tables. Effectively collaborate with and interpret fellow OCA team members’ requests to design, program and deliver customized reports tailored to fit their needs. Identify opportunities to streamline processes and improve workflows. Provide leadership and guidance in the conversion to and implementation of a new advancement CRM suite, including active participation in strategic discussions regarding data related matters, data mapping, report development, system integrations, and development of new data models. In collaboration with the Director, take a leading role with the creation and implementation of departmental policies and procedures to ensure compliance with the College’s policies regarding data security and privacy, document retention, and other relevant policies. Maintain a close working relationship with both the College’s IT Department (Computing and Information Services or CIS) and the IT departments throughout The Claremont Colleges and the Claremont University Consortium (CUC) through effective communication and collaboration on common data projects. Perform other responsibilities and tasks as assigned.
Summary of Qualifications:
Education: Bachelor’s degree in Computer Science or related field, or any combination of relevant education, training, and experience that provides the required knowledge, skills, and abilities of the position.
Experience: Three to five years of experience in managing data utilizing a complex relational database system, database programming, data retrieval, and report writing.
Knowledge, Skills and Abilities: Intermediate to advanced knowledge of SQL as implemented in a database system such as Informix, SQL Server, Oracle, or MySQL. Extensive experience with report development applications such as IBM Cognos, SQL Server Reporting Services (SSRS), or Crystal Reports. Experience writing SQL queries, scripts, or stored procedures to perform ETL (Extract, Transform, and Load) processes and to troubleshoot issues with existing stored procedures. Ability to communicate with users to gather requirements. Excellent information technology skills with aptitude to learn and effectively utilize a variety of software tools at a “power user” level.
Preferred: Experience in higher education and/or fundraising/advancement, including an understanding of the advancement process and terminology. Experience assisting with a database conversion. Intermediate to advanced knowledge of Linux. Experience working with Jenzabar CX, Blackbaud Raiser’s Edge NXT, or other fundraising CRMs. Experience with IBM Cognos Analytics (Report Studio and Framework Manager), iModules, Salesforce Marketing Cloud, and/or Workday. Familiarity with RESTful Web Services and APIs.
Please visit www.hmc.edu/employment to view a complete job description for this position and obtain information about how to submit an application. Information about HMC’s competitive benefits package is available at www.hmc.edu/hrbenefits.
Deadline to apply:
Position will remain open until filled.
Harvey Mudd College is an Affirmative Action/Equal Opportunity Employer. Qualified applicants will be given consideration for employment without regard to age, race, gender, national origin, sexual orientation, protected veteran’s status, disability, or any other characteristics protected by applicable law.
The Claremont Colleges, a consortium of five undergraduate liberal arts colleges, two graduate institutions, and Claremont University Consortium, which provides shared institutional support services, is reminiscent of the Oxford-Cambridge model. The undergraduate colleges include Pomona College, Scripps College, Claremont McKenna College, Harvey Mudd College, and Pitzer College. The two graduate institutions include Claremont Graduate University and Keck Graduate Institute.