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