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.

• 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.

• 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