Senior Business Analyst

Department: Advancement and Alumni Relations

Classification: Info Technology Spec 2

Job Category: Classified Staff

Job Type: Part-Time

Work Schedule: Part-time

Location: Fairfax, VA

Workplace Type: Hybrid Eligible

Sponsorship Eligibility: Not eligible for visa sponsorship

Pay Band: 05

Salary: Salary commensurate with education and experience

Criminal Background Check: Yes

About the Department:

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.

About the Position:

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 MicroStrategy, 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.

Responsibilities:

Strategic Planning/Process Improvement

• 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. I.e.:  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 MicroStrategy Reporting; and
• Provide training and documentation on all projects and customizations. 

Reporting & Analytics

• Design, enhance, and maintain MicroStrategy 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 MicroStrategy tools and best practices; and
• Create and main