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
The listed salary range represents the minimum and maximum Johns Hopkins University offers for this position, based on a good faith estimate at the time of posting. Actual compensation will vary depending on factors such as location, skills, experience, market conditions, education, and internal equity. Not all candidates will qualify for the highest salary in the range.
Johns Hopkins provides a comprehensive benefits package supporting health, career, and retirement. Learn more: https://hr.jhu.edu/benefits-worklife/.
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.
EEO is the Law
https://www.eeoc.gov/sites/default/files/2023-06/22-088 EEOC KnowYourRights6.12ScreenRdr.pdf
S:SKINTIAGP1
