Senior Business Analyst

Department

Advancement and Alumni Relations

Info Technology Spec 2

Classified Staff

Part-Time

Part-time

Fairfax, VA

Hybrid Eligible

Not eligible for visa sponsorship

05

Salary commensurate with education and experience

Yes

The Office of Advancement and Alumni Relations division is a comprehensive development and alumni relations enterprise with a staff complement of approximately 135 FTE. Functional units within Advancement include development/fundraising, alumni relations, stewardship and donor relations, advancement communications, special events, gift processing, research, prospect management, gift planning, corporate and foundation relations, information systems and management, and infrastructure services. Advancement's mission is to build strong, lifelong relationships with George Mason University's alumni and constituents, while matching their philanthropic interests with the university aspirations and priorities.

The division is committed to serving the needs of the university, our alumni, and the greater community by providing access to quality education and lifelong learning. Respect, service, integrity, collaboration, diversity, transparency, and creativity are the values that guide our work and culture.

The Senior Business Analyst position is responsible for managing projects, which consists of: gathering requirements, aligning requirements with business processes, communicating with all levels of personnel, and establishing solutions that work for the stakeholders. This position is also heavily involved in reporting, using Micro Strategy, Salesforce reports, and SQL/SOQL to support business requirements. Finally, this position is responsible for Salesforce System Administration tasks, such as assisting with new application releases, building out sophisticated workflows, page layouts, validation rules, user management, and troubleshooting.

• Manage projects that support department goals, including coordination of stakeholders, building timelines, requirements gathering, user acceptance testing, and launching.
• Projects include working with all levels of personnel to determine needs and gather requirements. Development of process automations, complex data integration, researching and implementing new system tools, and building out extensive workflows in Salesforce.
• Collaborate with technical and non-technical personnel in all aspects of projects.
• Identify gaps in current workflows, research and recommend solutions.
• Develop solutions using available tools, or research/implement potential new tools.
• Stay abreast of systems in use, as well as new offerings that may aid in the efficiency of our operation, including Salesforce, Affinaquest, Digital Engagement platforms and Micro Strategy Reporting.
• Provide training and documentation on all projects and customizations.

• Design, enhance, and maintain Micro Strategy and Salesforce reports and dashboards to support fundraising, engagement, and operational functions across Advancement. This includes building schema objects, and application objects with minimal guidance.
• Conduct advanced data analysis and validation to support decision-making.
• Organize and collaborate with stakeholders, at all levels, to gather, document, and prioritize business requirements and reporting needs.
• Translate complex business requirements into functional and technical specifications and Business Intelligence solutions.
• Build schema objects (attributes, facts) and application objects (reports, metrics, filters, prompts) in collaboration with Director of Business Intelligence and Reporting.
• Provide analysis of data sources and validate report outputs for accuracy.
• Maintain data quality and perform sufficient unit and system testing of reports and dashboards.
• Identify any performance or efficiency issues and suggest appropriate enhancements.
• Stay current with Micro Strategy tools and best practices.
• Create and maintain clear documentation and change logs for reports and dashboards.

• Design and implement advanced solutions and automations to streamline processes and improve user efficiency, including building intricate workflows, custom objects/fields, and dashboards, in support of optimizing work within the CRM.
• Direct the management of Salesforce Cases.
• Troubleshoot and resolve high-level Salesforce and Affinaquest issues.
• Manage the Initium Clean Address application, work directly with vendor regarding issues and upgrades.
• Maintain the configuration for the application within Salesforce, and use the application for data being uploaded into the CRM. Training and User Enablement
  • Lead the design and delivery of comprehensive training programs for all new Advancement and Alumni Relations staff using Salesforce and Micro Strategy.
  • Develop advanced training…