Senior Business Intelligence Developer - FT - Days - DIO

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 eligibility, claims and 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 value based care.

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:

Uses historical data from available industry reports, public information, field reports or purchased source to extract insight using data analysis and modeling to inform business decisions.Responsible for creating and updating centralized data models using existing tools independently for complex data sets.Works closely with less experienced business intelligence team members to design specifications for new centralized data models or updates to existing models.Uses data from all sources to inform decisions, identify trends and drive insights.Builds Extract, Transform and Load (ETL) processes to normalize, apply business rules, and load data into tabular and multi-dimensional models within the business intelligence platform.Coordinates a curriculum for coaching and training junior-level employees as well as customers in the use of business intelligence tools to enhance business decision-making capability.Identifies upcoming workflow changes or software upgrades that may impact reports, dashboards or centralized data models.Leverages advanced analytical technologies within the business intelligence structure to assist with implementation, maintenance and support of data methodologies, outcomes, and insights.Conducts data discovery, data profiling and data modeling for complex data sets to gather insights and identify trends.Leverages expertise to troubleshoot complex issues, perform root cause analysis, and take proactive corrective measures.Develop models and algorithms to support required reporting and innovationWorks with assigned application teams to stay up-to-date with their data models, applications, tools, workflows and regulations.

Competencies:

ACCOUNTABILITY, ANALYSIS AND DECISION MAKING, CONTENT PRESENTATION AND DELIVERY, CUSTOMER SERVICE, DATA EXTRACTION AND TRANSFER, DATA MODELING & AGGREGATION, DATA WAREHOUSING - BI, DATA WAREHOUSING - SR BI, EFFECTIVE COMMUNICATION, IT CUSTOMER SUPPORT, LEADING EFFECTIVE PRESENTATIONS, PROBLEM SOLVING, REPORTING AND DASHBOARDING, RESPONDING TO CHANGE, STANDARDS OF BEHAVIOR, SYSTEMS ARCHITECTURE, TEAM WORK

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, 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 954-276-8340 (M-F, 8am-5pm) or email TalentAcquisitionCenter@mhs.net