Harvard University Business Analyst, Development in Cambridge, Massachusetts
52546BRAuto req ID:52546BRJob Code:I0857P IT Business Analysis Prfss III Location:USA - MA - Cambridge Business Title:Business Analyst, Development Data StrategySub-Unit:------------ Salary Grade:057Time Status:Full-time Union:00 - Non Union, Exempt or Temporary Additional Qualifications and Skills:
Bachelor's degree or equivalent experience required.
Minimum 5 years' experience in fundraising administration environment preferred.
Experience with relational databases required.
Experience with SQL (Structured Query Language), QSL (Qlik Selection Language) or comparable query languages for relational databases management systems required.
Minimum two years' additional post-secondary education and/or relevant work experience
Knowledge of information technology applications, processes, software and equipment
Demonstrated team performance skills, service mindset approach, and the ability to act as a trusted advisor
Experience with BSR Advance preferred. Strong MS Office skills: Word, Excel, Access.
Experience with QlikView and/or QlikSense preferred.
Must be highly organized, detail-oriented and efficient.
Ability to take initiative, create, and manage projects required.
Experience designing user interfaces for Business Intelligence reporting platforms to meet high-level specifications and end-user business requirements a plus.
Must have strong written and verbal communication skills with experience writing functional requirements and an appreciation for structured development techniques in conjunction with software release management processes. Public speaking and presentation skills preferred.
NOTE: In order to be considered for this position, a cover letter in addition to a resume is required. We regret that Harvard cannot provide Visa sponsorship for staff positions and candidates must have eligibility to work in the US now and in the future.
Additional Information:In order to be considered for this position, a cover letter in addition to a resume is required. We regret that Harvard cannot provide Visa sponsorship for staff positions and candidates must have eligibility to work in the US now and in the future.Department:Development and Alumni RelationsPre-Employment Screening:Identity Job Function:Alumni Affairs and Development, General Administration, Information TechnologySchool/Unit:Harvard Graduate School of Design EEO Statement:We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.Job Summary:Independently analyze, identify, develop and communicate technical solutions. Devise and/or modify procedures to solve complex technical problems.Typical Core Duties:
Work at a high level within a team on most phases of service analysis and consider the business implications of technology applications to the current and future business environment
Collaborate with stakeholders to translate business needs into systems requirements and scoping
Contribute to the definition of systems requirements, conduct gap analysis, and identify feasible alternative solutions that meet defined business objectives
Perform user needs analysis, product evaluation, selection, customization, testing, implementation, and support
Participate in the development of plans and policies for a unit/school
Abide by and follow the Harvard University IT technical standards, policies and Code of Conduct
- Minimum of two years' post-secondary education and/or relevant work experience
Certificates and Licenses:
- Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred
- Position involves frequent use of computer keyboard and mouse
- Temporary remote work environment through December 31, 2020 with the possibility of continued remote work.
Reporting to the Director of Operations & Administration, the Business Analyst is responsible for fulfilling a range of business intelligence needs for the GSD’s development and alumni relations department. Identifies and completes projects designed to identify new leadership, major, and planned gift and prospects, re-evaluate known prospects, and helps to build the pipeline of potential donors, working alone or in collaboration with teammates. Provides continuous assessment of departmental business processes and designs improvements to maximize efficiency and efficacy in order to meet strategic and operational needs. Provides end-user support for development data systems. Prepares prospect strategy recommendations using data analysis. Works closely with fundraisers regarding gift procedures, donor gift inquiries, and to support analytics and metrics needs across the department. Manages all departmental reporting.
TYPICAL DUTIES AND RESPONSIBILITIES:
Development Data Strategy
Analyze accumulated data to assess individual capacity and make direct connections between School priorities and prospects’ giving interests based on available data.
Identify, design, document, and execute annual projects that will identify potential new leadership, major, and planned gift donors for the School.
Interpret development data and produce assets to help the Director of Operations and Administration to develop appropriate cultivation, solicitation, and stewardship strategies.
Coordinate the presentation of newly identified prospects to fundraisers.
Provide recommendations to development officers on newly identified prospects, especially at the major gift-level.
Manage the regular reporting cycle to help inform the team of progress towards goals.
Fulfill ad hoc complex data queries to meet frontline and leadership team needs.
Conducts research projects to substantiate prospect cultivation and solicitation strategies as assigned by the Director.
Business Intelligence & Data Management
Manage regular staff meetings to coordinate the capture, maintenance, and interpretation of development data.
Develop reports, software tools, and business process improvements to meet the needs of the DevAR team as related to fundraising, volunteer management, and alumni relations.
Leads interdepartmental efforts to capture, aggregate, and share GSD data school-wide to advance development and alumni relations goals.
Ensure compliance with Harvard Alumni Affairs and Development’s Advancement Technology Support Services and Business Intelligence departments’ policies and data requirements as the GSD’s designated Local Product Manager (LPM) for development data systems.
Oversee access to and use of the development information systems, including all aspects of data maintenance, staff training, security and integrity audits, and record-keeping.
Serve as GSD representative to schools and units University-wide regarding alumni and donor data.
Serve as Local Product Manager for Ellucian Advance and QlikView systems.
Participate in university-wide data management workgroups; ensure GSD’s interests are represented in the development of university-wide data management policies and that the DevAR team is equipped and trained on current hardware and software technologies necessary for all business operations of the office.
Train new and current staff, proactively when necessary and at their request, on the effective use of data management tools to meet business needs.
Assists the Director in the active management of the prospect management system and creation of prospect management policies and procedures as well as the training and management of staff responsible for data entry of all fundraising activity