Advanced Business Intelligence Analyst

Saint Joseph Mercy Health System, one of the nation's top health care services providers, spanning five counties in Southeastern Michigan. SJMHS represents more than 2,700 physicians and 14,000 nurses and staff, and includes 6 Hospitals, 5 Outpatient Health Centers, 8 Urgent Care Facilities and over 25 Specialty Centers.

Performs statistical and related business intelligence analyses to inform the design and assessment of health care quality and safety; develops scheduled, updated analyses for a production system of reports; creates datasets for high-level statistical analyses as part of innovative team.

Essential Functions:

Proficient in the use of SAS or SQL software to create datasets for analysis from multiple, primary sources, conducts analyses and creates reports; Programming skills should be sufficient for modular programming to support recurring production-level datasets; Analytical skills should be sufficiently developed for forecasting, predictive modeling and longitudinal cohort analyses.

  • Write SQL queries for data manipulation, sorting, summarizing and reporting.
  • Reviews, analyzes and modifies programming systems including coding, testing, debugging and documenting programs.
  • Uses standard macros/code to comply with department standards.
  • Checks for validity and reproducibility of quality/safety measures when indicated from multiple data sources.
  • Ensures completeness and accuracy of reports.
  • Uses additional reporting tools such as Business Objects, Excel, Tableau etc. as needed.
  • Maintains routine reporting and data load processes.
  • Uses advanced coding techniques to produce efficient programs and contributes to existing macro library.
  • Documents projects and code extensively – this includes inserting comments in code to explain the purpose of code at each step, creating documentation/instructions that can be understood/used with ease by team members in absence of programmer, creating documentation that enables team members to understand purpose of program/project, data sources used, nuances of project, etc.

Able to produce graphical and other visual displays of data to guide the decision-maker.

  • Collaborates with medical and clinical staff leadership and colleagues to determine information needs and to understand requirements for application and/or reports.

Leads team projects and provides reporting support for web applications.

  • Assists staff with understanding of healthcare data and assists in the training of new staff members.
  • Provides programming and analytical expertise on team projects.
  • Co-ordinates & oversees projects for successful completion.

Behaves in accordance with the Mission, Vision and Values of Saint Joseph Mercy Health System

  • Maintain good rapport and cooperative relationships. Approaches conflict in a constructive manner.
  • Helps to identify problems, offer solutions, and participate in their resolution.
  • Assumes responsibility for performance of job duties in the safest possible manner, to assure personal safety and that of coworkers and to report all preventable hazards and unsafe practices immediately to management.

Maintains the confidentiality of information acquired pertaining to patients, physicians, employees, and visitors to St. Joseph Mercy Health System. Discusses patient and hospital information only among appropriate personnel in appropriately private places.

Performs other duties as assigned.

Required Qualifications:

  • Education: Bachelors degree, Masters (preferred)
  • Experience:
  • Minimum of 3 years experience in business intelligence analyses pertaining to at least one of the following – clinical, financial, operations, biostatistics, epidemiology, clinical research or industrial engineering
  • Proficient in SAS and SQL, Base SAS, SAS STAT, SAS QC, SAS Graph, ODS, macro programming or Proficient in SQL.
    Understanding of healthcare data – inpatient, outpatient or managed care (Preferred)

Employees of St. Joseph Mercy Health System enjoy…

  • Competitive compensation
  • Full benefits package including Medical, Dental, Vision, PTO, Life Insurance and Disability
  • Retirement savings plan with employer contribution
  • Opportunity for growth and advancement throughout SJMHS and Trinity Health

Visit to learn more about the benefits, culture and career development opportunities available to you at Saint Joseph Mercy Health System.