Business Intelligence Analyst II, Finance & Administration

Requisition ID

122629

Date Created

October 01, 2026

Job Family

Data Management

Job Subfamily

Data Management

Job Function

Development and Alumni Relations

Exempt Status

Exempt

Shift Type

Full Time

Schedule

Mon\-Fri, 8:30am\-5:00pm

Worksite

02\-MD:Mount Washington Campus

Work Modality

Hybrid: On\-site 60\-89% of hours worked (Ex: 3\-4 out of 5 days/week)

The **Business Intelligence Analyst II** will support the Development and Alumni Relations Finance and Administration team by acquiring, transforming, analyzing, and reporting financial and operational data. The Analyst will maintain and improve automation processes and Power BI dashboards that support financial reporting, planning, reconciliations, and decision\-making.

The Analyst will partner with finance leadership and staff to define data needs, troubleshoot existing workflows, and develop reliable tools and visualizations.

Reporting to the Sr. Finance Project Manager, the Analyst will coordinate with central data and technology teams as needed to ensure that finance data and reporting processes are accurate, documented, and aligned with University standards. The Analyst will also support finance data preparation, validation, and reporting.

The **Business Intelligence Analyst II** is responsible for data analytics and additional support for performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination. Responsible for participating in the strategic design and maintenance of business intelligence applications.

The **Business Intelligence Analyst II** will identify, research, and resolve technical problems. The **Business Intelligence Analyst II** will ensure that the use of business intelligence applications enhances clinical and/or business decision\-making capabilities. The **Business Intelligence Analyst II** will work on limited to moderately complex projects and gain exposure to more complex tasks within the job function.

The **Business Intelligence Analyst II** will work under the supervision of a Data Trust Analytic Team Leader or other data governance or analytic leadership appropriate for the scope of work. This supervision may be through a matrixed or direct reporting structure.

**Specific Duties \& Responsibilities:**

• Responsible for data analytics and additional support for performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination.
• Responsible for participating in the strategic design and maintenance of business intelligence applications.
• Identify, research, and resolve technical problems.
• Ensure that the use of business intelligence applications enhances clinical and/or business decision\-making capabilities.
• Make appropriate decisions using available resources to achieve positive outcomes for patients, visitors, and staff in balance with sound business practice.
• Make recommendations for changes in the current departmental systems and processes and contribute ideas and suggestions for solutions to problems.
• Report and follow\-up on software problems delaying workflow.
• Respond to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action, and appropriately managing information and communication.
• Communicate decisions to appropriate management.
• Prepare incident/occurrence reports as necessary.
• Prioritize daily tasks and assignments appropriately.
• Complete mandatory Epic and other software or analytic tool training as required.
• Collaborate with other analytic teams as directed.
• Other duties as assigned.

In addition to the duties listed above the **Business Intelligence Analyst II** will:

• Maintain, troubleshoot, document, and enhance Python scripts used by DAR Finance for recurring reporting, reconciliations, budget and forecast preparation, personnel cost analysis, allocations, and other finance workflows.
• Acquire, integrate, cleanse, transform, and validate data from general ledger, budget, payroll, procurement, expense, and other enterprise sources for Finance; reconcile outputs to authoritative financial records.
• Develop and maintain DAR Finance's Power BI data models, Power Query transformations, DAX measures, refresh processes, reports, and dashboards supporting budget\-to\-actual, forecast, fund balance, personnel cost, and transaction analysis.
• Establish Finance data\-quality and governance standards, including financial mappings, metric definitions, reconciliations, documentation, version control, and repeatable controls for consistent, auditable reporting.

**Minimum Qualifications**

• Bachelor’s degree in a related field.
• Three years of experience in a professional environment using the relevant knowledge base and skills. A minimum of two years collecting and analyzing data, preparing reports, identifying and solving problems.
• Additional education may substitute for required experience and additional related experience may substitute for required education permitted by the JHU equivalency formula beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula.

**Preferred Qualifications**

• Proficiency in Python for data transformation, automation, and troubleshooting; proficiency in Microsoft Power BI, including Power Query, DAX, data modeling, and dashboard development; and proficiency in Microsoft Excel, with demonstrated experience applying finance or accounting concepts to budgets, forecasts, reconciliations, and variance analysis.
• Professional background in financial planning and analysis, accounting, or higher education finance.

Classified Title

Business Intelligence Analyst II

Job Posting Title (Working Title): Business Intelligence Analyst II, Finance \& Administration

Role/Level/Range: ATP/03/PC

Starting Salary Range: Minimum: $55,100 \- Maximum: $96,700 (targeted salary: $68,000; commensurate with experience)

Employee group: Full Time

Schedule: Mon\-Fri, 8:30am\-5:00pm

FLSA Status: Exempt

Location: Mount Washington Campus

Department name: 10001643\-Finance

Personnel area: University Administration

***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 requires all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the 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.

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