Sr. Business Intelligence Analyst, Medical Development Services & Analytics

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 Fund for Johns Hopkins Medicine (FJHM) is the dedicated development and alumni relations team supporting the entities that comprise Johns Hopkins Medicine (JHM), including clinical departments, hospitals, satellite clinics, and the School of Medicine. We contribute to Johns Hopkins Medicine’s mission of patient care, research, and education through securing philanthropy, building and maintaining donor and alumni relationships, and supporting institutional priorities. FJHM partners closely with institutional leaders, faculty, and clinicians to engage alumni, patients, donors, and prospects in JHM’s work to advance medicine and improve the human condition.

Medical Development Services and Analytics (MDSA) is a data analytics team within the Fund for Johns Hopkins Medicine (FJHM), which raises philanthropic funds to support the tri-partite mission of Johns Hopkins Medicine. The MDSA team is responsible for data delivery and analysis for FJHM leadership decision support and to propel the fundraising initiatives of the 22 clinical department and hospital-based development offices under FJHM.

Reporting to the Director, the Sr. Business Intelligence Analyst (the Sr. Analyst) serves as a subject matter expert on clinical encounter, patient and billing data sourced from the Epic system for fundraising purposes. This position has responsibility for the quality and accuracy of patient, guarantor, provider, and encounter data stored in the destination systems for fundraising use. Additional responsibilities include developing analytic products (dashboards, notebooks, visualizations) to enhance the effectiveness and business value of the data under their purview. This includes responsibility for developing and maintaining SQL queries and procedures comprising data sources for ingestion into JHAS, as well as sources for dashboards and reporting in Microsoft Power BI.

Key responsibilities: 

• Responsible for data analytics and additional support of performance measures, ongoing measurement, data collection, reporting, data visualizations and information dissemination.
• Responsible for implementing the strategic design and maintenance of business intelligence applications. Identifies, researches, and resolves technical problems.
• Ensures that the use of business intelligence applications enhances business decision making capabilities.
• Engages in data exploration exercises with a variety of complex business intelligence tools, requiring knowledge of relational database structures.
• Serve as a resource on complex technical and business matters.
• Provide a leadership role for the work group through knowledge in the area of specialization.
• Collaborates with other analytic teams and central engineering team as directed.
• Makes appropriate decisions, using available resources, to achieve positive outcomes for patients, visitors, staff, and students in balance with sound business practice.
• Makes recommendations for changes in the current departmental systems and processes and contributes ideas and suggestions for solutions to the current system’s problems.
• Responds to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action and information appropriate management.
• Communicates decisions to appropriate management.
• Prepares incident/occurrence reports as necessary.
• Prioritizes daily tasks and assignments appropriately.
• Completes mandatory Epic and/or other software or analytic tool training as required.
• Collaborates with other analytic teams as directed.
• Report and follow-up on software problems resulting in delay in workflow.

• Bachelor's degree.
• At least 4 years related experience, with at least 2 years' experience in data analytics.
• Additional education may substitute for experience, to the extent permitted by the JHU equivalenc