Programmer Analyst

This Programmer Analyst position serves as a member of the Division of University Advancement. This position serves as a subject matter expert whereby 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., CRM System Maintenance

• Maintain system integrity and perform regular audits in cooperation with the Data Management team.
• Ensure that the CRM system is properly configured and perform maintenance to enhance system reliability.
• Troubleshoot CRM-related issues, resolving technical problems for end-users, and providing hands-on support.
• Document CRM workflows, customizations, and configurations for future reference.

Data Integration & Maintenance

• Help manage the integration of the CRM with third-party systems, ensuring efficient and accurate data exchanges on schedule.
• Perform data quality checks and data cleansing activities as part of the data integration process.
• Utilize native CRM import tool to load and update records from flat files.
• Participate in regular data audits and cleanup efforts to ensure accuracy and reliability of data within the CRM and reporting tools.
• Document data integration processes and procedures for future reference and maintenance.

Reporting & Analytics

• Develop customized reports and dashboards using SQL, Power BI, and CRM Advance.
• Develop a 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.
• 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.

Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas. Shift

40 hours, Monday thru Friday, 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.

A bachelor's degree or an equivalent combination of education and experience from which comparable knowledge and skills can be acquired is necessary., Expert, intermediate, or entry level knowledge of

• Generating complex reports, dashboards, and handling ad hoc data requests.
• Troubleshooting technical issues and managing system integrations.
• Documenting code and processes for validation and reproducibility.

Skills: Expert, intermediate, or entry level knowledge of

• CRM systems, data integrity and cleanup practices, and database management.
• SQL development and data visualization through reports and dashboards.
• Analytical, technical problem-solving, troubleshooting, and communication skills.
• Ability to work independently and collaborate across teams.
• Ability to understand the needs of business colleagues and translate their needs into effective technical solutions.

Preferred Qualifications

• Experience in Higher Ed Advancement or Non-profit fundraising.
• 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 integration and process automation.
• Experience building Power BI reports.
• SQL, SQL Server Management Studio (SSMS), Power Automate, Microsoft Dynamics 365.