Share this Job
Job Req ID:  17635

Development Data Specialist

Working Title: Development Data Specialist 
Role/Level/Range: ATO 40/E/02/OE 
Employee group: Full Time 
Schedule: M-F, 8:30am-5:00pm 
Exempt Status: Non-Exempt  
Location: 04-MD:School of Medicine Campus 
Department name: 10003237-SOM Admin FJHM HIPAA Funding Compliance 
Personnel area: School of Medicine

 

General Description

 

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 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 the central Development and Alumni Relations (DAR) fundraising database (ALADIN) through direct querying and using the JasperSoft Business Intelligence reporting platform 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.

 

  • Prepares monthly, fiscal year, campaign and ad hoc fundraising progress and workplan report products for FJHM and its 31 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 (twice-yearly).

 

  • 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 maintain and update data sources associated with dashboards on the Tableau platform as well as inspects public dashboards to ensure they are operating optimally

 

  • Help plan and disseminate any pertinent data sets or visualizations for FJHM leadership, staff members, faculty, donors, and volunteers

 

Partner Hospital and Annual Giving Support

 

The incumbent accurately and efficiently retrieves data from Raiser’s Edge systems of the JHM Partner Hospital foundations as well assists the Sr. Data Analyst with facilitating collaborative, forward planning, and productive relationships.

 

  • Provide support to Partner foundation counterparts in retrieving data from ALADIN and Raiser’s Edge, 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

 

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 19 divisional development offices and 70+ front-line fundraisers.

 

  • Provide backup support for the daily inpatient VIP notification and guest roster report as needed. This report is produced daily by the Medical Development Services team and is published to the offices of the President of JHU, Dean & CEO of Medicine, President of JHH, Sr. VP of FJHM and Senior Management team, and other institutional leaders. Successful completion of this time-sensitive task requires comprehensive knowledge of Aladin and patient registration systems, strict attention to detail and confidentiality, and collaboration with the office of the Dean & CEO.

 

  • Work with the Office of Medical Annual Giving to process fundraising opt-outs submitted by medical constituents.

 

  • Assist the Medical Development Services team with data integrity projects on an ad hoc basis. This responsibility requires a focus on data quality and accuracy, and understanding of protected health information and privacy.

 

  • Coordinate DAR Service Desk tickets assigned to Medical Development Services and assist with data management and quality activities of MDSA and DAR

 

Qualifications

 

High School Diploma/GED required. Three years related experience required, preferably in business or operational analysis. BA/BS preferred. Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula. Candidate must be proficient in providing high level data analysis, administrative oversight, and coordination, and demonstrate a proficiency in queries and reports. Must have experience in data management and a working knowledge of fundraising information systems and development revenue cycle preferred.

 

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.                                                                        

 

Skills/Knowledge

 

  • 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

 

 

School of Medicine - East Baltimore Campus