Advancement Systems Programmer Analyst - Expert

Advancement Services

This Advancement Systems Programmer Analyst - Expert position serves as a member of the Division of University Advancement. This position serves as a subject matter expert and 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.

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 or an equivalent combination of education and experience from which comparable knowledge and skills were acquired.

Experience

* 4+ years of work experience (beyond degree or equivalent)
* 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

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

Preferred Qualifications

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

$58,573-$83,304

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 Careers:
https://www.umsl.edu/services/hrs/careers/index.html

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.

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.

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.

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.