The Business Analyst in the Office of Annual Giving (OAG) at Johns Hopkins University reports to the Director of Strategic and Divisional Priorities.
This is an opportunity to apply analytical and creative skills to the Office of Annual Giving (OAG) towards the goal of increasing annual giving dollars, donors, and pipeline across Johns Hopkins University & Medicine. The role is charged with using data and statistical analysis to unpack, better understand, and advance different facets of the Johns Hopkins annual giving ecosystem, including but not limited to: direct response, The Hopkins Fund, leadership annual giving, pipeline, and stewardship. The role is expected to leverage data mining, analysis, interpretation, and visualization using statistical and technical platforms like Python, R, and Tableau towards the goal of improving OAG efficiencies and the efficacy of annual giving strategies and tactics.
The Office of Annual Giving is a growing team that currently consists of fourteen colleagues who provide annual giving services to the nine schools of the university, various departments of Johns Hopkins Medicine, and several centers and institutes, totaling over 25 partners. These annual giving services include developing comprehensive and integrated solicitation strategies that are optimal for each development unit and are data-driven. Like all offices and units in Development and Alumni Relations (DAR), OAG is committed to a donor-directed philanthropy philosophy.
Some of the initial tasks and questions that this new role will focus on include:
Use descriptive and inferential statistics to analyze program results and donor behavior—do these data points vary by school? How do factors like gender, class year, geography, school/division, past giving history, whether a donor has met with a gift officer, impact an alumnus's likelihood to give?
An analysis of giving behaviors to unit-based vs. centrally-based fund designations. Who gave to these funds? Are they still giving to these funds? If not, did they move their giving to another part of Hopkins or stopped giving altogether?
Analyze OAG's direct mail program to identify efficiencies and deficiencies in terms of ROI. Are their mailing segments that we should be discontinuing? Are their meaningfully ROI variances between the schools and units? If so, why. How do we maximize our ROI?
The effect of stewardship efforts on lybunts, sybunts, and long-lapsed donors. Are there discernable insights between schools and demographics?
Specific duties & responsibilities:
OAG is positioned and is expected to understand the giving behaviors for the base of support for approx. 25 school and units. This position is responsible for providing and at time finding useful data and analysis about the giving behaviors of Hopkins alumni and other donor populations in order for OAG to devise better strategy and tactics that yield stronger annual giving results.
Using statistical analysis, provide recommendations to maximize revenue for the flagship undergraduate annual fund, The Hopkins Fund, while optimizing donor count.
Boost direct response results through the creation and updating of annual giving dashboards for various internal development offices, providing details on revenue, donors, appeal response rate, ROI, and spatial trends. Train development office staff on how to use the dashboards, gaining feedback on improvements.
Track, assess, and make data-driven recommendation around the institutional-wide phonathon program as OAG contemplates the risks and opportunities of its calling program.
Provide data visualizations and data explanations to senior leadership and department leaders about opportunities to optimize fundraising efforts around dollars and donors.
Analyze data to monitor emerging pipeline initiative towards goal of identifying leadership annual giving prospects, as well as new major gift prospects.
Assess current data and workflow processes and make recommendations to design, redesign, and implement improvements to those business processes.
Examine current state and develop recommendations to create efficiencies around the pulling, formatting, and storing of direct response solicitation data.
In consultation with OAG and DAR leadership, develop an analytics roadmap that set near- and mid-term strategies for enhancing results analysis and reporting.
Helping to design A/B testing opportunities and then developing the dashboards and data visualizations that track and monitor the test results towards the goal of provide insights into effective annual giving strategies and tactics.
Other duties as assigned.
Bachelor's degree required.
Five years experience in data analytics and data operations.
Master's degree preferred
Extensive experience with Tableau.
Knowledge with R, Stata, or Python to extract, transform and format data and to create variables for use in analysis
Knowledge of SQL and Power BI.
Advanced knowledge of Excel, including experience with Power Query, Advanced Charting, VBA & Macros, Pivot Tables & Reporting, Simulations, and more.
Experience with an analytics tool such as Salesforce Einstein or Qlik Sense.
Ability to organize and interpret complex data sets and utilize analytic techniques and platforms.
Comfortable working in a complex, multi-divisional, fast-moving, results-oriented environment.
Demonstrated success in project management while overseeing multiple priorities.
Ability to identify multi-variables needed to optimize engagement and predictive indices.
Strong written and verbal communication skills, including presentation capabilities. Experience presetting data to leadership team for decision-making purposes. Strong desire to succeed and excellent work ethic.
Classified Title: Business Analyst Working Title: Annual Giving Business Analyst Role/Level/Range: ATP/04/PD Starting Salary Range: Employee group: Full Time Schedule: M-F 8:30 am - 5:00 pm Exempt Status: Exempt Location: 01-MD:Homewood Campus Department name: 10001634-Annual Giving Personnel area: University Administration
The successful candidate(s) for this position will be subject to a pre-employment background check.
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the HR Business Services Office at [email protected]. For TTY users, call via Maryland Relay or dial 711.
The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Equal Opportunity Employer Note: Job Postings are updated daily and remain online until filled.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.