Database Manager

Otterbein Universitys Advancement office is poised to begin a conversion to Slate for Advancement. The Database Manger will play a key role in overseeing data extraction while assisting the Executive Director, Advancement Services with the migration processes. Collaboration with stakeholders (IT teams, advancement and other team members) to align technical requirements with business goals will be critical.

During the transition, assists with maintaining the current system (Momentive, Millennium) and corollary products licensed for use by the advancement team including GiveCampus.

Requires 3+ years of experience in database administration, proficiency in SQL/ETL processes. Strong analytical skills for troubleshooting and optimizing data workflows are essential. Experience in higher education enhances candidacy as does experience with Slate CRM.

Post-conversion, this role will be responsible for overseeing the management, optimization, and integrity of the Slate CRM system for all Institutional Advancement departments (Development, Engagement, and Advancement Services). The goal being to help the division increase donor acquisition and fundraising dollars and increase efficiency while decreasing departmental costs such as postage/printing, labor, and licensing fees. Help provide visualization and understanding of complex datasets using tools like Power BI; works closely with the University's Information and Technology Services Department (Ellucian) by performing the following duties: JOB RESPONSIBILITIES

ESSENTIAL DUTIES AND RESPONSIBILITIES post conversion includes the following. Other duties may be assigned.

50% Administration and System Support

Monitors system performance, troubleshoots issues, and performs regular data integrity checks, collaborating with effected departments and the Universitys Office of Information Technology Services (ITS) to achieve resolution; Oversees the management, optimization, and integrity of the Slate CRM system, ensuring smooth operation and performance; facilitates ongoing development of the CRM, implements new features; installs, implements, and supports any additional software particularly as it relates to fundraising purposes within the Institutional Advancement division; Ensure system compliance with university policies, security standards, and best practices. Leads PCI discussions and develops a comprehensive plan for departmental compliance.

20% Acts as a primary technical resource for Institutional Advancements administrative computing applications

provides ongoing support, including installation of software upgrades and fixes, and maintains the database and other Advancement software for 7x24 availability; contributes to policies and procedures designed to ensure consistent data architecture to promote high quality, maintainable application components; Oversees compliance with security standards and manage exclusive permissions, such as Security Administrator roles; Configures and customize Slate, including user accounts, permissions, and roles; Ensures data security, integrity, and compliance with institutional policies; contributes to the design and implementation of a security plan for Advancement systems;

20% Serves as the divisions primary data manager

Manages data operations, including importing, exporting, and updating student, parent, and faculty/staff data ensuring accuracy and consistency across systems; Develops and runs complex queries and generates reports to support advancement workflows and data-driven decision-making; Oversees yearly cycle preparation, system updates, and operational efficiencies within the system; Implements internal and external technologies for monitoring, tracking and reporting the progress toward meeting the Division of Institutional Advancements goals and the Universitys return on investment in the Division which includes maintaining and enhancing the divisions Power BI dashboards;.

10% Adheres to all University and departmental policies and procedures, maintains the highest level of confidentiality; Collaborate with IT, advancement, and other stakeholders to enhance system functionality and integrate with other institutional systems; keeps abreast of the latest trends in technology used by business and peer institutions; Serves as a member of the Otterbein University AI task force Serves on institutional committees as assigned; other duties as assigned. QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE: Required: Bachelors degree in computer science or a related technical field with at least 3 years of experience, proficiency in SQL/ETL processes, as well as practical knowledge of database administration, strong analytical skills for troubleshooting and optimizing data workflows, and related experience in advanced technologies, application design, and analysis; Experience in higher education enhances candidacy.

MISSION CRITICAL COMPETENCIES:

Accountability and Professionalism:

• Follows through on assignments and takes ownership of work.
• Adheres to procedures, best practices, and honors work schedules.
• Shows commitment to being dependable, professional, and a responsible colleague.
• Completes work in a timely manner, within established deadlines, and uses the resources available.
• Dedicates effort toward professional development.
• Demonstrates flexibility and adaptability.

Collaboration and Teamwork:

• Effectively builds partnerships and successfully works collaboratively with others to accomplish shared goals.
• Demonstrates the ability to work well in teams both within and outside of the department to achieve the best possible outcomes.
• Communicates effectively and professionally.

Diversity and Inclusion:

• Recognizes the value that different perspectives and cultures bring to our University community.
• Seeks to understand different perspectives and cultures.
• Helps create a workplace that recognizes and encourages diversity.
• Is sensitive to cultural norms, expectations, and ways of communicating.

Integrity and Trust:

1. Treats people with respect, maintains confidentiality, and inspires the trust of others.

Job Knowledge:

• Demonstrates quality product including accuracy and thoroughness in work required for the position.

1. Works with diligence and identifies opportunities to streamline or improve processes.

CERTIFICATES, LICENSES, REGISTRATIONS: N/A

LANGUAGE SKILLS: Must demonstrate excellent verbal and written English skills including grammar.

MATHEMATICAL SKILLS: Must be competent in general math and have the ability to use excel.

TECHNICAL SKILLS: Required: Expertise in Windows 10, Office 2010 products, client/server networks on a Windows operating system, web browsers (PC, Apple and mobile), RDBMS, mobile technologies, social media, SSL websites, SSIS, SSMS, and cloud computing.

Prior work experience in a fund-raising and/or non-profit organization preferred. Knowledge of general office procedures. Must take pride in and be thorough in quality of work produced; must be able to use general office equipment including office PC, copier, telephone, etc.

REASONING ABILITY: Demonstrated ability to meet deadlines and work independently; must be able to interact positively with a variety of constituencies; demonstrated ability to work well in team environments; must possess excellent attention to detail; must possess excellent customer service skills; must exercise initiative and independent judgment in unusual or new situations.

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to talk or hear, sit, reach, and use repetitive motions of hands and wrists. The employee must occasionally stand, walk, stoop or bend. The employee must occasionally lift and/or carry up to twenty pounds and occasionally push and/or pull up to twenty pounds. This position requires close vision. Must be able to meet regular and predictable attendance standards.

WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Duties are performed in an environmentally controlled office setting; SUPPLEMENTAL INFORMATION

This description is intended to indicate the kinds of tasks and levels of work difficulty that will be required of positions that will be given this title and shall not be construed as declaring what the specific duties and responsibilities of any particular position shall be. It is not intended to limit or in any way modify the right of any supervisor to assign, direct and control the work of employees under supervision. The use of a particular expression or illustration describing duties shall not be held to exclude other duties not mentioned that are of similar kind of difficulty.

Otterbein University is an Equal Opportunity Educator and Employer.