Analysis Skills, Auditing, Automation, Best Practices, Business Plan, Business Processes, CRM Integration, Campaigns, Channel Strategies, Communication Skills, Customer Relationship Management (CRM), Customer Relationship Management (CRM) Systems, Data Analysis, Data Cleaning, Data Management, Data Quality, Data Visualization, Database Administration, Database Analysis, Database Programming, Decision Support, Documentation, Financial Reporting, Fundraising, Fundraising Program, Identify Issues, Information/Data Security (InfoSec), Leadership, Metrics, Multiplatform/Cross-Platform, Operational Audit, Operational Improvement, Operational Strategy, Operational Support, Operations Processes, Power BI, Problem Solving Skills, Process Improvement, Process Validation, Project/Program Management, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), Strategic Planning, System Integration (SI), System Operations, Systems Administration/Management, Systems Analysis, Systems Maintenance, Systems/Internals Programming, Team Player, Time Management
Apply for Job
Job ID
60048
Location
St. Louis
Full/Part Time
Full-Time
Add to Favorite Jobs
Email this Job
Hiring Department
Advancement Services
Job Description
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.
Shift
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.
Anticipated Hiring 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
Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.
Application Materials
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.
Sponsorship Information
Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas.
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, 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 email the Office of Human Resources at umslhr@umsl.edu.