Sr. Business Intelligence Analyst, Medical Development Services & Analytics

Johns Hopkins University
United States, Maryland, Baltimore
Mar 15, 2025
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. Minimum Qualifications 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 equivalency formula. Preferred Qualifications Knowledge of project and information management Analytical ability to gather data, perform transformation, perform complex analysis, solve both complex business and technical problems Advanced knowledge of medical terminology and clinical information for positions working with patient-related data or knowledge of business expertise Expert proficiency with business intelligence techniques and tools for the acquisition and transformation of raw data in meaningful and useful information for business and analysis purposes Knowledge of relational databases. Knowledge of EMR data structure for positions working with patient-related data Advanced ability to problem-solve creatively and analyze processes and systems in a fast paced and complex environment Must possess advanced written and verbal communications skills necessary to gather and exchange data (both externally and internally) Ability to independently assess and lead others in which data management and statistical strategies are needed to optimally report outcomes Highly proficient with administrative skills, including advanced use of work processing, database, spreadsheet, and desktop publishing software Ability to manage highly complex data sets Data mining/management, data collection instruction, including ability to show data in a user-friendly format for a variety of audiences Strong problem identification and resolution skills Advanced interpersonal skills to effectively interface with department heads, FJHM personnel, vendors, consultants, to lead projects Ability to balance multiple tasks simultaneously and quickly switch between priorities/tasks Ability to interact with all levels of staff and adapt to a rapidly changing work environment Advanced critical thinking skills and the ability to apply these skills in various situations Ability and willingness to mentor colleagues and share experiences to strengthen the team's success Awareness of the need for timely communication, ability to identify potential barriers and strategies, and ability to synthesize and integrate information Knowledge of and ability to use multiple information systems and software Classified Title: Sr. Business Intelligence Analyst Job Posting Title (Working Title):Sr. Business Intelligence Analyst, Medical Development Services & Analytics Role/Level/Range: ATP/04/PD Starting Salary Range: Minimum: $62,899 - Maximum: $110,100 (targeted salary: $85,000; commensurate with experience) Employee group: Full Time Schedule: Monday-Friday, 8:30am-5:00pm FLSA Status:Exempt Location:School of Medicine - East Baltimore Campus Department name: 10003237-SOM Admin FJHM HIPAA Funding Compliance Personnel area: School of Medicine Total Rewards The referenced base salary range represents the low and high end of Johns Hopkins University's salary range for this position. Not all candidates will be eligible for the upper end of the salary range. Exact salary will ultimately depend on multiple factors, which may include the successful candidate's geographic location, skills, work experience, market conditions, education/training and other qualifications. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/. Education and Experience Equivalency Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines: 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. Applicants Completing Studies Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date. Background Checks The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function. Diversity and Inclusion The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion. 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. EEOis the Law https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf Accommodation Information 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 Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/. Vaccine Requirements Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine.The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry.This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/. The following additional provisions may apply, depending upon campus. Your recruiter will advise accordingly. 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.