Programmer Analyst

Job

Location:

St. Louis

Full/Part Time:
Full-Time

Division:
University Advancement

Position Type:
Full-Time, On-site or Hybrid preferred, Remote optional

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.

• Entry (Job Code 4854) $53,000 - $68,000 salary range
• Specialist (Job Code 4855) $53,000 - $72,000 salary range
• Expert (Job Code 4856) $60,000 - $80,000 salary range

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

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

40 hours, Monday thru Friday

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

Experience:

• 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:

• 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…