Systems Programmer Analyst Job Saint Louis area,St. Louis Missouri USA,IT/Tech

Position: Advancement Systems Programmer Analyst
Location: St. Louis

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…