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
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.
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
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.
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
Internal Number: 17635-en_US
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.