Senior Business Intelligence Analyst - Decision Support - FT - Days - MSS

Location:

Fort Lauderdale, Florida

At Memorial, we are dedicated to improving the health, well-being and, most of all, quality of life for the people entrusted to our care. An unwavering commitment to our service vision is what makes the difference. It is the foundation of The Memorial Experience.

Summary:

This position is responsible for analyzing complex business intelligence data to inform business decisions by evaluating datasets, creating reports, dashboards and extracts for a variety of needs. This position is responsible for all aspects of the Business Intelligence (BI) development lifecycle, including the integration of new data sources, extraction and visualization of data, along with quality assurance of data.

Responsibilities:

Responsible for proactive monitoring of all reports, analysis, recommendations, dashboards and data extracts for the department. Leverages expertise to troubleshoot more challenging issues, performs root cause analysis, and takes preventive actions. Creates and maintains test scripts, analytics and algorithms for validation and integrated testing. Responsible for testing efforts, including making sure that existing reports and extracts continue to work well after workflow changes or software upgrades.Maintains expertise with Memorial Healthcare System (MHS) and industry standards for reporting, analysis, dashboards, and data extracting. Plays leading role in enforcing BI standards, policies and procedures within the department. Assists with maintenance of these standards.Documents mappings for automated data extracts for the department following applicable standards, governance, documentation, policies and procedures.Designs and develops templates for reports and dashboards that share consistent branding, look and feel. Promotes use of these templates and ensures compliance. Ensures sensitive data is displayed, delivered and secured properly. Provides analysis, insights and recommendations to leaders throughout the company. Mentors Analysts in content presentation and delivery.Maintains expertise with analytics for assigned departments, including associated centralized data models, applications, tools, workflows, customers, competitors, professional organizations, and regulations. Maintains regular communication with teams to stay up-to-date with upcoming regulations, value-based programs, workflow changes or software upgrades that may impact reports, analysis, dashboards or centralized data models. Collects BI data from available industry reports, public information, field reports, or purchased sources; when needed, documents specifications and works closely with BI Developers to add data to centralized data models.Serves as subject matter expert for all reports and dashboards. Plays leading role in creating reports and dashboards and completing analytics and recommendations using established tools and centralized data models while creating and/or following applicable standards, policies and procedures. Performs analytics. Responsible for overall quality of the department's reports, analysis and dashboards.Plays leading role in developing documentation related to the analytics assets of the department, including data catalogs, data dictionaries, troubleshooting guides, knowledge base articles, and data model diagrams. Helps promote and shares available information and resources throughout MHS through training and workshops. Actively participates in local user groups or meetings. Responsible data steward driving data and reporting governance, standardization, management and documentation.

Competencies:

ACCOUNTABILITY, ACCOUNTING - FINANCIAL STATEMENTS, ACCURACY, ANALYSIS AND DECISION MAKING - IT, CONTENT PRESENTATION AND DELIVERY, CUSTOMER SERVICE, DATA EXTRACTION AND TRANSFER, DATA MINING - ANALYSIS & REPORTING, EFFECTIVE COMMUNICATION, FINANCIAL ANALYSIS, HEALTHCARE INDUSTRY, HIPAA, PROBLEM SOLVING, REPORTING AND DASHBOARDING, RESPONDING TO CHANGE, STANDARDS OF BEHAVIOR

Education and Certification Requirements:

Bachelors: Computer Science (Required)

Additional Job Information:

Complexity of Work: The role requires excellent oral and written communication skills. The incumbent must have expertise building complex SQL queries with or without the use of reporting and/or dashboard tools. The incumbent must be proficient with MHS analytics tools and applications including SSRS, Tableau and/or Pyramid.This role requires critical thinking skills, effective communication, decisive judgment, and the ability to work with minimal supervision. The incumbent must be able to work in a stressful environment and take appropriate action when required. Prior experience with business intelligence / reporting tools like Tableau, Microsoft SSRS, Epic Cogito Tools, etc. Ability to write SQL queries for reporting and data profiling, including an understanding of database design concepts and table joins. Intermediate to advanced use of Microsoft Excel or Microsoft Access to analyze large data sets. Translating reporting requirements of clinicians, administrators, support staff into technical specifications for IT developers. Extreme attention to detail, especially when producing analyses or validating complex healthcare datasets. Strong organizational skills juggling multiple tasks simultaneously, flexibility to adapt to rapidly changing priorities, diligently follow up on action items for self and others. Ability to test and validate reports and dashboards, especially against the source data in the database. Must be able to build and foster positive relationships and lead others.

Required Work Experience: Three (3) years of progressive work experience in providing analytics, SQL queries, reports, dashboards, and communicating findings/recommendations. Experience with SSRS, Tableau, or Pyramid.Preferred: Experience using EHR and/or payer claims data.

Other Information: Additional Education Info: Bachelor's degree in Computer Science, Accounting, Finance, Business or a healthcare related field.Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Information Systems, or a closely related field plus three (3) years of work experience in job offered or as Data Analyst.

Working Conditions and Physical Requirements:

• •Bending and Stooping = 0%
• •Climbing = 0%
• •Keyboard Entry = 80%
• •Kneeling = 0%
• •Lifting/Carrying Patients 35 Pounds or Greater = 0%
• •Lifting or Carrying 0 - 25 lbs Non-Patient = 60%
• •Lifting or Carrying 2501 lbs - 75 lbs Non-Patient = 0%
• •Lifting or Carrying > 75 lbs Non-Patient = 0%
• •Pushing or Pulling 0 - 25 lbs Non-Patient = 60%
• •Pushing or Pulling 26 - 75 lbs Non-Patient = 0%
• •Pushing or Pulling > 75 lbs Non-Patient = 0%
• •Reaching = 0%
• •Repetitive Movement Foot/Leg = 0%
• •Repetitive Movement Hand/Arm = 80%
• •Running = 0%
• •Sitting = 60%
• •Squatting = 0%
• •Standing = 60%
• •Walking = 60%
• •Audible Speech = 60%
• •Hearing Acuity = 60%
• •Smelling Acuity = 0%
• •Taste Discrimination = 0%
• •Depth Perception = 60%
• •Distinguish Color = 60%
• •Seeing - Far = 60%
• •Seeing - Near = 60%
• •Bio hazardous Waste = 0%
• •Biological Hazards - Respiratory = 0%
• •Biological Hazards - Skin or Ingestion = 0%
• •Blood and/or Bodily Fluids = 0%
• •Communicable Diseases and/or Pathogens = 0%
• •Asbestos = 0%
• •Cytotoxic Chemicals = 0%
• •Dust = 0%
• •Gas/Vapors/Fumes = 0%
• •Hazardous Chemicals = 0%
• •Hazardous Medication = 0%
• •Latex = 0%
• •Computer Monitor = 80%
• •Domestic Animals = 0%
• •Extreme Heat/Cold = 0%
• •Fire Risk = 0%
• •Hazardous Noise = 0%
• •Heating Devices = 0%
• •Hypoxia = 0%
• •Laser/High Intensity Lights = 0%
• •Magnetic Fields = 0%
• •Moving Mechanical Parts = 0%
• •Needles/Sharp Objects = 0%
• •Potential Electric Shock = 0%
• •Potential for Physical Assault = 0%
• •Radiation = 0%
• •Sudden Decompression During Flights = 0%
• •Unprotected Heights = 0%
• •Wet or Slippery Surfaces = 0%

Shift:

Primarily for office workers - not eligible for shift differential

Disclaimer: This job description is