Database Programmer Analyst - Expert

$58,573 - $83,304/Yr

Umsl Limited - Saint Louis, MO

Full-time - Mid Level

Saint Louis, MO

About the position

The CRM and Data Analytics Expert plays a crucial role within the Division of Advancement, focusing on managing and enhancing the CRM system utilized by University Advancement. This position is responsible for ensuring data integrity, managing system integrations, implementing new features, and providing detailed reports and analytics to support operational needs. The role requires deep technical expertise in CRM management, data integration, and reporting, along with collaboration with internal teams to optimize processes and support strategic operations.

Responsibilities

• Oversee the daily maintenance and operation of the CRM system, ensuring efficient performance.
• Maintain system integrity and perform regular audits in cooperation with the Data Management team.
• Troubleshoot CRM-related issues, resolving technical problems for end-users, and providing hands-on support.
• Document CRM workflows, customizations, and configurations for future reference.
• Manage the integration of the CRM with third-party systems, ensuring smooth and accurate data exchanges.
• Perform regular data cleaning and maintain data transfer processes for operational efficiency.
• Develop customized reports and dashboards using SQL, PowerBI, and other reporting tools.
• Provide ad hoc reports to support data-driven decision-making and operational improvements.
• Produce strategic, value-added technology solutions for end-users to address organizational challenges and enhance operational effectiveness.
• Collaborate with Advancement and campus colleagues to identify technological opportunities that support and guide decision-making through data-driven analytics.

Requirements

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 3-5 years of experience managing CRM systems, preferably in a higher education or non-profit environment.
• Strong knowledge of SQL, data integration, and CRM customization.
• Experience in generating complex reports, dashboards, and handling ad hoc data requests.
• Proven ability to troubleshoot technical issues and manage system integrations.
• Advanced knowledge of CRM systems, data integrity practices, and database management.
• Expertise in SQL, Power BI, and other data reporting tools.
• Strong analytical, technical problem-solving, and communication skills.

Nice-to-haves

• Experience with higher education CRM platforms such as Salesforce or Blackbaud CRM.
• Familiarity with fundraising, reporting, and data security standards as provided within CASE, AFP, Apra and AASP guidelines.
• Experience with data integrations and process automation.

Benefits

• Paid parental leave
• Caregiver leave
• Disability insurance
• Health insurance
• Dental insurance
• Paid time off
• Vision insurance