Advancement Systems Programmer Analyst

University of Missouri-Saint Louis

St. Louis (MO)

On-site

USD 59,000 - 83,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

University of Missouri-St. Louis seeks an Advancement Systems Programmer Analyst (Entry to Master level) to support the CRM and related applications for the Division of University Advancement.

The role ensures data integrity, develops reports, and implements technology solutions aligned with fundraising, constituent engagement, and campaign objectives. The position collaborates with Advancement staff, IT, and external partners to optimize processes and system functionality, while delivering

Qualifications

Bachelor's degree or equivalent combination of education and experience.

Responsibilities

CRM Administration and System Support including audits, monitoring, configuration management, and maintenance.

Skills

CRM Administration

Data Integration

SQL

Power BI

Data Visualization

Project Management

Problem Solving

Communication

Ellucian CRM Advance

Data Security

Education

Bachelor's degree

Tools

Ellucian CRM Advance

SQL reporting tools

Job description

JOB SUMMARY

The Advancement Systems Programmer Analyst (Entry, Intermediate, Expert, Principal, or Master level) serves as a technical subject matter expert supporting the Division of University Advancement\'s constituent relationship management (CRM) system and related third-party applications. This position is responsible for maintaining system integrity, managing data integrations, developing reports and analytics, and implementing technology solutions that support advancement operations and strategic initiatives. The role collaborates with Advancement staff, Information Technology, and external partners to optimize business processes, ensure data accuracy, and enhance system functionality. Through technical expertise in CRM administration, reporting, and data management, the position supports fundraising, constituent engagement, and university campaign objectives.

Hiring Department

Advancement Services

Job Description

Primary Responsibilities

CRM Administration and System Support - 35%

Maintains CRM system integrity through regular audits, monitoring, configuration management, and ongoing system maintenance.
Troubleshoots and resolves CRM-related technical issues, providing direct support and guidance to end users.
Develops, maintains, and documents CRM workflows, automations, customizations, and system configurations.
Implements new CRM features, enhancements, and process improvements to increase system functionality and efficiency.
Proactively monitors system performance, identifies issues, and implements solutions to reduce downtime and improve reliability.

Data Integration, Reporting, and Analytics - 35%

Manages integrations between the CRM and third-party systems to ensure accurate and efficient data exchange.
Performs data maintenance, validation, cleansing, and monitoring activities to support data integrity and operational effectiveness.
Develops, maintains, and enhances reports, dashboards, and data visualizations using SQL, Power BI, CRM Advance, and related tools.
Creates and supports self-service reporting solutions that enable users to access routine operational and strategic information.
Produces ad hoc reports and analyses to support decision-making, performance measurement, and organizational planning.

Strategic Technology Solutions and Project Management - 30%

Serves as project lead for system enhancement and data integration initiatives, ensuring projects are completed on schedule and meet business requirements.
Collaborates with Advancement staff, campus partners, and stakeholders to identify opportunities for technology-driven process improvements.
Develops technology solutions that support fundraising, constituent engagement, and advancement operational objectives.
Provides technical expertise and recommendations regarding CRM functionality, reporting strategies, and business process optimization.
Develops annual goals, key performance metrics, and business plans aligned with divisional priorities and strategic initiatives.

CORE COMPETENCIES

CRM Administration and Configuration
Database Management and Data Integration
Reporting, Analytics, and Data Visualization
SQL and Business Intelligence Tools
Technical Problem Solving and Troubleshooting
Project Management and Implementation
Process Improvement and Automation
Stakeholder Collaboration and Customer Service
Strategic Thinking and Business Analysis
Written and Verbal Communication

Working Conditions & Physical Requirements

Work is primarily performed in a professional office environment with extensive computer usage and frequent interaction with Advancement staff, university stakeholders, and technology partners. The role requires prolonged periods of sitting, reviewing technical information, developing reports, and analyzing data. Responsibilities involve managing multiple projects and priorities while maintaining a high level of accuracy, attention to detail, and responsiveness to operational needs. The position requires sustained analytical thinking, technical problem-solving, and collaboration across functional areas.

Supervisory Responsibilities

This position does not typically have direct supervisory responsibility. May provide technical leadership, project coordination, training, and guidance to users and stakeholders regarding CRM systems, reporting tools, and related business processes.

Shift

M-F; 8am - 5pm

Minimum Qualifications

Bachelor\'s degree or equivalent combination of education and experience from which comparable knowledge and skills were acquired is necessary.

Experience

Preferred Qualifications

4+ years of work experience (beyond degree or equivalent)
3+ years of experience managing CRM systems.
Experience generating complex reports, dashboards, and handling ad hoc data requests.
Proven ability to troubleshoot technical issues and manage system integrations.
Documenting code and processes for validation and reproducibility

Skills

Advanced knowledge of CRM systems, data integrity practices, and database management.
Expertise in SQL and data visualization through reports and dashboards
Strong analytical, technical problem-solving, and communication skills.
Ability to work independently and collaborate across teams.
Experience configuring or reporting in Ellucian CRM Advance
Familiarity with fundraising, reporting, and data security standards as provided within CASE, AFP, Apra and AASP guidelines.
Experience with data integrations and process automation.
Experience building Power BI reports.

Anticipated Hiring Range

$58,573-$83,304

Sponsorship Information

Employment visa sponsorship is not available for this position.

Benefit Eligibility

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, 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/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer. To request ADA accommodations, please email the Office of Human Resources at umslhr@umsl.edu.

Get your free, confidential resume review.

or drag and drop your file here.