Business Intelligence Analyst, Office of Medical Annual Giving

Business Intelligence Analyst, Office of Medical Annual Giving

Join to apply for the Business Intelligence Analyst, Office of Medical Annual Giving role at The Johns Hopkins University.

The Business Intelligence Analyst is responsible for data analytics and additional support for performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination. They participate in strategic design and maintenance of BI applications, identify, research, and resolve technical problems, and ensure BI applications enhance clinical and/or business decision‑making. The Analyst works on limited to moderately complex projects and gains exposure to more complex tasks under supervision.

This role manages a complex, multi‑step process to analyze and prepare OMAG data for annual giving appeals, ensuring the highest data quality and supporting a $3–$4 million annual revenue campaign across multiple departments and partner hospitals.

• Data analytics and support for performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination.
• Participate in strategic design and maintenance of business intelligence applications.
• Identify, research, and resolve technical problems.
• Ensure BI applications enhance clinical and/or business decision‑making.
• Make appropriate decisions using available resources to achieve positive outcomes for patients, visitors, and staff in balance with sound business practice.
• Recommend changes in systems and processes and contribute ideas for solutions.
• Report and follow up on software problems delaying workflow.
• Respond to urgent, impromptu, and unplanned situations by assessing importance and instituting appropriate action.
• Communicate decisions to appropriate management.
• Prepare incident/occurrence reports as necessary.
• Prioritize daily tasks and assignments appropriately.
• Complete mandatory Epic and other software or analytic tool training as required.
• Collaborate with other analytic teams as directed.
• Other duties as assigned.

• Translate OMAG annual giving strategy into technical data specifications for multichannel appeals; build automated data extraction/manipulation processes using JHAS, SQL/SOQL, Tableau, Power BI, Python, and Excel to support 150+ solicitations.
• Develop and refine JHAS and Power BI reports and dashboards; collaborate on data‑driven pipeline strategies to strengthen donor acquisition, retention, and long‑term philanthropic growth.
• Monitor and improve data quality within EPIC and JHAS; partner with OAS and Med Dev to resolve issues and execute regular data‑cleanup initiatives.

• Bachelor’s degree in a related field.
• Three years of experience in a professional environment using the relevant knowledge base and skills, with a minimum of two years collecting and analyzing data, preparing reports, identifying and solving problems.
• Additional education may substitute for required experience and additional related experience may substitute for required education beyond a high‑school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula.

Classified

Title:

Business Intelligence Analyst II

Role/Level/Range: ATP/03/PC

Starting Salary Range:
Minimum $53,799 – Maximum $94,399 (targeted salary $68,000; commensurate with experience)

Employee group:
Full Time |

Schedule:

Monday‑Friday, 8:30 am‑5:00 pm | FLSA Status:
Exempt |

Location:

School of Medicine – East Baltimore Campus | Department name: ‑SOM Admin FJHM Friends of Medicine | Personnel area:
School of Medicine

Seniority level:
Mid‑Senior level |

Employment type:

Full‑time | Job function:
Research, Analyst, and Information Technology | Industries:
Higher Education