Columbia University
EPIC Business Intelligence Dev
Columbia University, New York, New York, us, 10261
Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: RegularEnd Date if Temporary:Hours Per Week: 35Standard Work Schedule: M-F, 9AM-5PMBuilding: 400 Kelby street, Fort Lee NJ 07024Salary Range: $115,000-$125,000.00
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Position SummaryReporting to the Associate Director, Revenue Cycle, the Epic Business Intelligence Developer (BID) is responsible for all stages of the business intelligence cycle: understanding business objectives, collecting 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.This position supports transforming data into actionable intelligence and insights to provide information that enhances decision-making abilities to derive and support process improvements. The position partners with business leaders to understand analyses and the impact of cause-and-effect relationships by utilizing established data sources, Data Warehouses, and Excel tables to collect, integrate, extract, analyze, and present information in reports, dashboards, and visualizations. These activities are undertaken and executed to support organizational goals and to partner with management, project champions, and process owners to deliver results.ResponsibilitiesOperationsMaintains an in-depth knowledge of client/department business strategies, processes, and services to aid in data interpretationAnalyze clinical, business, and operational processes, workflows, and source systems. Identify the data sources, understand the sources systems and the workflows that feed themCreates and maintains custom reports on key business areas and indicators to identify and track trends, process improvement efforts, and other business outcomesDemonstrates analytical critical thinking skills for process development or problem resolution. Generate meaningful and insightful analytics from internal operational data, enabling business leaders to make data-driven decisionsCreate summary reports, data extracts, and other financial analyses for management and external vendors from disparate systemsConceptualize and build creative data visualization dashboards to effectively communicate key business insights and tell a compelling 'story'Support ad hoc questions and analysesAssists in the development of standardized data collection, the use of benchmark data and reports across system hospitalsDevelop an in-depth understanding of Mission's key performance indicators (KPIs) and develop repeatable, efficient processes to measure and forecast these metricsOperates under limited guidance and work assignments involve moderately complex to complex issues where the analysis of situations or data requires an in-depth evaluation of variable factorsMakes recommendations for changes in the current departmental systems and processes and contributes ideas and suggestions for solutions to the current system's problemsResponds to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action and information appropriate management
TechnicalPull, consolidate and manipulate data from multiple large data sets, analyze the results, and build reports, dashboards, and presentationsCreate/ Modify SQL queries using Epic's Clarity databaseAdjust query outputs in Excel, add formulas, charts, and graphs to summarize data and show underlying trends.Perform ad-hoc data analysis using SQL, BI, Excel, and other tools as necessaryEvaluate, trouble-shoots and lead root-cause analysis for any errors or gaps identified during the development/validation of data/reportsContinually develop professional skills, and maintain Epic certifications where appropriate, including obtaining additional certifications in other modules
StrategyUtilizes innovative thinking and tools for the optimization of processes, reports, and tasksIdentifies best practices for report optimization and establishes mechanisms to share expertise and knowledge amongst peersProvides outstanding client service and contributes to FPO's mission of utilizing information technology to improve patient careFacilitates system and operational process optimization through data-driven analysis to achieve competitive excellence measured against industry benchmarks
PeopleProvides guidance and support to Optimization team Revenue Cycle AnalystsPartners with the CUIMC team to develop, and validate necessary data structures, and support user acceptance testing(UAT) when necessaryObtains feedback from key stakeholders in departments, central business office & vendors to impact reporting-related activitiesDevelops and maintains excellent working relationships with Columbia University Departments, EPICTogether, CUIMC, and vendors.
ComplianceRepresents the CRO Management Team on committees, task forces, and work groups. Negotiates workable compromise solutions to complex problems between the FPO, CRO, and other departments, outside vendors, etc.Conforms to all applicable HIPAA, Billing Compliance, and safety policies and guidelines.Performs other duties and responsibilities as assigned by the Chief Revenue Cycle Officer and Directors of the CRO.
Minimum QualificationsRequires a bachelor's degree or equivalent, plus a minimum of 4 years related experienceAn equivalent combination of education and experience may be consideredExperience within a multi-facility healthcare system using EPICCertification and experience in Epic Clarity/Caboodle Data ModelsSQL development experienceExperience with data visualization tools (Qlik Sense, Tableau, PowerBI, etc.)Experience with Cogito Tools (Reporting Workbench, Radar, SlicerDicer)Strong Analytical background with previous experience in Epic Clarity Data Model, Oracle SQL Database, and Revenue Cycle (PB) to support BI Development out of EpicProvide service reporting solutions to empower customers to leverage data to make informed decisionAbility to combine data from multiple sources and understand the limitations of various data sourcesAbility to work in high-pressure situations, meet deadlines, multi-task, and be highly adaptable to meet changing needs in a fast-paced environmentAbility to communicate effectively in both oral and written form. Must be able to create and deliver high-level presentations for senior leadership and other organizational stakeholdersAbility to juggle several complex projects, while also handling ad hoc requestsAttention to detail, but with an ability to understand the big picture view and understand when projects or efforts have conflicting objectivesAbility to build and maintain relationships across multiple clients and vendorsMust be a motivated individual with a positive and exceptional work ethic
Preferred QualificationsMaster's Degree or Masters candidate preferredEpic Certification and or Knowledge in relevant subject areas (Cogito, Caboodle, Slicer Dicer, Cadence, or other relevant revenue cycle certifications)Experience with EPIC workflowsProficiency in one or more of the following: insurance billing, collections, denials management as it pertains to commercial, managed care, government, managed care lines of businessCertification in EPIC Clarity; knowledge of Epic PB Module, Microsoft Office Suite, Power BI, or other data visualization tools or self
Other RequirementsPatient Facing CompetenciesMinimum Proficiency LevelAccountability & Self-ManagementLevel 3 - IntermediateAdaptability to Change & Learning AgilityLevel 3 - IntermediateCommunicationLevel 3 - IntermediateCustomer Service & Patient-CenteredLevel 3 - IntermediateEmotional IntelligenceLevel 3 - IntermediateProblem Solving & Decision MakingLevel 3 - IntermediateProductivity & Time ManagementLevel 3 - IntermediateTeamwork & CollaborationLevel 3 - IntermediateQuality, Patient & Workplace SafetyLevel 3 - IntermediateLeadership CompetenciesMinimum Proficiency LevelBusiness Acumen & Vision DriverLevel 2 - BasicPerformance ManagementLevel 3 - IntermediateInnovation & Organizational DevelopmentLevel 2 - BasicEqual Opportunity Employer / Disability / VeteranColumbia University is committed to the hiring of qualified local residents.
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Position SummaryReporting to the Associate Director, Revenue Cycle, the Epic Business Intelligence Developer (BID) is responsible for all stages of the business intelligence cycle: understanding business objectives, collecting 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.This position supports transforming data into actionable intelligence and insights to provide information that enhances decision-making abilities to derive and support process improvements. The position partners with business leaders to understand analyses and the impact of cause-and-effect relationships by utilizing established data sources, Data Warehouses, and Excel tables to collect, integrate, extract, analyze, and present information in reports, dashboards, and visualizations. These activities are undertaken and executed to support organizational goals and to partner with management, project champions, and process owners to deliver results.ResponsibilitiesOperationsMaintains an in-depth knowledge of client/department business strategies, processes, and services to aid in data interpretationAnalyze clinical, business, and operational processes, workflows, and source systems. Identify the data sources, understand the sources systems and the workflows that feed themCreates and maintains custom reports on key business areas and indicators to identify and track trends, process improvement efforts, and other business outcomesDemonstrates analytical critical thinking skills for process development or problem resolution. Generate meaningful and insightful analytics from internal operational data, enabling business leaders to make data-driven decisionsCreate summary reports, data extracts, and other financial analyses for management and external vendors from disparate systemsConceptualize and build creative data visualization dashboards to effectively communicate key business insights and tell a compelling 'story'Support ad hoc questions and analysesAssists in the development of standardized data collection, the use of benchmark data and reports across system hospitalsDevelop an in-depth understanding of Mission's key performance indicators (KPIs) and develop repeatable, efficient processes to measure and forecast these metricsOperates under limited guidance and work assignments involve moderately complex to complex issues where the analysis of situations or data requires an in-depth evaluation of variable factorsMakes recommendations for changes in the current departmental systems and processes and contributes ideas and suggestions for solutions to the current system's problemsResponds to urgent, impromptu, and unplanned situations by assessing their level of importance, instituting appropriate action and information appropriate management
TechnicalPull, consolidate and manipulate data from multiple large data sets, analyze the results, and build reports, dashboards, and presentationsCreate/ Modify SQL queries using Epic's Clarity databaseAdjust query outputs in Excel, add formulas, charts, and graphs to summarize data and show underlying trends.Perform ad-hoc data analysis using SQL, BI, Excel, and other tools as necessaryEvaluate, trouble-shoots and lead root-cause analysis for any errors or gaps identified during the development/validation of data/reportsContinually develop professional skills, and maintain Epic certifications where appropriate, including obtaining additional certifications in other modules
StrategyUtilizes innovative thinking and tools for the optimization of processes, reports, and tasksIdentifies best practices for report optimization and establishes mechanisms to share expertise and knowledge amongst peersProvides outstanding client service and contributes to FPO's mission of utilizing information technology to improve patient careFacilitates system and operational process optimization through data-driven analysis to achieve competitive excellence measured against industry benchmarks
PeopleProvides guidance and support to Optimization team Revenue Cycle AnalystsPartners with the CUIMC team to develop, and validate necessary data structures, and support user acceptance testing(UAT) when necessaryObtains feedback from key stakeholders in departments, central business office & vendors to impact reporting-related activitiesDevelops and maintains excellent working relationships with Columbia University Departments, EPICTogether, CUIMC, and vendors.
ComplianceRepresents the CRO Management Team on committees, task forces, and work groups. Negotiates workable compromise solutions to complex problems between the FPO, CRO, and other departments, outside vendors, etc.Conforms to all applicable HIPAA, Billing Compliance, and safety policies and guidelines.Performs other duties and responsibilities as assigned by the Chief Revenue Cycle Officer and Directors of the CRO.
Minimum QualificationsRequires a bachelor's degree or equivalent, plus a minimum of 4 years related experienceAn equivalent combination of education and experience may be consideredExperience within a multi-facility healthcare system using EPICCertification and experience in Epic Clarity/Caboodle Data ModelsSQL development experienceExperience with data visualization tools (Qlik Sense, Tableau, PowerBI, etc.)Experience with Cogito Tools (Reporting Workbench, Radar, SlicerDicer)Strong Analytical background with previous experience in Epic Clarity Data Model, Oracle SQL Database, and Revenue Cycle (PB) to support BI Development out of EpicProvide service reporting solutions to empower customers to leverage data to make informed decisionAbility to combine data from multiple sources and understand the limitations of various data sourcesAbility to work in high-pressure situations, meet deadlines, multi-task, and be highly adaptable to meet changing needs in a fast-paced environmentAbility to communicate effectively in both oral and written form. Must be able to create and deliver high-level presentations for senior leadership and other organizational stakeholdersAbility to juggle several complex projects, while also handling ad hoc requestsAttention to detail, but with an ability to understand the big picture view and understand when projects or efforts have conflicting objectivesAbility to build and maintain relationships across multiple clients and vendorsMust be a motivated individual with a positive and exceptional work ethic
Preferred QualificationsMaster's Degree or Masters candidate preferredEpic Certification and or Knowledge in relevant subject areas (Cogito, Caboodle, Slicer Dicer, Cadence, or other relevant revenue cycle certifications)Experience with EPIC workflowsProficiency in one or more of the following: insurance billing, collections, denials management as it pertains to commercial, managed care, government, managed care lines of businessCertification in EPIC Clarity; knowledge of Epic PB Module, Microsoft Office Suite, Power BI, or other data visualization tools or self
Other RequirementsPatient Facing CompetenciesMinimum Proficiency LevelAccountability & Self-ManagementLevel 3 - IntermediateAdaptability to Change & Learning AgilityLevel 3 - IntermediateCommunicationLevel 3 - IntermediateCustomer Service & Patient-CenteredLevel 3 - IntermediateEmotional IntelligenceLevel 3 - IntermediateProblem Solving & Decision MakingLevel 3 - IntermediateProductivity & Time ManagementLevel 3 - IntermediateTeamwork & CollaborationLevel 3 - IntermediateQuality, Patient & Workplace SafetyLevel 3 - IntermediateLeadership CompetenciesMinimum Proficiency LevelBusiness Acumen & Vision DriverLevel 2 - BasicPerformance ManagementLevel 3 - IntermediateInnovation & Organizational DevelopmentLevel 2 - BasicEqual Opportunity Employer / Disability / VeteranColumbia University is committed to the hiring of qualified local residents.