Senior Business Intelligence Developer - FT - Days - MHS

CO010 Memorial Healthcare System; United States; Presencial; USD 90 000 - 110 000; Tempo integral

Resumo da oferta

Memorial Healthcare System is seeking a BI/Data Analyst to analyze complex BI data, build reports, dashboards and extracts, and support the Data Warehouse/BI development lifecycle. You will work with Epic Clarity data models and other systems to deliver actionable insights for contracting and operations.

The role requires 4+ years of healthcare data experience, strong SQL, and proficiency with visualization tools such as Tableau or Power BI.

Qualificações

• Requires Bachelor's degree in Information Technology.
• Four years of relevant experience.
• Healthcare analytics and Epic Clarity experience preferred.
• Develop reports/dashboards using BI tools (Tableau/Power BI).
• Strong SQL and data warehousing knowledge is required.

Responsabilidades

• Creates SQL stored procedures, views and functions with efficient code.
• Loads data into Data Warehouse from multiple sources into Data Marts.
• Delivers high-quality data and BI solutions with minimal incidents.
• Maintains documentation for data sources/dashboards.
• Performs data analysis and reports trends for decision-makers.
• Communicates dashboard recommendations to users for better data utility.

Conhecimentos

SQL & stored procedures

Data warehousing

Tableau

Power BI

SSMS/SSRS/SSIS

Epic Clarity

Data modeling

Data analysis

Formação académica

Bachelor's degree in Information Technology

Ferramentas

SSMS

SSRS

SSIS

Tableau

Power BI

Descrição da oferta de emprego

Location: Miramar, 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 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%

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.

Pay and Equity

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.

Equal Opportunity Statement

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

Veteran’s Preference

Be where care matters. At Memorial Healthcare System, we are dedicated to improving the health, well-being, and quality of life of the people entrusted to our care. This unwavering commitment to our service vision makes the difference and is the foundation of The Memorial Experience. Deeper Caring. Smarter Healthcare. Talk to our patients and their families about “Deeper Caring,” and they'll tell you stories about miracle babies, lives saved through sheer determination, and the comforting kindness of others. About people who advocated for the family’s best interests and cared for them in body, mind, and spirit. For our employees, “Smarter Healthcare” means constantly improving how we deliver care. It could be a new technology, a streamlined process, or a cutting-edge program leveraging our system strengths. But, no matter how you look at it, our service vision is integral to our culture today and what we strive to be tomorrow. We invite you to share in the Memorial Experience – where touching lives, lifting spirits, and healing the human body is our profession’s greatest privilege and reward. Be where you are valued.

Veteran’s Preference allows for the first choice in interviewing, hiring, retention, and promotion after deployment when all other applicant qualifications are equal. However, Veteran's Preference does not guarantee a job.

Who is eligible for Veteran’s Preference? We are proud to offer preference to internal and external applicants who identify within these categories:

• veterans
• disabled veterans
• spouse of a disabled veteran
• unremarried veteran widow/widower
• certain family members
• active reservists and members of the National Guard

What should I do if I am eligible for Veteran’s Preference? You must claim your Veteran’s Preference status on your application. If selected for a job, you must provide documentation regarding your status.

How does Memorial verify that someone is eligible for Veteran’s Preference? We require specific documentation as determined by the basis for which someone claims preference. For example, the documentation for a disabled veteran is different from the documentation required for the spouse of a veteran killed in the line of duty.

How often can an eligible person claim Veteran's Preference at Memorial? There is no limit to how often internal or external applicants can use preference when a job is posted externally on our career website or elsewhere.

What if there are two equally qualified, preference-eligible job applicants? In this case, the selection is based on the eligibility category in accordance with Florida law. First preference is given to:

• An honorably discharged veteran who has served on active duty and has a service-connected, compensable disability.
• A spouse of a person who has a total, permanent, service-connected disability and cannot qualify for employment.
• A spouse of a person missing in action, captured or forcibly detained or interned by a foreign government or power.

What do I do if I am denied Veteran's Preference? If you feel you have been unfairly denied Veteran’s Preference by Memorial Healthcare System, please contact [e-mail]. You may also file a complaint with the Florida Department of Veterans’ Affairs (FDVA).

By clicking on any of the following links, you will be leaving the Memorial career site to go to a third party site. Please note that we are not responsible for the content or accessibility of the PDF documents you download from that site. All of the links in this section will download PDFs that require Adobe Reader or compatible software to open and read the documents. If you need Adobe Reader, you can download it now.

Florida Civil Rights Act Equal Employment Opportunity is the Law (EEO) Family and Medical Leave Act (FMLA) Employee Polygraph Protection Act (EPPA) E-Verify™ Participation Notice – English Right To Work Notice – English E-Verify™ Participation Notice – Spanish Right To Work Notice – Spanish.

Memorial Healthcare System is subject to the Florida Public Records Law. All information provided in connection with your application for employment will be a public record and subject to release upon request, unless considered exempt or confidential.