Systems Programmer Analyst; Business Intelligence & Data Analyst

Advancement Services

The Advancement Systems Programmer Analyst (Entry, Intermediate,Expert, Principal, or Master level) serves as a technical subject matter expert supporting the Division of University Advancement'sconstituent relationship management (CRM) system and related third-party applications. This position is responsible for maintaining system integrity, managing data integrations,developing reports and analytics, and implementing technology solutions that support advancement operations and strategic initiatives. The role collaborates with Advancement staff,Information Technology, and external partners to optimize business processes, ensure data accuracy, and enhance system functionality.

Through technical expertise in CRM administration, reporting, anddata management, the position supports fundraising, constituentengagement, and university campaign objectives.

• Maintains CRM system integrity through regular audits,monitoring, configuration management, and ongoing system maintenance.
• Troubleshoots and resolves CRM-related technical issues,providing direct support and guidance to end users.
• Develops, maintains, and documents CRM workflows, automations,customizations, and system configurations.
• Implements new CRM features, enhancements, and process improvements to increase system functionality and efficiency.
• Proactively monitors system performance, identifies issues, and implements solutions to reduce downtime and improve reliability.

• Develops, maintains, and enhances reports, dashboards, anddata visualizations using SQL, Power BI, CRM Advance, and related tools.
• Manages integrations between the CRM and third-party systems toensure accurate and efficient data exchange.
• Performs data maintenance, validation, cleansing, and monitoring activities to support data integrity and operational effectiveness.
• Creates and supports self-service reporting solutions that enableusers to access routine operational and strategic information.
• Produces ad hoc reports and analyses to support decision-making,performance measurement, and organizational planning.

• Serves as project lead for system enhancement and data integration initiatives, ensuring projects are completed onschedule and meet business requirements.
• Collaborates with Advancement staff, campus partners, and stakeholders to identify opportunities for technology-driven process improvements.
• Identifies improvements and develop solutions to support organizational priorities
• Provides technical expertise and recommendations regarding CRMfunctionality, reporting strategies, and business process optimization.
• Develops annual goals, key performance metrics, and business plans aligned with divisional priorities and strategic initiatives.

• CRM Administration and Configuration
• Database Management and Data Integration
• Reporting, Analytics, and Data Visualization
• SQL and Business Intelligence Tools
• Technical Problem Solving and Troubleshooting
• Process Improvement and Automation

Work is primarily performed in a professional office environment with extensive computer usage and frequent interaction with Advancement staff, university stakeholders, and technology partners. The role requires prolonged periods of sitting, reviewing technical information, developing reports, and analyzing data.

Responsibilities involve managing multiple projects and priorities while maintaining a high level of accuracy, attention to detail,and responsiveness to operational needs. The position requiressustained analytical thinking, technical problem-solving,…