Development Data Analyst, the Fund for Johns Hopkins Medicine

This position reports to the Sr. Data Analyst and is primarily responsible for preparation and maintenance of metrics and tools that quantify the operations of the Fund for Johns Hopkins Medicine (FJHM) including the four Johns Hopkins Health System hospital foundations. The Specialist utilizes an understanding of relational databases, database query tools, and data analysis techniques to report on all aspects of development operations, and enhance any aspect of development management. The Specialist will partner with FJHM administrators to identify opportunities to utilize bespoke technology-driven tools to optimize process efficiency. The Specialist directly supports the work of the Sr. Data Analyst in extracting, compiling, and formatting data from multiple sources, and preparing relevant analysis and visualizations.

Fundraising Reporting

The incumbent sources data from Development and Alumni Relations (DAR) databases through direct querying and connecting data to business intelligence platforms to support the successful execution of regular and ad hoc reporting to the FJHM leadership and development offices as well as help with the creation of meaningful analytics to assist FJHM decision makers to make data-driven decisions.

• Maintains, prepares, and updates monthly, fiscal year, campaign, and ad hoc fundraising progress and work plan report products for FJHM and its 21 distinct development offices including but not limited to the Workplan Snapshot (monthly), FY Run Rate (monthly), Anticipated Commitments reports (monthly), Development Office Historical Snapshot (twice-yearly), and 5 Year Giving Analysis (yearly) with feedback and final review by Sr. Data Analyst.
  
• Independently fulfills general requests for in-depth historical fundraising metrics
  
• Assist with the assessment of reporting requests and correspondingly help create regular and ad hoc reporting in order to proactively address reporting needs.

Analytics & Data Visualization

Provide support to the Assistant Director on a wide range of analytics and reporting projects, including data and relevant analytics and visualizations for meetings, projects, reports, and proposals.

• Routinely create, maintain, and update data sources associated with dashboards on the Tableau platform as well as inspects public dashboards to ensure they are operating optimally with final review and validation by Sr. Data Analyst.
• Help plan and disseminate any pertinent data sets or visualizations for FJHM leadership, staff members, faculty, donors, and volunteers
  

Administrative and Operations Support

The incumbent will work with development offices to identify administrative tasks for opportunities to maximize operational efficiency. Then use a variety of technologies to build out custom, sustainable solutions.

• Utilize Excel, Visual Basic, PowerQuery, PowerAutomate, SharePoint, and other technologies to build, maintain, and upgrade custom tools for Fund administrators.
• Perform Root Cause analysis and independently research administrative challenges and present solutions to the relevant parties.
  
• Introduce and familiarize DOFFs on using self-service reporting tools and systems like Tableau.

Medical Fundraising Data & Compliance Support

The incumbent provides support to all aspects of medical fundraising data quality and reporting, including:

• Administrate the scheduling and delivery of grateful patient report products to the 20 divisional development offices and 90+ front-line fundraisers.
  
• Work with the Office of Medical Annual Giving to process fundraising opt-outs submitted by medical constituents.
  
• Coordinate DAR Service Desk tickets assigned to Medical Development Services and assist with data management and quality activities of MDSA and DAR

Partner Hospital and Annual Giving Support

The incumbent assists the Sr. Data Analyst with facilitating collaborative, forward planning, and productive relationships.

• Provide support to Partner foundation counterparts in retrieving data DAR databases, producing reports and analysis, and assist with any projects related to Partner data.
• Assist in compiling data and metrics related to collaborative annual giving initiatives of the Partner foundation programs and FJHM Office of Medical Annual Giving
  
• Help facilitate the continual process of standardizing business rules between the partner hospital foundations and FJHM
  
• Assist with the planning, logistics, and execution of the quarterly FJHM/Partner Hospital Data Working group meetings

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

• Proficient in providing high-level data analysis, administrative oversight, and coordination.
• Demonstrate proficiency in queries and reports.
• Experience in data management and a working knowledge of fundraising information systems and development revenue cycle.
• Works well under pressure and meets deadlines
• Ability to synthesize, analyze, critique
• Excellent organizational skills
• Excellent oral and written communication skills
• Advanced analytical ability to identify data requirements and prepare and analyze complex reports
• Self-starter
• Demonstrated ability to address/resolve difficult multi-faceted problems
• Ability to define problems, collect data, establish facts, and draw valid conclusions
• Ability to develop and maintain sound professional relationships among superiors, subordinates and peers
• Ability to learn new software programs and databases

Classified Title: Data Analyst
Working Title: Development Data Analyst, the Fund for Johns Hopkins Medicine
Role/Level/Range: ATP/03/PB
Starting Salary Range: Min: $44,850 - Midpoint: $61,600 - Maximum: $78,360
Employee group: Full Time
Schedule: Monday-Friday 8:30 am - 5:00 pm
Exempt Status: Exempt
Location: School of Medicine - East Baltimore Campus
Department name: 10003237-SOM Admin FJHM HIPAA Funding Compliance
Personnel area: School of Medicine

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.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law
Learn more:
https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf

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 jhurecruitment@jhu.edu. 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. 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.

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 jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711.

The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.

During the Influenza ("the flu") season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.

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.

EEO is the Law
Learn more:
https://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf
Important legal information
http://hrnt.jhu.edu/legal.cfm