Data & Reporting Specialist (2375)

This position supports Development & Alumni Relations (DAR) initiatives through the management, integrity, and strategic use of constituent data. Serving as a centralized resource for data and reporting needs within DAR, the role maintains and enhances alumni and constituent records, ensures data accuracy and consistency across systems, and develops targeted lists and reports to support alumni engagement, fundraising initiatives, campaign performance, institutional reporting, and long-range planning. The position will also lead the development and ongoing management of SIU School of Medicine residency and fellowship alumni data, including the initial large-scale compilation, reconciliation, and ongoing maintenance of records across multiple systems and data sources.

This position primarily supports Alumni Relations initiatives by providing data stewardship, reporting, and strategic support for alumni communications, engagement, and outreach efforts. In addition, the role supports Development activities through donor and prospect reporting, campaign tracking, geographic and travel-related reporting, donor record maintenance, and other reporting needs. Through collaboration with internal departments and external partners, this position contributes to improved data quality, efficient processes, and stronger connections across the SIU School of Medicine community.

DATA MANAGEMENT & REPORTING - 70%

• Creates and maintains contact information in MD alumni class listservs and constituent profiles/lists within email marketing and database systems; distributes communications using established listservs and mailing platforms
• Collaborates with the Office of Student Affairs to compile and publish SIU SOM alumni pages and data in the annual commencement booklet
• Collaborates with the Office of Graduate Medical Education (GME) to maintain SIU SOM graduate education and residency/fellowship alumni data Leads the development, compilation, reconciliation, and ongoing maintenance of residency and fellowship alumni data across multiple systems and data sources
• Responds to departmental and interdepartmental requests for data and reports including statistical, contact, geo-regional, demographic, historical, organizational, relationship, professional, and constituent information
• Conducts institutional research related to demographic, specialty, and employment status data and uses findings to prepare periodic reports including AAMC, IPMI, EDI, SIU SOM Dean's reports, DAR Annual Impact Reports, and other reporting requirements throughout the year
• Creates and maintains targeted mailing and communication lists to support alumni engagement initiatives and Development events
• Produces geographic and regional reports for alumni, donors, and friends to support Development Officer outreach and travel planning
• Develops and compiles reports supporting annual giving campaigns, department-specific fundraising initiatives, campaign performance, and other strategic reporting needs
• Sets and interprets operating processes for alumni and constituent database systems and maintains knowledge of system features, enhancements, and upgrades; provides technical support and guidance to staff as needed
• Collaborates with IT, IR, Education Informatics, and Records and Data Management departments to ensure accurate import, maintenance, and integrity of constituent records
• Collaborates with Records and Data Management teams to implement database priorities, test updates, and participate in data governance activities
• Enters, updates, and maintains alumni and donor records through profile updates, registrations, returned mail reports, online research, staff communications, and other information sources; conducts ongoing data cleanup efforts and applies communication preferences and coding standards
• Monitors ACGME and SIU SOM GME programs for evolving specialty and residency/fellowship information
• Oversees that specific alumni updates are provided to appropriate staff for electronic file maintenance and record retention
• Maintains data collection processes for Alumni Society Board of Governors committees, mentorship initiatives, and other alumni engagement programs

DEVELOPMENT & CONSTITUENT SUPPORT - 15%

• Maintains donor and constituent records to ensure accuracy and consistency of information across systems
• Supports Development initiatives through donor and prospect reporting, campaign tracking, and constituent information requests
• Assists with donor, alumni, and prospect segmentation and reporting to support strategic outreach and fundraising activities
• Provides data, reports, and supporting materials for Development and Alumni Relations initiatives and special projects

ADMINISTRATION & DEPARTMENTAL SUPPORT - 15%

• Provides proofreading services for publications, communications, newsletters, web forms, and webpages
• Provides information and content support for alumni communications including newsletters, web content, and class materials
• Assists in preparation and distribution of alumni update materials and related communications
• Assists Development and Alumni Relations staff with event support and provides data and materials needed for meetings, committees, and outreach efforts
• Meets with Development and Alumni Relations staff to collaborate on team objectives
• Develops professional relationships with coworkers, alumni, and external stakeholders related to departmental operations
• Participates in departmental planning initiatives, professional development activities, and other duties as assigned