Reports to: Assistant Director of Medical Development Services & Analytics
This position reports to the Assistant Director of Medical Development Services and Analytics (MDSA) and is primarily responsible for preparation and maintenance of metrics and tools that quantify the operations of the Fund for Johns Hopkins Medicine (FJHM). 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 Assistant director in extracting, compiling, and formatting data from multiple sources, and preparing relevant analysis and visualizations.
70%FJHM Reporting Administration
Accurately and efficiently retrieve data from the central Development and Alumni Relations (DAR) fundraising database (ALADIN) through direct querying and using the JasperSoft Business Intelligence reporting platform.
Prepare monthly, fiscal year, campaign and ad hoc fundraising progress and workplan report products for FJHM and its 31 distinct development offices.
Maintain data sources associated with analytics dashboards on the Tableau platform.
Help plan and disseminate any pertinent data sets or visualizations for FJHM leadership, staff members, faculty, donors, and volunteers
Provide support to the Assistant Director on a wide range of analytics and reporting projects, including data and relevant analytics for meetings, projects, reports, and proposals.
15% Partner Hospital and Annual Giving Support
Accurately and efficiently retrieve data from Raiser's Edge systems of the JHM Partner Hospital foundations.
Provide support to Partner foundation counterparts in 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.
Assist with the planning, logistics, and execution of the FJHM/Partner Hospital Data Working group meetings.
15% Medical Development Services Support
Coordinate DAR Service Desk tickets assigned to MDSA and assist with data management and quality activities of MDSA and DAR
Administrate the scheduling and delivery of grateful patient report products
Serve as a backup for the daily inpatient guest roster reporting process
Other duties as assigned
High School Diploma/GED required, BA/BS preferred. Three years related experience required. Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula.
Successful candidate will have 3 years' experience, or a combination of education and experience, in business or operational analysis. Candidate should be proficient in providing high-level data analysis, administrative oversight, and coordination, and demonstrate a proficiency in queries and reports. Preferred candidate will 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.
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
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
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 firstname.lastname@example.org. 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.
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.