"Alerted.org

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. Responsible for participating in the strategic design and maintenance of business intelligence applications. The Business Intelligence Analyst will identify, research, and resolve technical problems. The Business Intelligence Analyst will ensure that the use of business intelligence applications enhances clinical and/or business decision-making capabilities. The Business Intelligence Analyst will work on limited to moderately complex projects and gain exposure to more complex tasks under the supervision of the team leader or other data governance or analytic leadership appropriate for the scope of work. This supervision may be through a matrixed or direct reporting structure.

The Office of Medical Annual Giving (OMAG) raises between $3 - $4 million annually, bringing in about one third of Johns Hopkins Medicine donors each year. OMAG collaborates with 23 clinical departments, two institutes, the School of Medicine degree granting programs and two of our partner hospitals. In addition to providing cash for specific departments, OMAG sources unrestricted philanthropic dollars for the Dean of the School of Medicine. The Business Intelligence Analyst manages a complex, multi-step, process to analyze and prepare Office of Medical Annual Giving (OMAG) data for annual giving appeals.

The Business Intelligence Analyst is a key team member of the Office of Medical Annual Giving (OMAG). He or she manages day-to-day responsibilities that are integral to the operation of a successful annual giving campaign. These responsibilities include generating and analyzing reports vital for moving OMAG's work forward in efficient and cost-effective fashion and for identifying prospects for 23 departments, two alumni programs, two institutes, three of our partner hospitals and grateful patient nursing efforts via pipelined development efforts. This role manages a complex, multi-step, process to prepare our data for annual giving appeals and is responsible for championing the highest data quality in our institutional databases.

Key responsibilities:

+ Responsible for data analytics and additional support for performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination.

+ Responsible for participating in the strategic design and maintenance of business intelligence applications.

+ Identify, research, and resolve technical problems.

+ Ensure that the use of business intelligence applications enhance clinical and/or business decision-making capabilities.

+ Make appropriate decisions using available resources to achieve positive outcomes for patients, visitors, and staff in balance with sound business practice.

+ Make recommendations for changes in the current departmental systems and processes and contribute ideas and suggestions for solutions to problems.

+ Report and follow up on software problems delaying workflow.

+ Respond to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action, and appropriately managing information and communication.

+ 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.

In addition to the duties described above, the Business Intelligence Analyst will:

+ 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 and create accurate, reliable metrics and dashboards

+ 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 MedDev to resolve issues and execute regular data-cleanup initiatives

Minimum Qualifications

+ Bachelor’s degree in a related field.

+ Three years of experience in a professional environment using the relevant knowledge base and skills. 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

Job Posting Title (Working Title): Business Intelligence Analyst, Office of Medical Annual Giving

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:30am-5:00pm

FLSA Status: Exempt

Department name: 10003243-SOM Admin FJHM Friends of Medicine

Personnel area: School of Medicine

\#LI-Hybrid

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.