Advancement Systems Programmer Analyst

Hiring Department Advancement Services Location St. Louis Job Description This Advancement Systems Programmer Analyst (Entry, Intermediate or Expert level) position serves as a member of the Division of University Advancement. This position serves as a subject matter expert by enhancing the CRM system and third‑party applications used by Advancement. The role focuses on ensuring data integrity by managing system integrations, implementing new CRM and third‑party application features, and providing detailed reports and analytics to support operational and strategic needs. This position requires deep technical expertise in report and dashboard creation, data integration, and CRM management, 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 university campaign. Key Responsibilities CRM System Maintenance 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. Ensure daily maintenance and operation of the CRM system is properly configured with necessary automations. Proactively resolve update and run errors to reduce system down time. 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. Serve as project manager for data and system integration projects delivering desired business outcomes on schedule. Reporting & Analytics Develop customized reports and dashboards using SQL, Power BI, and CRM Advance. Develop comprehensive self‑service reporting suite for end‑users, to pull reports directly necessary for daily, weekly, and routine operational tasks. 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 Advance or self‑service reports in Power BI. 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. Work Hours M-F; 8am - 5pm Minimum Qualifications A Bachelor's degree or an equivalent combination of education and experience from which comparable knowledge and skills can be acquired is necessary. Preferred Qualifications Experience 4+ years of work experience 3+ years of experience managing CRM systems. Experience in 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 Entry, intermediate, or expert level knowledge of: CRM systems, data integrity practices, and database management. 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. Salary Range This position will be hired at one of the following levels based on experience: Entry (Job Code 4854) $53,976 - $69,576 Specialist (Job Code 4855) $53,976 - $76,024 Expert (Job Code 4856) $60,944 - $86,632 Grade: GGS-09E University Title: DATABASE PROGRAMMER ANALYST - ENTRY Grade: GGS-010 University Title: DATABASE PROGRAMMER ANALYST - SPECIALIST Grade: GGS-011 University Title: DATABASE PROGRAMMER ANALYST - EXPERT Equal Employment Opportunity The University of Missouri is an Equal Opportunity Employer. To request ADA accommodations, please email the Office of Human Resources at View email address on click.appcast.io. #J-18808-Ljbffr University of Missouri-Saint Louis