Sr. Business Intelligence Analyst II

Office of the Deputy CIO is seeking a Sr. Business Intelligence Analyst II. As part of University Data & Analytics, this key resources on University Data Warehouse team is primarily responsible for requirements gathering and understanding, testing, QA and documentation. In addition, this role will collaborate with and support data producers and consumers across JHU. Partner with data engineers to establish work plans and continuously deliver BI self-service and other value-added BI and analytic deliverables (reports, dashboards, scorecards) in support of university strategic and operational objectives.

Specific Duties & Responsibilities

• Responsible for data analytics and additional support of performance measures, ongoing measurement, data collection, reporting, data visualizations and information dissemination.
• Responsible for implementing the strategic design and maintenance of business intelligence applications. Identifies, researches, and resolves technical problems.
• Ensure that the use of business intelligence applications enhances business decision making capabilities.
• Engage in data exploration exercises with a variety of complex business intelligence tools, requiring knowledge of relational database structures.
• Serve as a resource on complex technical and business matters.
• Provide a leadership role for the work group through knowledge in the area of specialization.
• Collaborate with other analytic teams and central engineering team as directed.
• Make appropriate decisions, using available resources, to achieve positive outcomes for patients, visitors, staff, and students in balance with sound business practice.
• Make recommendations for changes in the current departmental systems and processes and contribute ideas and recommendations for solutions to problems.
• 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/or other software or analytic tool training as required.
• Collaborate with other analytic teams as directed.
• Data mining/management, data collection instruction, and show data in a user-friendly format for a variety of audiences.
• Report and follow-up on software problems delaying workflow.
• Other duties as assigned.

• Bachelor's Degree in related field.
• Six years of related experience, including three years of data analytic experience.
• Additional education may substitute for required experience and additional related experience may substitute for required education beyond a high school diploma/graduation equivalent, to the extent permitted by the JHU equivalency formula.

• Knowledge of JHU SIS ecosystem.
• Understanding of dimensional modeling methods and usage.
• Experience in building community of practice among university producers and consumers of data products.
• Proficiency in Power BI semantic models and visualizations.

Technical Skills and Expected Level of Proficiency

• Analytics & BI Tools - Intermediate
• Data Analysis - Intermediate
• Data Tools and Platforms - Intermediate
• Data Visualization - Intermediate
• Interpersonal Skills General - Intermediate
• Oral and written communications - Intermediate
• Project Management - Intermediate
• Strategic Thinking - Intermediate
• Troubleshooting - Intermediate

The core technical skills listed are most essential; additional technical skills may be required based on specific division or department needs.

Classified Title: Sr. Business Intelligence Analyst II
Role/Level/Range: ATP/04/PE
Starting Salary Range: $73,300 - $128,300 Annually (Commensurate w/exp.)
Employee group: Full Time
Schedule: Mon-Fri 8:30am-5:00pm
FLSA Status:Exempt
Location: Remote
Department name: Office of the Deputy CIO
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:

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.

EEOis the Law

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 For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit

Vaccine Requirements
Johns Hopkins University strongly encourages, but no longer requires, at least one dose of the COVID-19 vaccine.The COVID-19 vaccine does not apply to positions located in the State of Florida. We still require all faculty, staff, and students to receive the seasonal flu vaccine. Exceptions to the COVID and 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.This change does not apply to the School of Medicine (SOM). SOM hires must be fully vaccinated with an FDA COVID-19 vaccination and provide proof of vaccination status. For additional information, applicants for SOM positions should visit all other JHU applicants should visit

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.