Business Intel. Developer (Epic Cogito, Clarity & Caboodle) at OU Health

Oklahoma City, Oklahoma, United States -

Full Time

Start Date

Immediate

Expiry Date

02 Aug, 26

Salary

0.0

Posted On

04 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Epic Cogito, Clarity Data Model, Caboodle Data Model, Tableau, PowerBI, Data Analysis, Dashboard Development, Reporting Workbench, SlicerDicer, Data Modeling, Relational Databases, Healthcare IT, EHR Systems, Performance Tuning, Technical Documentation

Industry

Hospitals and Health Care

Description

Position Title: Business Intel. Developer (Epic Cogito, Clarity & Caboodle) Department: IT Care Delivery Applications Job Description: The Business Intelligence Developer II creates analytics content based upon specifications from end-user data needs or those communicated by Business Intelligence colleagues to support end users and leadership. The BID II possesses a strong understanding of the underlying data model and is skillful in development of data queries and data interaction. The BID II is responsible for responsible for designing, building, and maintaining data analysis tools and platforms that translate raw data into actionable insights for businesses. They accomplish this by development and maintenance of paginated reports, datasets, dashboards, reports, and visualizations within Epic and third-party tools (e.g. PowerBI, Tableau, etc.). Essential Responsibilities Responsibilities listed in this section are core to the position. Inability to perform these responsibilities with or without an accommodation may result in disqualification from the position. Develops moderate to complex SQL solutions for creation and maintenance of analytics assets Configures and tests EHR- (such as Epic) released and Foundation System content for applications (such as Reporting Workbench, SlicerDicer data models, Radar dashboards, and Cogito SQL) Designs and creates custom content to display EHR (such as Epic) data from databases (such as Chronicles, Clarity, and Caboodle) in organizationally designated tools (such as EHR, Tableau, PowerBI) Distributes analytics content to data consumers and is able to anticipate needs with minimal prompting Provides thorough education of tool/data usage to end users without support Provides development support for projects and can leads projects with some support. Reviews peer reports for validity Performs moderate to complex peer review of code (such as SQL, DAX) Works with subject matter experts to understand the needs of data consumers Responds with professional communication to triage and/or resolve requests from end users independently Tests analytics build in specified testing environments, including designing basic test scripts when appropriate Reviewing upgrade documentation for database (such as Clarity and Caboodle) features Maintains analytics catalog and metadata records Develops and maintains strong operational relationships General Responsibilities Performs other duties as assigned. Minimum Qualifications Education Requirements: Bachelor's Degree required. Experience Requirements: 3-5 years of experience in analytics (Business Intelligence, Data Engineering, Data Science, etc.) including at least 1 year experience using SQL, relational databases and integration tools required. Healthcare IT experience preferred in analyzing, programming, designing, testing, and/or implementing computer-based systems. Prior experience working with an accounts receivable system or prior experience working with an EMR system is preferred. License/Certification/Registration Requirements Cogito Fundamentals Cogito Tools Administration Clarity Data Model Caboodle Data Model Access, Clinical, and/or Revenue Data Model(s) For preferred items below, OU Health may require incumbents to complete additional trainings, including those noted below, as part of their job requirements. Accreditation(s)/Certification(s)/License(s)/Registration(s), as appropriate, will be required no more than three months after course completion. Data Visualization tools (e.g. Tableau, PowerBI, etc.) Additional Accreditation(s)/Certification(s)/License(s)/Registration(s) as requested to support evolving businesses Knowledge/Skills/Abilities Required: Ability to communicate effectively orally and in writing with all business partners across the enterprise. Mentors junior level developers on advancing their communication effectiveness. Ability to effectively translate all complexities of customers requests or stated needs into meaningful business requirements with no support, advises junior level developers in this effort. Participates and contributes to development of designing and implementing workflow processes and standards for the team. Critical thinking and an analytical mindset with demonstrated ability to both rapidly synthesize problems and generate logical, solutions-focused responses. Proficient SQL developer with understanding of relational database concepts and has competence using related BI tools (e.g. Microsoft SQL Server and associated tools). Engages in junior level developer peer review of code and tool development, both providing guidance to those junior and incorporating new learning from senior level developers with demonstrated growth of coding skillset. Proficiency in design, build, and maintain data analysis tools, translate raw data into actionable insights for business. Uses analytics assets (e.g. metrics, dashboards, reports, self-service analysis tools, etc.), both of general industry standard analytics tools and those inline of an Electronic Health Record (EHR) such as Epic, for enterprise use. Advises and mentor junior level developers in the same. Proficient understanding of relational database concepts, creating data structures, and data modeling. Engages in advancing knowledge to execute progressively complex development skills (such as constructing SQL stored procedures, views, and functions, including performance tuning, indexing and design patterns). Proficient understanding of using and/or rapidly assimilating knowledge of various third-party tools (e.g. Tableau, PowerBI, etc.) and demonstrates progressively maturing skill navigating complex relationships across multiple departments and businesses. Solves moderate to advanced complexity problems and provides guidance to more junior developers. Strong understanding of healthcare business process and technology preferred. Intermediate understanding of clinical workflows and terminology preferred. Prior experience working with an EHR and/or accounts receivable system is preferred. Ability to effectively work independently and within teams. Proficient knowledge of IT solutions and interfacing preferred. Must be able to drive personal vehicle to assigned sites to complete work Must be able to travel in state and out of state on occasion. #cb Current OU Health Employees - Please click HERE to login. OU Health is an equal opportunity employer. We offer a comprehensive benefits package, including PTO, 401(k), medical and dental plans, and many more. We know that a total benefits and compensation package, designed to meet your specific needs both inside and outside of the work environment, create peace of mind for you and your family. OU Health is the state’s only comprehensive academic health system of hospitals, clinics and centers of excellence. With 11,000 employees and more than 1,300 physicians and advanced practice providers, OU Health is home to Oklahoma’s largest doctor network with a complete range of specialty care. OU Health serves Oklahoma and the region with the state’s only freestanding children’s hospital, the only National Cancer Institute-Designated OU Health Stephenson Cancer Center, Oklahoma’s flagship hospital, which serves as the state’s only Level 1 trauma center and Edmond Medical Center in the heart of the Edmond Community. Becker’s Hospital Review named University of Oklahoma Medical Center one of the 100 Great Hospitals in America for 2020. OU Health’s oncology program at OU Health Stephenson Cancer Center was named Oklahoma’s top facility for cancer care by U.S. News & World Report in its 2020-21 rankings. OU Health also was ranked by U.S. News & World Report as high performing in these specialties: Colon Surgery, COPD and Congestive Heart Failure. OU Health’s mission is to lead healthcare in patient care, education and research. Experts in prevention, treatment and cures, our team works to improve lives through innovation in medical care, education and research, while investing in the people, technologies and facilities that will enable us to achieve our goals. We are seeking individuals who have a passion and talent for caring for others. By joining our team, you will provide quality health care to our community through the work you do every day. We provide clinical and non-clinical opportunities to further your career and we invite you to explore our available positions. Equal employment opportunities are provided to all employees and applicants for employment without regard to race, color, religion, gender, national origin, age, disability, sexual orientation, gender identity, genetic information or protected veteran status in accordance with applicable federal laws. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, transfer, leaves of absence, compensation, and training. Reasonable accommodations are made to the known physical and mental limitations of qualified individuals with disabilities.

Responsibilities

The Business Intelligence Developer designs, builds, and maintains analytics content and data tools to translate raw data into actionable insights. They are responsible for developing SQL solutions, configuring EHR content, and providing technical support and education to end users.