Data Analyst

Details

Posted: 10-Jan-24

Location: Baltimore, Maryland

Salary: Open

Categories:

Alumni Affairs
Staff/Administrative

Internal Number: 112363-en_US

Development and Alumni Relations (DAR) supports Johns Hopkins' focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine—strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients.

Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a hybrid work arrangement with an onsite presence of 3 days per week. The manager will confirm the team's core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days.

The Data Analyst at Johns Hopkins University reports to the Director of Data Analytics and Giving Technology in the Office of Annual Giving (OAG), and is a critical piece of data management and reporting for the central Office of Annual Giving team at Johns Hopkins.

The Data Analyst will exhibit excellent quantitative and analytical capabilities, strong understanding of new and emerging fundraising and quantitative modeling techniques and technologies, have a background in database and Customer Relationship Management (CRM) software and project management, and the ability to convert complex data into engaging, informative management reports.

The Office of Annual Giving is a growing team that currently consists of twenty-two 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 35 partners. These annual giving services include developing comprehensive and integrated direct response solicitation strategies that are optimal for each unit.

Reporting and Analysis (70%)

• Provide strategic analysis of revenue and donor acquisition to assist with the creation and/or use of solicitation data, annual giving predictive models, dashboards, and trend analysis for development units.
  
• Working closely with OAG colleagues, provide development units on: annual giving strategies focused on data-driven approaches, domestic and international regulations regarding mass solicitations, and giving day/reunion best practices.
  
• Calculate, track, and report data to benchmarking studies including the Voluntary Support of Education (VSE), Blackbaud Target Analytics Undergraduate Giving Benchmarking report, and USWNR. Create and maintain standard operating procedures for a two-team validation process, including the Office of Advancement Services (OAS), and an archiving system of benchmarking data.
  
• Create and update annual giving dashboards for development offices, providing details on revenue, donors, appeal response rate, ROI, and spatial trends.
  
• Using the institutions' donor database, JHAS, and other data software including but not limited to: SQL, SOQL, Tableau, Power BI, Python, and Excel, establish annual metrics, reports, and dashboards for the development units, including the Homewood Undergraduate Program.
  

Data and Processes Quality (15%)

• Participate in data quality improvement initiatives
  
• With the assistance of Senior Data Analyst, continuously work to optimize code and processes
  

Other (15%)

• Provide high-level project management for assigned unit data requests, ensuring reports are created and implemented in alignment of unit needs and goals.
  
• Create documentation to expand use of resources and ensure consistent and transparent policies and procedures across the OAG team.
  
• Other duties as assigned by the Director of Data Analytics and Giving Technology
  

Minimum Qualifications

• Bachelor's degree
• Three years of related experience
• Additional education may substitute for experience to the extent permitted by the JHU equivalency formula

Preferred Qualifications

• Master's degree preferred.
• Three years progressive experience in data analytics and data operations.
• Knowledge of SQL and/or SOQL.
• Comfortable working in a complex, multi-divisional, fast-moving, results-oriented environment.
• Strong interpersonal skills with an ability to influence and drive consensus.
• Demonstrated success in project management while overseeing multiple priorities.
• Ability to establish priorities, set objectives, and achieve goals.
• Ability to organize and interpret complex data sets and utilize analytic techniques and platforms.
• 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.
• Experience in using data visualization tools (i.e. Tableau, Power BI, or similar).
• Advanced knowledge of Excel, including experience with Power Query, VBA & Macros, Pivot Tables, and lookups

All applicants are expected to uphold the university's core values which includes diversity and inclusion. All staff treat people with dignity and respect by being fair and consistent. We demonstrate an open-minded approach to understanding people regardless of their race, gender, age, national origin, religion, ethnicity, disability status or other characteristics. We show respect for the beliefs and traditions of others; encourage and promote practices that support cultural diversity; and discourage behaviors or practices that may be perceived as unfair, biased, or critical toward people with certain backgrounds.

 

 

Classified Title: Data Analyst 
Job Posting Title (Working Title): Data Analyst   
Role/Level/Range: ATP/03/PB  
Starting Salary Range: Minimum: $45,700 - Maximum: $80,000 ($61,800 budgeted; commensurate with experience) 
Employee group: Full Time 
Schedule: Monday-Friday 8:30 am - 5:00 pm 
Exempt Status: Exempt 
Location: Mount Washington Campus 
Department name: 10001634-Annual Giving 
Personnel area: University Administration 

 

Total Rewards
The referenced salary range is based on Johns Hopkins University's good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/

 

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.
**Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.

The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

 

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion .

 

Accommodation Information

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 Talent Acquisition Office at [email protected] . For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit accessibility.jhu.edu .

 

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/ .

 

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.

 

Note: Job Postings are updated daily and remain online until filled.

 

 

Create a Job Alert for Similar Jobs
About Johns Hopkins University
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.
Show more
Show less
Connections working at Johns Hopkins University
More Jobs from This Employer
https://main.hercjobs.org/jobs/19614549/data-analyst
Return to Search Results