About the role
Single Position
Single Position
View All JobsBusiness Intelligence Analyst II, Finance & Administration
Baltimore, MD, United StatesApply NowFind out how well you match with this jobAffiliated Office AddressBaltimore, MD, United StatesRequisition ID122629Date CreatedOctober 01, 2026Job FamilyData ManagementJob SubfamilyData ManagementJob FunctionDevelopment and Alumni RelationsExempt StatusExemptShift TypeFull TimeScheduleMon-Fri, 8:30am-5:00pmWorksite02-MD:Mount Washington CampusWork ModalityHybrid: 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 [email protected]. 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.
- Director of Finance (KSAS Finance & Administration)Baltimore, MD, United StatesHybridFlexible LocationPosted 2 days ago
- Director of Administrative Operations - BSPH (Finance & Administration)Baltimore, MD, United StatesHybridFlexible LocationPosted 6 hours ago
- Sr. Associate Strategic Initiatives (Finance and Administration)Baltimore, MD, United StatesHybridPosted 10 days ago
- Associate VP & Deputy Treasurer (Office of EVP for Finance and Administration)Baltimore, MD, United StatesPosted a month ago
- Director of Finance (Basic Science Consortium - Finance)Baltimore, MD, United StatesHybridFlexible LocationPosted a month ago
- Sr. Grants & Contracts Analyst, Pre-Award (School of Medicine - Central Finance)Baltimore, MD, United StatesPosted 14 days ago
- Research Assistant (Research Administration)Washington, DC, United StatesPosted 5 months ago
- Division Administrator (Department of Medicine; Nephrology)Baltimore, MD, United StatesPosted 4 days ago
- Director Finance Service Delivery (VP, Chief Financial Office)Baltimore, MD, United StatesPosted 5 months ago
- Sr. Data Analyst (Oncology)Baltimore, MD, United States + 1 morePosted a month ago
How to apply
Read the full posting, then apply through the employer's own site. Applications are handled by the institution, not by AcademicGates.