Advancement Systems Programmer Analyst (Business Intelligence & Data Analyst)

University of Missouri, St. Louis; Clayton (MO); On-site; USD 59,000 - 83,000; Full time

Benefits offered by this job

Benefits package including medical, Rx

Educational fee discounts

Retirement options

Job summary

The University of Missouri, St. Louis is seeking an Advancement Systems Programmer Analyst to support the CRM system and related applications. You will maintain data integrity, manage integrations, and develop reports and analytics to support fundraising and campaigns.

The role collaborates with Advancement staff, IT, and external partners to optimize processes and implement technology solutions that enhance system functionality.

Qualifications

• Bachelor's degree or equivalent combination of education and experience.
• 4+ years of work experience in related roles.
• 3+ years managing CRM systems.
• Experience generating complex reports and dashboards.
• Ability to troubleshoot technical issues and manage integrations.

Responsibilities

• CRM Administration and System Support with audits, configuration, and maintenance.
• Develops and documents CRM workflows, automations, and configurations.
• Data integration, reporting, and analytics using SQL and BI tools.
• Lead projects for system enhancement and data integration initiatives.
• Collaborate with staff, campus partners, and external vendors on tech solutions.

Skills

CRM Administration

Data Integration

SQL

Power BI

Data Visualization

Analytical Thinking

Troubleshooting

Communication

Independent Work

Education

Bachelor's degree or equivalent

Tools

Ellucian CRM Advance

Power BI

Job description

Hiring Department

Advancement Services

Job Description

The Advancement Systems Programmer Analyst (Entry, Intermediate,Expert, Principal, or Master level) serves as a technical subjectmatter expert supporting the Division of University Advancement'sconstituent relationship management (CRM) system and relatedthird-party applications. This position is responsible formaintaining system integrity, managing data integrations,developing reports and analytics, and implementing technologysolutions that support advancement operations and strategicinitiatives. The role collaborates with Advancement staff,Information Technology, and external partners to optimize businessprocesses, ensure data accuracy, and enhance system functionality.Through technical expertise in CRM administration, reporting, anddata management, the position supports fundraising, constituentengagement, and university campaign objectives.

PRIMARY RESPONSIBILITIES

CRM Administration and System Support – 35%

• Maintains CRM system integrity through regular audits,monitoring, configuration management, and ongoing systemmaintenance.
• 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 processimprovements to increase system functionality and efficiency.
• Proactively monitors system performance, identifies issues, andimplements solutions to reduce downtime and improvereliability.

Data Integration, Reporting, and Analytics – 55%

• Develops, maintains, and enhances reports, dashboards, anddata visualizations using SQL, Power BI, CRM Advance, and relatedtools.
• Manages integrations between the CRM and third-party systems toensure accurate and efficient data exchange.
• Performs data maintenance, validation, cleansing, and monitoringactivities to support data integrity and operationaleffectiveness.
• Creates and supports self-service reporting solutions that enableusers to access routine operational and strategicinformation.
• Produces ad hoc reports and analyses to support decision-making,performance measurement, and organizational planning.

Strategic Technology Solutions and Project Management –10%

• Serves as project lead for system enhancement and dataintegration initiatives, ensuring projects are completed onschedule and meet business requirements.
• Collaborates with Advancement staff, campus partners, andstakeholders to identify opportunities for technology-drivenprocess improvements.
• Identifies improvements and develop solutions to supportorganizational priorities
• Provides technical expertise and recommendations regarding CRMfunctionality, reporting strategies, and business processoptimization.
• Develops annual goals, key performance metrics, and businessplans aligned with divisional priorities and strategicinitiatives.

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
• Process Improvement and Automation

WORKING CONDITIONS & PHYSICAL REQUIREMENTS

Work is primarily performed in a professional office environmentwith extensive computer usage and frequent interaction withAdvancement staff, university stakeholders, and technologypartners. The role requires prolonged periods of sitting, reviewingtechnical information, developing reports, and analyzing data.Responsibilities involve managing multiple projects and prioritieswhile maintaining a high level of accuracy, attention to detail,and responsiveness to operational needs. The position requiressustained analytical thinking, technical problem-solving, andcollaboration across functional areas.

SUPERVISORY RESPONSIBILITIES

This position does not typically have direct supervisoryresponsibility. May provide technical leadership, projectcoordination, training, and guidance to users and stakeholdersregarding CRM systems, reporting tools, and related businessprocesses.

Shift

M-F; 8am – 5pm

Minimum Qualifications

Bachelor's degree or equivalent combination of education andexperience from which comparable knowledge and skills were acquiredis necessary.

Preferred Qualifications

Experience

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

Skills

• Advanced knowledge of CRM systems, data integrity practices, anddatabase management.
• Expertise in SQL and data visualization through reports anddashboards
• Strong analytical, technical problem-solving, and communicationskills.
• Ability to work independently and collaborate across teams.
• Experience configuring or reporting in Ellucian CRM Advance
• Familiarity with fundraising, reporting, and data securitystandards as provided within CASE, AFP, Apra and AASPguidelines.
• 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 thisposition.

Benefit Eligibility

This position is eligible for University benefits. As part of yourtotal compensation, the University offers a comprehensive benefitspackage, including medical, dental and vision plans, retirement,and educational fee discounts for all four UM System campuses. Foradditional information on University benefits, please visit theFaculty & 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 HumanResources at [e-mail].