University of Missouri-Saint Louis · 5 hours ago
Programmer Analyst
St Louis, MO
Full-time
Hybrid
Entry, Mid, Senior Level
$53K/yr - $80K/yrThe University of Missouri-Saint Louis is seeking a Programmer Analyst to enhance their CRM system and support the Division of University Advancement. The role focuses on ensuring data integrity, managing system integrations, and providing reports and analytics to support operational and strategic needs.
EducationHigher EducationUniversities
No H1B
Responsibilities
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
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
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
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
Qualification
Required
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
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
Applicants must be authorized to work in the United States. The University will not sponsor applicants for this position for employment visas
Preferred
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
Benefits
Medical, dental and vision plans
Retirement
Paid time off
Short- and long-term disability
Paid parental leave
Paid caregiver leave
Educational fee discounts for all four UM System campuses
Company
University of Missouri-Saint Louis
With over 15,000 students, the University of Missouri–St. Louis is the largest public research university in eastern Missouri.
Founded in 1963
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
$7.1MKey Investors
U.S. Department of EducationJames S. McDonnell Foundation
2023-11-13Grant· $3.1M
2022-12-19Grant· $4M
Leadership Team
Aisha Khorana
Partnership for Antiracist Counselor Training (PACT) Project Manager: Graduate Research Assistant
Ann Taylor
Associate Dean for School and Community Partnerships
Recent News
Seattle TechFlash
2025-09-12
2025-04-15
Company data provided by crunchbase