Database Programmer Analyst - Expert

ITS Operations

The CRM and Data Analytics Expert is embedded in the Division of Advancement and part of the Advancement Services team. They will take direction from the AVC Advancement Services for day-to-day operations. This position serves as the subject matter expert for managing and enhancing the CRM system used by University Advancement. The role focuses on ensuring data integrity, managing system integrations, implementing new features, and providing detailed reports and analytics to support operational needs. This position requires deep technical expertise in CRM management, data integration, and reporting, as well as the ability to collaborate with internal teams to solve technical problems and optimize processes. The position is essential to advancing strategic operations, with a focus on accelerating business processes and supporting the campaign.

Key Responsibilities
CRM System Management

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

Data Integration & Maintenance

• 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.
• Ensure real-time updates between systems to support operational needs.

Reporting & Analytics

• 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.
• Maintain canned reporting systems for access to relevant data across platforms, whether in CRM or self-service reports in PowerBI.
• Learn and master Advancement terms and best practices to ensure the accuracy and relevance of all reporting.

Strategic Operations

• 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.
• Support efforts to increase philanthropic goals and constituent engagement by leveraging CRM tools and analytics.
• Oversee technical systems used by Advancement and develop reports and data visualizations for Advancement staff, College leadership, and volunteers.
• Act as a key partner in the strategic planning and effective operation of fundraising and engagement programs, ensuring that technology solutions align with the University's broader strategic objectives.
• Develops and submits Annual Business Plan, identifying key metrics and milestones necessary to achieve annual goals.

Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas.

M-F; 8am - 5pm

Education: Bachelor's degree in Computer Science, Information Systems, or a related field.

Experience:

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

Skills:

• 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.
• Ability to work independently and collaborate across teams.
  

Preferred Qualifications

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

Pay commensurate with education and experience.
Hiring Range: $58,573-$83,304 annual
Grade: GGS-011
University Title: DATABASE PROGRAMMER ANALYST - EXPERT

Application materials include a cover letter and resume. Finalists will be asked to provide references at a later date.

Applicants must combine all application materials into one PDF or Microsoft Word document and upload as a resume attachment to the UMSL Job site: http://umsl.jobs.

Limit document name to 50 characters. Maximum size limit is 11MB. Do not include special characters (e.g., /, &, %, etc.). For questions about the application process, please email employment@umsl.edu. If you are experiencing technical problems, please email umpshrsupport@umsystem.edu.

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/totalrewards/benefits.

Values Commitment

We value the uniqueness of every individual and strive to ensure each person's success. Contributions from individuals with diverse backgrounds, experiences and perspectives promote intellectual pluralism and enable us to achieve the excellence that we seek in learning, research and engagement. This commitment makes our university a better place to work, learn and innovate.

In your application materials, please discuss your experiences and expertise that support these values and enrich our missions of teaching, research, and engagement.

Equal Employment Opportunity

The University of Missouri System is an Equal Opportunity Employer. Equal Opportunity is and shall be provided for all employees and applicants for employment on the basis of their demonstrated ability and competence without unlawful discrimination on the basis of their race, color, national origin, ancestry, religion, sex, pregnancy, sexual orientation, gender identity, gender expression, age, disability, or protected veteran status, or any other status protected by applicable state or federal law. This policy applies to all employment decisions including, but not limited to, recruiting, hiring, training, promotions, pay practices, benefits, disciplinary actions and terminations. For more information, visit https://www.umsystem.edu/ums/hr/eeo or call the Director of Employee and Labor Relations at 573-882-2146.

To request ADA accommodations, please email the Office of Human Resources at umslhr@umsl.edu.