Lead Business Intelligence Analyst - Epic Clarity - FT - Days - DIO

Business Intelligence AnalystLocation: Hollywood, 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.SummaryDeveloping SQL queries to extract data from Epic Clarity and/or Caboodle Data Warehouse and creating clinical reports and dashboards using Tableau or Power BI. Performs in a lead role to provide information to end users which helps them optimize their clinical, financial and operational results. This role is responsible for all stages of business intelligence (BI) cycle: understanding business objective, gathering business requirements and translating them into data requirements, designing and developing reports or dashboards (code and visualization), scheduling and deployment of business intelligence components in accordance with supplied standards and best practices, and completing accurate and timely documentation. Collaborates with business and technology departments to understand system data and its use, data analysis and validation, and providing support around the data and how it is integrated. Monitors production systems for issues and resolves issues or elevates them for resolution when necessary.ResponsibilitiesCreates SQL stored procedures, views and functions using best practices and efficient code. Loads data into Data Warehouse by extracting complex data from multiple sources into business-centric Data Marts. Provides understanding of the data in the organization, performing analysis and report writing with key sets of information from the EPIC Clarity data models, data warehouses, and multiple other systems throughout the organization. Supports end users and organizational leadership in obtaining meaningful data, analytics, visualizations and insights to assist with decision making and improve business operations. Provides ongoing performance monitoring and tuning for both new and existing reporting and BI applications. Provides quantitative and qualitative data analysis and reporting of patterns, insights, and trends to decision-makers. Develops and communicates recommendations to the end users on dashboard visualizations to optimize effective and efficient use of data within the specifications of the request, and outside the specifications of the request to enhance the utility of the data/dashboard. Validates and delivers high quality data and BI solutions that enable user functionality with minimal ongoing maintenance and a low volume of production incidents. Maintains and develops documentation for all data sources/dashboards.CompetenciesACCOUNTABILITY, CUSTOMER SERVICE, DATA MODELING & AGGREGATION, DATA NORMALIZATION AND LOAD, REPORTING & DASHBOARDING, RESPONDING TO CHANGE, STANDARDS OF BEHAVIOR, TRAINING AND DEVELOPMENT CONSULTINGEducation and Certification RequirementsBachelors: Computer Science (Required)Working Conditions and Physical RequirementsBending 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, gender identity or expression, 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 View phone number on click.appcast.io (M-F, 8am-5pm) or email View email address on click.appcast.io