Create Alert
Apply now »
Requisition ID:  117547

Business Intelligence Data Analyst

IT@JH Enterprise Business Solutions is seeking a Business Intelligence Analyst II who will be responsible for the planning, development, and maintenance of reports for clients of the Enterprise Business Solutions (EBS) Analytics group using industry standard tooling such as Microsoft SQL Server, Power BI, Snowflake, and Tableau. This role reports to the IT Manager of the EBS Analytics group and will work with that individual to take ownership of certain projects within the team’s portfolio.


Specific Duties & Responsibilities

  • This role is directly client facing and will take on a lead role with new projects including gathering requirements, attending/leading regular meetings with clients, managing internal team resources, and acting as a point of contact for the project team.
  • Interfaces with project leaders/sponsors, Divisional and Enterprise leadership, and representatives of the Johns Hopkins Data Trust.
  • Reports to the IT Manager of the EBS Analytics group and will meet regularly with that individual to set high-level objectives and ensure alignment with Departmental goals.
  • Responsible for independent organization of individual and project priorities in alignment with those high-level objectives.
  • Work in this role will vary by project but includes supporting existing reports by providing quality of life updates and bug fixes, migrating reports from legacy tooling, developing new reporting in tools such as Power BI under the guidance of a project manager, responding to ad-hoc data requests from clients, creating and maintaining SQL queries and reporting views, and working directly with clients on all aspects of their assigned projects.


Specific Devices, Software, Projects

  • Primary software used includes SQL Server, Snowflake, Tableau, and Power BI. Occasionally other tools such as Azure, Azure Data Factory, Fabric, and Python are used as well.
  • All work is done in the Microsoft Windows ecosystem.


Scale/size of Area, Project and/or System Supported

  • Projects supported have varied user bases ranging from 10 users to thousands.
  • Clients supported by the EBS Analytics group include all divisions of the Enterprise that have an active contract and can include small research teams, executive leadership, and enterprise-wide tooling. As such, this role is required to have the ability to handle complex tasks involving many stakeholders and disparate data feeds, as well as flexibility and proficiency in a multitude of subject matter areas covering medical, financial, and operational domains.
  • High adaptability and strong interpersonal and problem-solving skills are required.


Work Location

  • Remote, United States. Proximity to Baltimore is preferred.


Special Knowledge, Skills, and Abilities

  • Strong analytical and critical thinking skills to derive insights from data driven by nuanced business requirements.
  • Strong attention to detail.
  • High level of accuracy and thoroughness in data analysis and reporting.


Technical qualifications or specialized certifications

  • Proficiency with data querying & analysis tools such as SQL, Python, or R
  •  Familiarity with Data Privacy Regulations (e.g., HIPPA)


Minimum Qualifications
  • Bachelor's Degree.
  • Minimum of 3 years of related experience, including two years involved in collecting and analyzing data, preparing reports, identifying, solving problems, and delivering actionable insights.
  • Strong written and verbal communication skills.
  • Familiarity with basic UI/UX principles.
  • Proficiency in SQL and data modeling.
  • Should be able to write and document complex SQL queries.
  • Should be able to write and modify Views.
  • Additional education may substitute for required experience and additional experience may substitute for education, to the extent permitted by the JHU equivalency formula.


Preferred Qualifications
  • Experience with industry standard BI tools such as Power BI or Tableau.
  • Relevant industry-standard Certifications preferred.
  • Advanced SQL and data modeling knowledge in addition to the above minimum qualifications.
  • Should be comfortable with Window Functions, Sub-Selects, CTEs.
  • Should understand performance impacts of different code solutions.
  • Should be able to assess code performance and optimize existing queries.
  • Be able to digest complex business requirements into clear goals and objectives.

 

 

Classified Title: Business Intelligence Analyst II 
Job Posting Title (Working Title): Business Intelligence Data Analyst   
Role/Level/Range: ATP/03/PC  
Starting Salary Range: $53,800 - $94,400 Annually (Commensurate w/exp.) 
Employee group: Full Time 
Schedule: Mon-Fri 8:30am-5:00pm 
FLSA Status: Exempt 
Location: Remote 
Department name: IT@JH Enterprise Business Solutions  
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 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 https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

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

Apply now »