Business Intelligence Developer

Primary Objective

Business Intelligence Developers (BID) are responsible for analyzing, providing specifications for, and writing individual reports for assigned applications to support the needs of end users, senior leadership, and the Epic project team. This position serves as the primary reporting resource for the Epic Cogito application and have the responsibility for system support maintenance, analysis, design, and change control of all reporting components used to build and manage CEENTA’s reporting.

Essential Functions

• Collaborate with Subject Matter Experts and members of leadership to gather, analyze, and document BI requirements
• Assesses reporting needs to Epic customers through investigations, analysis and evaluation to create desired reports. Receives and documents formal requests from customer including specifications (layout, calculations, data source, etc.) Evaluates requests for completeness and if needed works with customer to finalize request.
• Define report requirements; design/develop/test/install/implements report-based programs; report programming designs; and code/test/debug/document system scripts, programs, and reports in application, web, and database environments. Design, code, test, and maintain BI reporting and analytics objects, including extracts, utilizing industry best practices
• Maintain a high level of awareness of the current and future BI technologies and best practices and fully understand the various organizational structures of CEENTA and their unique requirements. Perform project planning related to BI solutions development tasks including effort and completion date estimates. Obtain and transfer knowledge appropriately when new software or hardware are implemented.
• Responsible for maintaining data integrity and the ongoing quality control of delivered reports. Validates system build/reports designs and performs audit and report findings of security and data controls.
• Work with external organizations and third-party vendors to securely extract and share data.
• Designs and documents the general functional requirements and detailed technical specifications for a report/database.
• Validate model system reports and identify advanced reporting needs with report consumers.

• Collaborate and partner with executive leadership, shareholders, and leaders within information systems, clinic operations, management, and reporting. Document main points, issues, and key decisions.
• Ability to meet the physical and mental demands of the position.
• The ability to work on-site.
• Predictable, reliable, and prompt attendance.

Skills and Abilities

• In-depth knowledge and experience with relational database concepts and query tools. Sound knowledge of SQL tuning and data extraction methodologies. Ability to use OLAP and OLTP technologies along with knowledge of data warehouses/data stores and data marts to execute SQL query techniques
• Strong background in programming, systems analysis, design, and problem solving.
• Extensive knowledge of reporting programs and tools reports creation and maintenance including Epic Reporting Workbench, Epic Clarity, Chronicles, and Crystal Reporting writing will be utilized on the Reporting Team.
• Demonstrates the ability to build relationships and effectively communicate with the project team, and key clinical stakeholders, including business services, nurses and physicians.  Works closely and collaboratively with other project team members including business and clinical leaders
• Experience organizing and running multiple projects required.
• Can provide regular status updates to project lead/manager.
• Strong organization, analysis and problem-solving skills required, with an emphasis on attention to detail and the ability to work on multiple projects simultaneously.
• Approaches problems constructively by focusing on how to move the project forward.
• Possesses strong interpersonal skills and effective communication skills, written and oral.
• Demonstrates the ability to adapt to project changes related to scope, schedule, workflow, and system utilization.
• Excellent business analytical skills and general knowledge of statistics.
• Ability to adapt to a changing environment, problem solve and develop solutions. Strong documentation and communication skills.
• Experience with Microsoft Office or similar software required.

Core Competencies

• Data Management and Informatics
• Principles of Information Technology
• Complex Problem Solving
• Active Learning
• Information Monitoring
• Databases and Applications

Clinical Competencies

N/A

Training Period

Epic certifications require either in-person (Verona, WI) or virtual classroom training through Epic Systems. Most certifications require the trainee to submit a project and pass an exam. Staff will have 3 attempts to pass each exam.

Cogito Team Members should expect to become proficient in their application area within 6 months. Full competency is expected within 12-18 months. Analysts are also expected to be familiar with CEENTA workflows and standards within 6 months.

Accountability

Our mission is to be the premier eye, ear, nose, and throat group providing comprehensive, quality, and ethical healthcare to all in the Carolinas; to provide a favorable environment for the delivery of healthcare; and to provide for the wellbeing of the physicians and the employees of Charlotte Eye Ear Nose & Throat Associates, P.A.

The BI Developer oversees developing, deploying, and maintaining BI interfaces which insures that CEENTA management and providers have timely access to accurate data to make informed decisions which improves the delivery of care to CEENTA’s patients.

Education

Bachelor’s degree from an accredited college or university with a concentration in Computer Science, Business Administration, Health Information Management, or a related field.

Experience

Must have at least two (2) years of full-time work experience in business, healthcare, or systems analysis, business or healthcare administration, or a related area. Two (2) years of Epic Cogito experience preferred. General healthcare experience preferred.

Certificates, Licenses, Registrations

Epic certifications preferred, but not required for hire; must be obtained within six (6) months of hire:

• Epic Cogito Fundamentals
• Epic Caboodle Data Model
• Epic Clarity Data Model
• Additional Epic module or technology certifications are advantageous

Work Environment

This is a traditional office-oriented role working with a standard setup of technology and tools. The in-office environment supports focused, analytical work while fostering collaboration and communication. Remote work environments should provide a similar environment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this role.

Supervisory Responsibilities

None.  Matrixed reporting to the Director of Financial Planning & Analysis and Manager of Enterprise Applications

Position Type and Expected Hours of Work

• Salaried exempt
• Full-time; Monday – Friday general business hours (Eastern time)
• Limited evening/weekend work may be required during biannual system upgrades
• Position is eligible for hybrid and fully remote work, subject to a probationary period
• Employee must reside in North Carolina or South Carolina

Physical, Mental and Other Requirements

Physical Demands:

• Sitting in front of computer for long hours.

Mental Demands:

• Mathematical Skills: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions and decimals, ability to apply compute rates and percentage and the ability to draw and interpret bar graphs from data. 
• Reasoning Ability: Ability to apply common sense understanding to carry out detailed but uninvolved written or oral instructions. Ability to deal with problems involving a few concrete variables in standardized situations.
• Self-Sufficiency: Ability to work under pressure, thrive in a fast-paced environment, use discretion and sensitivity, and work alone for long stretches of time.

Other Requirements:  

• Active & current driver’s license
• Clean driving record
• Consistent & reliable transportation
• Polite & professional disposition

Travel

Travel to Epic headquarters may be required during first 6 months to facilitate Epic certification.  Otherwise, minimal travel requirements; may travel to CEENTA offices as needed

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. In addition to those essential functions identified above, individuals in this position are also responsible for performing other duties or tasks that may be assigned. CEENTA retains the discretion to add or change the essential job functions of this position at any time without notice.

A Typical Day in the Position

The BI Developer primarily builds custom reports using SQL to access Clarity and Caboodle databases. They create custom relational logic to meet user requests and determine the best BI delivery method to solve business needs. They collaborate with the Database Administrator and ETL Administrator to ensure data accuracy and report integrity.  BIDs routinely engage with CEENTA operations, finance, and technology leaders, and occasionally engage with physicians, provide training to these groups as well as other end users of reporting tools.