Database Management Associate - MUSC Foundation

Key Responsibilities

Database Administration, Security, Configuration, and Training

• Administer user accounts, security roles, permissions, and access levels within the CRM system and related systems.
• Review and fulfill access requests based on job responsibilities, established security standards, and approved authorization; conduct periodic reviews to identify outdated or unnecessary access.
• Maintain database configuration elements, including tables, code values, attributes, constituent codes, action types, relationship types, and other system settings.
• Support system updates, enhancements, and releases through testing, validation, issue tracking, and communication with affected users.
• Serve as an internal resource for database access, configuration, data standards, functionality, and appropriate system use.
• Provide database training and user support, including onboarding, role changes, troubleshooting, system navigation, data entry, imports, and established database procedures.
• Develop and maintain documentation of security roles, permissions, configuration decisions, user guides, data standards, and administrative procedures.
• Identify recurring system or user issues and recommend appropriate training, configuration, security, or process improvements.

Data Management, Quality, and Governance

• Develop, maintain, and apply standards for constituent data entry, coding, maintenance, and use.
• Monitor data for incomplete, inconsistent, duplicate, outdated, or incorrectly coded information.
• Conduct data quality reviews and audits, document findings, and coordinate corrective action.
• Research and resolve complex constituent record issues involving relationships, biographical information, employment, education, contact information, codes, preferences, and other record elements.
• Review and resolve potential duplicate records in accordance with established standards and procedures.
• Help establish data governance practices related to data ownership, access, retention, confidentiality, security, quality, and documentation.
• Evaluate the impact of proposed data changes on reporting, integrations, business processes, and downstream systems.
• Develop quality-control procedures and validation methods for recurring data processes.
• Identify systemic data issues, determine root causes, and recommend sustainable solutions.
• Support data archiving, retention, and historical-data practices in coordination with appropriate stakeholders.

Data Imports, Integrations, and Processing

• Manage recurring and complex data imports into the Foundation's CRM and related systems, including review of source data, mappings, transformation requirements, matching criteria, and exception-handling procedures.
• Configure and maintain import profiles, templates, and related documentation.
• Validate import results to confirm that records, relationships, codes, dates, and other information were updated as intended.
• Investigate import exceptions and determine whether records should be corrected, matched, created, or escalated for further review.
• Coordinate with data owners and source-system stakeholders to resolve recurring data issues and improve the accuracy and efficiency of data processes.
• Support data exchanges and integrations between the CRM and fundraising, finance, communications, event, and institutional systems, including integration testing, data conversion, and migration activities.
• Create and maintain CRM queries, exports, and data extracts; translate business needs into appropriate selection criteria, fields, filters, and outputs; and validate results before distribution.
• Collaborate with reporting staff and technical partners on advanced reporting, data warehouse, SQL, and Power BI needs.
• Protect confidential and sensitive data by applying appropriate access, handling, and distribution practices.

Cross-Functional Collaboration and Special Projects

• Collaborate with Advancement Services, Institutional Advancement, Finance, and other MUSC partners on database and data-related initiatives.
• Serve as a technical liaison with CRM vendors and other system providers on database configuration, functionality, and issue resolution.
• Participate in CRM implementation and associated projects, conversion, testing, integration, optimization, and system-enhancement projects.
• Assess the data and operational impact of proposed system or process changes and communicate issues, risks, and recommendations to appropriate stakeholders.
• Support special projects involving database cleanup, restructuring, migrations, security, process improvement, and system enhancements.