Data and Reporting Specialist

University of Detroit Mercy; Detroit (MI); On-site; USD 55,000 - 75,000; Full time

Job summary

University of Detroit Mercy is seeking a Data/Reporting Specialist to support the Advancement Systems Manager by maintaining data integrity in the alumni/donor database and enabling effective fundraising and engagement. The role designs user-specific reports, trains staff on Raiser's Edge, provides system support, and prepares month-end, year-end, and quarterly updates.

Strong analytical skills, Excel proficiency, and experience with CRM reporting are essential, along with confidentiality and

Qualifications

• College degree or 4–8 years of related experience.
• Experience with Raiser's Edge/NXT is preferred.
• Experience with CRM data, reporting, and data analysis.
• Non-profit or higher education experience is a plus.

Responsibilities

• Month-End reporting.
• Upload data to Banner (Fupload).
• Generate VSEYearly Report.
• Create US New Yearly Report.
• Prepare NCOA Quarterly Updates.
• Run Deceased Finder processes.
• Process deposits.
• Produce year-end accrual reports.
• Assist with inNXTPortal.
• Train staff on procedures to ensure proper data handling.
• Provide technical support to Advancement staff and address system inquiries.

Skills

Excel

Word

Outlook

Data Entry

Analytical

Education

Bachelor's degree

Tools

Raiser's Edge/NXT

Job description

The Data/Reporting Specialist assists the Advancement Systems Manager in maintaining data integrity for a large alumni/donor database, supporting fundraising and alumni engagement efforts. Key duties include providing accurate data and reports, designing user-specific reports, training staff on the Raiser's Edge system, offering technical support, creating documentation, and managing various reports such as month-end, year-end, and quarterly updates. The role involves data entry, processing deposits, overseeing student workers, and supporting system functions like the NXT portal. The specialist also develops queries and reports, improves documentation, and ensures data accuracy and confidentiality.

Essential Duties and Responsibilities

• Month-End Reporting 7%
• Fupload to Banner 5%
• VSEYearly Report 5%
• US New Yearly Report 5%
• NCOAQuarterly Updates 5%
• Deceased Finder 5%
• Deposit Processing 3%
• Year-end accrual reporting 5%
• Assist with inNXTPortal 7%
• Training new & existing staff to ensure correct procedures are followed 5%
• Provide technical support to University Advancement staff, addressing system-related inquiries and issues 5%

Minimum Qualifications

• Education – A college degree or four to eight years of work experience in a related field.
• Employment – Four to eight years of work experience in a related field. (Equivalent combination of education and employment).

Preferred Qualifications

• Proficient in Raiser's Edge/NXT Database or other development database experience (3-5 Years of experience).
• Experience with data processing in a non-profit/high education setting.
• Experience maintaining CRM data, creating reports, and analyzing data.

Knowledge, Skills, and Abilities

• Excellent analytical and problem-solving skills.
• Proficiency in Excel, working knowledge of Microsoft Word and Outlook required Data Entry
• Polite customer service skills
• Good Communication (oral/written), and organizational skills
• Ability to work in a diverse setting (including University community/donors)
• Ability to work under deadline pressure with attention to detail and accuracy
• Ability to multi-task and meet deadlines
• Ability to dynamically adjust the data output to meet customer requirements.

Physical Requirements

Job may require lifting light weight objects (1 to 10 pounds) with no repetitive bendingor stooping. Occasionally lift average weight objects (1 to 10 pounds).

Regular exposure to favorable conditions such as those found in a normal office.

Commensurate with experience

Anticipated Schedule

Mon to Fri, 8:30 AM to 5:00 PM

Additional Information

Willing and able to learn the job and environment. Maintain Confidentiality. Work effectively and cooperatively as a team member within Department and with all departments. Attend meetings. Observe dress and conduct codes. Meet attendance standards as established and provide proper notice of absence. Perform other duties as assigned by supervisor. Follow proper etiquette and guidelines when responding to emails.