This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Developing 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.
Job Responsibility
Developing 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
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
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
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
Requirements
Bachelor's: Computer Science
Minimum of seven (7) years’ experience in a healthcare setting with experience in finance, business intelligence, or clinical systems
A Master’s degree with five (5) years of experience in a healthcare setting with experience in finance, business intelligence, or clinical systems in lieu of seven (7) years of experience with a Bachelor’s degree
High level of expertise with SQL or other database, analytics software, and BI tools
Knowledge of multiple Epic data models and certification in at least one Epic module plus Clarity/Caboodle Data Model Certification or proficiency