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

Memorial Healthcare System; Fort Lauderdale (FL); On-site; USD 80,000 - 110,000; Full time

Job summary

Memorial Healthcare System in Fort Lauderdale is seeking a BI Analyst to analyze complex data, build reports and dashboards, and deliver data extracts to support informed business decisions across departments.

You will lead BI development, integrate new data sources, ensure data quality, and mentor analysts. Strong SQL, SSRS/Tableau/Pyramid, and healthcare data experience are required. Excellent communication and problem solving are essential.

Qualifications

• Three years of progressive analytics experience with SQL, reporting and dashboards.
• Translate clinician and administrator needs into technical specifications.
• Experience with SSRS, Tableau, or Pyramid.
• Knowledge of healthcare data and HIPAA practices.

Responsibilities

• Analyze complex BI data to inform business decisions and recommendations.
• Develop reports, dashboards and data extracts for department needs.
• Maintain data quality and governance across centralized models.
• Mentor analysts in content delivery and best practices.
• Collaborate with teams and stay updated on regulatory changes.

Skills

SQL queries

Data visualization

Analytics

Education

Bachelor's degree

Tools

SSRS

Tableau

Pyramid

Excel

Job description

Location:Fort Lauderdale, FloridaAt 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 BEHAVIOREducation 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 differentialDisclaimer: This job description is not intended, nor should it be construed to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with the job. It is intended to indicate the general nature and level of work performed by employees within this classification.Wages shown on independent job boards reflect market averages, not specific to any employer. We encourage candidates to talk to their Memorial Healthcare System recruiter to discuss actual pay rates, during the hiring process.Memorial Healthcare System is proud to be an equal opportunity employer committed to workplace diversity.Memorial Healthcare System recruits, hires and promotes qualified candidates for employment opportunities without regard to race, color, age, religion, gender, sexual orientation, national origin, veteran status, disability, genetic information, or any factor prohibited by law.We are proud to offer Veteran’s Preference to former military, reservists and military spouses (including widows and widowers). You must indicate your status on your application to take advantage of this program.Employment is subject to post offer, pre-placement assessment, including drug testing.If you need reasonable accommodation during the application process, please call 954-276-8340 (M-F, 8am-5pm) or email [e-mail]