UMSL · 2 months ago
Programmer Analyst
St. Louis, MO
Full-time
Hybrid
Entry, Mid, Senior Level
$53K/yr - $80K/yrUMSL is a university seeking a Programmer Analyst to enhance their CRM system and third-party applications used by the Division of University Advancement. The role focuses on ensuring data integrity through system integrations, implementing new features, and providing detailed reports and analytics to support operational and strategic needs.
Civil EngineeringConstructionLogistics
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
Preferred
Expert, intermediate, or entry level knowledge of generating complex reports, dashboards, and handling ad hoc data requests
Expert, intermediate, or entry level knowledge of troubleshooting technical issues and managing system integrations
Expert, intermediate, or entry level knowledge of 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
Expert, intermediate, or entry level knowledge of 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
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
UMSL
USML is a construction company that specializes in the building of a range of infrastructures and offers material transportation services.
Founded in 1990
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase