Business Intelligence Developer

Reason for this need : UCLA Health will have a new health plan starting 2025. We will include Medicare Advantage plans only as part of this health plan line of business. We are in the process of building out the reporting for this line of business and thats the reason we need this person.

Required Experience :

CMS claims submission and HCC coding experience. They need to understand the 837 process with MOR MAO and MMR files and condition capture.

Risk Adjustment model and Claims submission.

3 plus years of Tapestry experience (cert is a plus)

Strong SQL Datamart

5 plus years of Medicare Advantage experience

risk adjustment is a plus

Epic Clarity Data Model certification in one or more modules (EpicCare Inpatient Hospital Billing Prelude ADT Radiant Willow Optime) or to be obtained within 120 days of hire.

SUMMARY STATEMENT :

The BI Developer is responsible for leading the development of reporting and analytics solutions for UCLAs electronic health record (EHR) system by gathering business needs documenting requirements identifying appropriate data sources developing reports and delivering them to stakeholders. The BI Developer takes direction from and collaborates with the Assistant Director of Decision Support Services and the Senior Director Finance Operations on work priorities and manages the resolution of escalated issues. The BI Developer will perform in depth and precise investigation and documentation of future-state reporting specifications and application reporting functionality. The BI Developer must achieve in-depth knowledge of relevant software applications as well as understand policies procedures and constraints.

TYPE OF SUPERVISION RECEIVED :

The BI Developer receives overall objectives deliverables and priorities from the Assistant Director Decision Support Services and the Senior Director Financial Operations. The manager and team are expected to determine the most effective way to accomplish assigned tasks within the timeframes allowed and to work independently with minimal supervision.

KEY RESPONSIBILITIES

Meet with stakeholders to understand business needs for data requests. Gather requirements document clarify interpret specifications and review for completeness and accuracy.

Design develop validate and perform thorough functional testing of extracts reports visualization dashboards utilizing analytics tools and data sources such as including but not limited to : Microsoft Excel Tableau WebI SSRS Power BI Caboodle Clarity Reporting Workbench Radar Dashboards Universes Registry Framework and Data Marts SlicerDicer and other Business Intelligence Tools.

Collaborate with interdisciplinary teams including faculty practice team members administrators IT staff and vendors. Effectively communicate technical concepts and analytical findings to both technical and non-technical stakeholders facilitating collaboration and informed decision-making.

Monitor performance of BI outputs and take corrective action to optimize or improve the performance when necessary.

Gather assess and interpret substantial amounts of healthcare data encompassing electronic health records clinical data financial data and pertinent information. Offer insights and suggestions derived from the data analysis and interpretation.

Streamline documentation scheduling billing and other administrative tasks ultimately enhancing operational efficiency and reducing errors.

Provide training and support to healthcare staff on the use of health informatics tools and systems. Create educational materials conduct workshops and offer guidance to ensure proper utilization and understanding of dashboards reports and other tools enabled by the team.

Participate in application validation and QA efforts as they pertain to data metrics and analytics solutions creation and execution.

Manage the inventory of BI objects and outputs. Assure that the metadata used for the Analytics Catalog is meaningful standardized complete accurate and up to date.

Manage the data model for reporting for assigned Epic applications and / or business lines.

o Manage the inventory of Clarity & Caboodle objects used for both published and ad hoc analytics. Assure that all object metadata is meaningful standardized complete accurate and up to date.

Manage the measures and metrics for assigned Epic applications and / or business lines. Assure that the metadata used for the Measures and Metrics catalog is meaningful standardized complete accurate and up to date. Note the content maintained in the Epic Metrics Catalog and use that as an anchor for UCLA metrics.

Review upgrade documentation related to analytics tools and content determine the best implementation approach. Evaluate anticipate and communicate risks to existing BI outputs and processes and recommend ways to mitigate those risks.

GENERAL RESPONSIBILITIES

Work closely and collaboratively with end users Application team Epic TSs Super Users Training team ISS support fellow team members and other stakeholders to ensure the right reporting tools are used to maximize value to end users for reporting and analytics.

Work with fellow team members and end-users to resolve problems promptly

o Takes the proper initiative to meet the expectations and needs of the user base

o Completes tasks with quality and within the expected timeframe

o Follows through and follows up on tasks or requests (from end to end)

Maintains a high level of professionalism

o Prompt in attendance of meetings

o Adequately prepared for meetings materials have been adequately prepared presentation is clear concise and professional

o Maintains a good work ethic exhibits attitude of respect and integrity toward others.

o Manages personal work assignments and priorities

o Communicate clearly and foster good relationship and partnership and provide input and support to other team members within FPG.

Support and champion FPG enterprise strategy with regards to data analytics and informatics.

UCLA C-I-CARE / Patient Experience Practices : MY COMMITMENT TO CARE

Observe and practice all the Service Standards listed in the World Class Practices (which I have read and signed).

o Practice C-I-CARE when interacting with patients their families visitors or internal customers.

o Connect with the patient and family members by addressing them as Mr. / Ms. or by the name that they prefer.

o Introduce yourself and your role.

o Communicate what you are going to do how long it is going to take and how it will impact the patient.

o Ask and anticipate patient and / or family needs questions or concerns.

o Respond to patient and / or family questions and requests with immediacy.

o Exit courteously and / or with an explanation of what will come next (or when you will be back to check on them).

o Practice C-I-CARE phone etiquette during all phone interactions

Always exercise courtesy whenever patients family members visitors and co-workers are present.

o Respect privacy and dignity of our patients family members visitors and co-workers.

o Maintain professionalism in the presence of patients their families visitors and co-workers

Observe departmental Patient Experience plan competencies and practices.

o Act as a role model verbally and behaviorally demonstrating skill enthusiasm positive problem solving commitment and loyalty to the profession and the organization.

o Participate in positive problem solving by providing suggestions and possible solutions to identified concerns / problems in the work place.

Comply with Health System Workplace Conduct Policy

o Engaging in disruptive behaviors that interfere with or prevent normal work functions or compromise patient safety including passive or active behaviors will not be tolerated as stated in the HS Workplace Conduct Policy.

Comply with Health System Dress Code Policy and practices

INSTITUTIONAL AND / OR PROFESSIONAL STANDARDS

Comply with HIPAA and Confidentiality Policies and Procedures as they apply to the job

Comply with Department of Public Health (DPH) The Joint Commission and other accreditation and regulatory agencies standards

Adhere to all Hospital Policies and Procedures

Knowledge and adherence to Infection Control and Environment of Care Guidelines and Procedures as described in the annual education module

PERFORMANCE IMPROVEMENT

Adhere to current organizational Performance Improvement priorities

Participate in coordination activities through meetings data collection and dashboard data collection

Make recommendations and take actions to improve structure system or outcomes

OTHER DUTIES

Carry out tasks related to FPG projects that are relevant to Decision Support business intelligence and analytics domains.

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Full Time

Experience : years

Vacancy : 1