Database Management Associate - MUSC Foundation

• Administer user accounts, security roles, permissions, and access levels within the Customer Relations Management (CRM) system  and related systems.

• Review and fulfill access requests based on job responsibilities, established security standards, and approved authorization, and 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; evaluate requests for new or modified values to support consistent data entry and reporting.

• 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.

• 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.

• 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.

• 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.

Bachelor's degree or equivalent education and/or relevant work experience and 3-5 years of related professional experience, or an equivalent combination of education and relevant experience.

• 3-5 years of experience working with databases, CRM systems, data management, reporting, or a related field.
• Experience administering user accounts, security roles, permissions, or system access.
• Proficiency in Microsoft Excel, including data manipulation, filtering, and basic analysis.
• Experience working with data imports, exports, record maintenance, or data validation processes.
• Experience maintaining database tables, code values, configuration settings, or similar system structures.
• Knowledge of fundraising operations, gift processing, and constituent data management.
• Strong attention to detail and ability to identify inconsistencies and errors in data.
• Strong organizational, analytical, problem-solving, and documentation skills.
• Ability to manage multiple priorities and work collaboratively across teams.
• Ability to collaborate effectively with technical and nontechnical stakeholders.
• Experience with Salesforce, Raiser’s Edge NXT, Blackbaud CRM,  or similar CRM platform.
• Experience creating database queries, reports, and constituent data exports.
• Experience in healthcare, higher education, or nonprofit fundraising environments.
• Familiarity with institutional data security, privacy, and confidentiality standards.
• Familiarity with relational database concepts and basic SQL.
• Familiarity with Power BI or another reporting and visualization platform.

If you like working with energetic enthusiastic individuals, you will enjoy your career with us!

The Medical University of South Carolina is an Equal Opportunity Employer. MUSC does not discriminate on the basis of race, color, religion or belief, age, sex, national origin, gender identity, sexual orientation, disability, protected veteran status, family or parental status, or any other status protected by state laws and/or federal regulations. All qualified applicants are encouraged to apply and will receive consideration for employment based upon applicable qualifications, merit and business need.

Medical University of South Carolina participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: http://www.uscis.gov/e-verify/employees