Sr. Business Intelligence Analyst

Job Req ID: 113338

Sr. Business Intelligence Analyst

We are seeking a Sr. Business Intelligence Analyst who will support Financial Operations and Faculty Practice Finance by building reports and dashboards, creating data structure, and developing and monitoring metrics.

Specific Duties & Responsibilities

Coordinates

• Supports the Financial Operations and Faculty Practice Finance functions by building reports and dashboards, creating data structure, and developing and monitoring metrics.

Applies

• Applies knowledge of systems and needs of the Financial Operations and Faculty Practice Finance functions to inform the data structure and build dashboards and reports.

Creates/Prepares/Develops

• Builds dashboards and reports.

• Curates existing dashboards.

• Develops proof of concepts on the design of dashboards and reports.

Analyzes/Interprets

• Analyzes, verifies, and validates data from disparate systems to incorporate into reports and dashboards.

Manages

• Manages the development and maintenance of dashboards and reports for the Financial Operations and Faculty Practice Finance functions.

• Manages data structure and support metric monitoring through data from multiple systems.

Problem Solving

• Ensures reports and dashboards are effective by testing with consumers.

Thinking Critically

• Identifies the needs of Financial Operations, Faculty Practice Finance, and stakeholders to build relevant and consumable dashboards and reports.

Trains/Communicates

• Ensures Financial Operations, Faculty Practice Finance, executive leadership, departmental leadership, and other relevant stakeholders are effectively using dashboards and reports to inform their roles and responsibilities.

Collaborates

• Partner with Sr. Director of Analytics, other Business Intelligence Analysts, FP&A colleagues, Financial Operations Colleagues, Faculty Practice Colleagues, Research Finance Colleagues, Department Directors, Administrators, and Staff; University Budget; University Controller, JHHS/JHM Finance Colleagues

Special Knowledge, Skills, & Abilities

• Proven communication, organizational, and analytic skills in a complex organization.

• Ability to analyze data for budgeting, operations, auditing, accounts receivable, and reserve analysis.

• Understanding of and commitment to the Johns Hopkins Medicine mission.

Minimum Qualifications

• Bachelor's Degree in Finance, Accounting, Business or a related field.

• Four years of progressively responsible financial and business operations experience, including a minimum of two years of data analytics.

• Excellent data and financial modeling skills, including advanced Excel skills.

• Additional education may substitute for required experience, and additional experience may be substituted for education to the extent permitted by the JHU equivalency formula.

Preferred Qualifications

• Experience in financial and business operations in a large and complex organization.

• Experience in research financial management and academic business operations.

• Experience in SQL development, data visualization tools (i.e. Microsoft Power BI, Tableau, etc.)

Classified Title: Sr. Business Intelligence Analyst

Role/Level/Range: ATP/04/PD

Starting Salary Range: $62,300 -$109,000 ($85,000 targeted; Commensurate with experience)

Employee group: Full Time

Schedule: 37.50

Exempt Status: Exempt

Location: Hybrid/School of Medicine Campus

Department name: SOM Admin Finance Analytics

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.

EEO is 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.

Hybrid: On-site 3-4 days a week