Requisition ID:  115769

Sr. Business Intelligence Analyst II

We are seeking a Sr. Business Intelligence Analyst II who develops the buildout and maintenance of data to support School of Medicine’s Central Finance function and manages a 'Data and Report Inventory' for approved and recommended reports.


Specific Duties & Responsibilities


Coordinates

  • Creates the initial build out and maintenance of data tools to support the organization. Maintains a 'Data and Report Inventory' of approved reports.


Applies

  • Applies knowledge of the Central Finance organization and its data to inform the build out and maintenance of data, develop tools, and plan future analytics assets.


Creates/Prepares/Develops

  • Develops new tools and means to use data at the School and department levels. Develops a 'Data and Report Inventory' for approved and recommended reports.


Analyzes/Interprets

  • Analyzes the current data infrastructure of an organization to determine how to build out and maintain data to support the organization.


Manages

  • Manages the initial build out, maintenance, and future buildout of data tools in the organization.


Problem Solving

  • Verifies and validates data to approve reports and catalog them in the 'Data and Report Inventory'.
  • Analyzes data and the data infrastructure continuously to identify gaps where future buildout or new tools could be implemented.


Thinking Critically

  • Understands the organization and its data infrastructure to inform the initial build out and maintenance of the data. Determines which reports to catalog and curate for relevant stakeholder groups.


Trains/Communicates

  • Ensure that Central Finance, departments, and other colleagues are aware of the 'Data and Report Inventory' and can access recommended reports to inform their work.


Collaborates

  • Partner with Sr. Director of Analytics; 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

  • Requires excellent data and data analysis skills, including advanced Excel skills.
  • Requires analytical ability to gather data, perform transformation, complex analysis and solve both business and technical problems.
  • Expert proficiency with data preparation and business intelligence techniques and tools for the acquisition and transformation of raw data into meaningful and useful information.
  • Certification such as Certified Analytics Professional, PMP or certification in a data analytic tool (e.g., Tableau) preferred.


Physical Requirements 

  • Sitting in a normal seated position for extended periods of time.
  • Finger dexterity required to manipulate objects with fingers rather than with whole hand(s) or arm(s), for example, using a keyboard.
  • Occasionally lifting, carrying objects weighing 10lbs. or less.
  • Occasionally pushing, pulling objects weighing 30lbs. or less.


Minimum Qualifications
  • Bachelor's Degree in Information Technology, Business/Data Analytics or a related field.
  • Six plus years of progressively responsible financial and business operations experience, preferably in a large and complex organization, with at least 3 years direct data analytics experience.
  • 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 mission.
  • Additional education may substitute for required experience, to the extent permitted by the JHU equivalency formula. Additional experience may be substituted for education.


Preferred Qualifications
  • Master’s Degree preferred.
  • Experience in financial/business management and/or academic business operations.
  • Significant experience in working with relational databases (e.g.,SQL), data analysis, data visualization tools (e.g., Microsoft Power BI, Tableau, etc.).

 


 

Classified Title: Sr. Business Intelligence Analyst II 
Role/Level/Range: ATP/04/PE  
Starting Salary Range: $73,300 - $128,300 Annually ($100,800 targeted; Commensurate with experience) 
Employee group: Full Time 
Schedule: Mon-Fri, 8.30am-5.00pm 
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