Sr. Business Intelligence Analyst II

We are seeking a Sr. Business Intelligence Analyst II. This role develops the initial buildout and maintenance of data to support the future organization and manages a 'Data and Report Dictionary' for approved and recommended reports.

Specific Duties & Responsibilities

Coordinates

• Creates the initial build out and maintenance of data to support the future organization. Maintains a 'Data and Report Dictionary' 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 databases.

Creates/Prepares/Develops

• Develops new tools and means to use data at the School and department level. Develops a 'Data and Report Dictionary' 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 future organization.

Manages

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

Problem Solving

• Verifies and validates data to approve reports and catalog them in the 'Data and Report Dictionary'. 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 Dictionary' 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.

• Bachelor's Degree in Information Technology, Business/Data Analytics or a related field,
• Six years of progressively responsible financial and business operations experience, preferably in a large and complex organization, with a minimum of three years 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.
• Additional experience may be substituted for education, to the extent permitted by the JHU equivalency formula.

• Master's Degree preferred.
• Experience in research financial management and academic business operations.

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

Special Knowledge, Skills, & Abilities

• Requires excellent data and financial modeling 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 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 (including Tableau or EPIC) required.
• Understanding of and commitment to the Johns Hopkins mission

Classified Title: Sr. Business Intelligence Analyst II 
Role/Level/Range: ATP/04/PE  
Starting Salary Range: Min $72,600 - Max $127,000 Annually ($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 School of Medicine  
Personnel area: School of Medicine 

Total Rewards
The referenced salary range is based on Johns Hopkins University’s good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: