Business Intelligence Analyst II, Finance & Administration

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