Senior Business Intelligence Developer - FT - Days - MHS

Memorial Healthcare; United States; Vor Ort; USD 90.000 - 120.000; Vollzeit

Zusammenfassung

Memorial Healthcare System in Miramar, Florida is seeking a Data Warehouse/BI Analyst to analyze complex healthcare BI data and develop reports, dashboards, and extracts using Epic Clarity and other sources. This role covers the BI development lifecycle from data integration to quality assurance and delivery.

Progressive experience with T-SQL queries and SSMS/SSRS/SSIS is required, along with data modeling and visualization tools such as Power BI or Tableau.

Qualifikationen

• Four years of relevant healthcare BI experience.
• Experience with EPIC Clarity data models.
• Proficiency in SQL-based reporting and data warehousing concepts (SSMS/SSRS/SSIS).
• Knowledge of data profiling and data modeling.

Aufgaben

• Creates 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.
• Validates and delivers high quality data and BI solutions with minimal maintenance.
• Maintains and documents data sources/dashboards.
• Provides data analysis and reporting of patterns, insights, and trends to decision-makers.
• Develops and communicates dashboard visualizations to optimize data use.
• Provides performance monitoring and tuning for BI applications.
• Supports end users and leadership with data and insights.

Kenntnisse

Data modeling

Data normalization

ETL

Reporting & dashboarding

Accountability

Customer service

Standards of behavior

Training & development consulting

Ausbildung

Bachelor's degree in Information Technology

Tools

SSMS

SSRS

SSIS

EPIC Clarity data models

Jobbeschreibung

Location

Miramar, Florida

Summary

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

Leverage expertise in EHR data (from Epic and other community EHR providers) in the development of reports, dashboards and extracts. Develop models and algorithms to support contracting, required reporting and innovation in healthcare data.

Progressive experience writing T-SQL queries and stored procedures, including developing reports and extracts for customers using BI tools including SSMS, SSRS and SSIS. Advanced knowledge of database and data warehouse concepts and technologies, including data profiling and data modeling. Working knowledge with data visualization tools such as Tableau, Pyramid Analytics, or Power BI.

Responsibilities

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

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.

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.

Provides ongoing performance monitoring and tuning, for both new and existing, reporting and BI applications.

Supports end users and organizational leadership in obtaining meaningful data, analytics, visualizations and insights to assist with decision making and improve business operations.

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.

Competencies

ACCOUNTABILITY, CUSTOMER SERVICE, DATA MODELING & AGGREGATION, DATA NORMALIZATION AND LOAD, REPORTING & DASHBOARDING, RESPONDING TO CHANGE, STANDARDS OF BEHAVIOR, TRAINING AND DEVELOPMENT CONSULTING

Education and Certification Requirements

Bachelors: Information Technology (Required)

Additional Job Information

Complexity of Work: Requires critical thinking skills, decisive judgment and the ability to work with minimal supervision. Must be able to work in a stressful environment and take appropriate action. May require specialized knowledge in a business line. Required Work Experience: Four (4) years of relevant experience. Healthcare and Claims experience required if supporting Population Health. Other Information: Additional Education Info: Computer Science, or related field. Relevant work experience may substitute for education requirement.

Working Conditions and Physical Requirements

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

Shift

Primarily for office workers - not eligible for shift differential

Disclaimer

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]