HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    JO

    Johns Hopkins University

    Higher Education & Research

    Business Intelligence Analyst II, Finance & Administration

    Baltimore, MD, United States, United StatesOn-SiteFull-time$55.1k – $96.7k / yearPosted 1w ago
    All Johns Hopkins University jobs

    Job description

    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

    Job details are sourced from the employer's original posting.

    Open job posting
    JO

    About the company

    Johns Hopkins University

    A private research university providing education and conducting research across medicine, engineering, arts and sciences, and other disciplines.

    View all Johns Hopkins University jobs
    Industry
    Higher Education & Research
    Open roles
    597

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.