Charlotte Eye Ear Nose and Throat
Business Intelligence Developer
Charlotte Eye Ear Nose and Throat, Charlotte, North Carolina, United States, 28245
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 has the responsibility for system support maintenance, analysis, design, and change control of all reporting components used to build and manage CEENTAs reporting. Description
The BID will work closely with stakeholders to develop accurate and actionable reports that support clinical, business, and operational decision making. Primary duties include system support, maintenance, and the design and implementation of BI solutions that serve CEENTAs reporting needs. Essential Functions
Collaborate with Subject Matter Experts and members of leadership to gather, analyze, and document BI requirements. Assess reporting needs to Epic customers through investigations, analysis and evaluation to create desired reports. Receive and document formal requests from customer including specifications (layout, calculations, data source, etc.) Evaluate requests for completeness and, if needed, work with customer to finalize request. Define report requirements; design, develop, test, install, and implement report-based programs; program 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 awareness of current and future BI technologies and best practices and fully understand the 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. Maintain data integrity and ongoing quality control of delivered reports. Validate system build/reports designs and perform audit and report findings of security and data controls. Work with external organizations and third?party vendors to securely extract and share data. Design and document 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 CEENTAs patients. Qualifications
Education
Bachelors degree in Computer Science, Business Administration or Health Information Management preferred. Experience
2+ years of Epic Cogito experience preferred. Certificates, Licenses, Registrations
Cogito Fundamentals, Caboodle Data Model, and Clarity Data Model certifications preferred. Certification must be obtained within 3 months of hire date. Certifications relating to other Epic modules, software applications, technology infrastructure, and/or clinical specializations are an advantage. Work Environment
The work environment characteristics described are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Supervisory Responsibilities
The BI Developer reports to the Manager of Data Analytics and BI. This position has no supervisory responsibilities. Position Type and Expected Hours of Work
Full?time. Standard hours of operation (and working hours): 8am?5pm, Monday?Friday. Additional evening/weekend hours may be required to complete system updates. Upon successful completion of a probationary period and in good standing, employee is eligible for remote work. Physical And Mental Requirements
Physical Demands: While performing the duties of this job, the employee is regularly required to talk and hear. The employee may be required to sit in front of a computer for long hours, type, and repetitively click a mouse. Mental Demands: Employee will need to have the ability to problem solve, work under pressure, thrive in a fast?paced environment, use discretion and sensitivity, and work alone for long stretches of time. Travel
Minimalmay travel to satellite offices as business needs arise. 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 will spend most of their time building custom reports that cannot be completed with the available reporting tools in Hyperspace (Reporting Workbench, Dashboards, SlicerDicer). They will accomplish this by using SQL to access the different databases (Clarity & Caboodle) and creating custom relational logic to fit the request of the user. After creating the custom report, the BI Developer will then assure the delivery of this report is appropriate by determining the best BI vehicle to utilize. The BI Developer will also work closely with our Database Administrator and ETL Administrator to assure all active reports are appropriately pulling the correct data and validate the integrity of the data. Seniority level
Entry level Employment type
Full?time Job function
Information Technology Industries
Hospitals and Health Care #J-18808-Ljbffr
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 has the responsibility for system support maintenance, analysis, design, and change control of all reporting components used to build and manage CEENTAs reporting. Description
The BID will work closely with stakeholders to develop accurate and actionable reports that support clinical, business, and operational decision making. Primary duties include system support, maintenance, and the design and implementation of BI solutions that serve CEENTAs reporting needs. Essential Functions
Collaborate with Subject Matter Experts and members of leadership to gather, analyze, and document BI requirements. Assess reporting needs to Epic customers through investigations, analysis and evaluation to create desired reports. Receive and document formal requests from customer including specifications (layout, calculations, data source, etc.) Evaluate requests for completeness and, if needed, work with customer to finalize request. Define report requirements; design, develop, test, install, and implement report-based programs; program 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 awareness of current and future BI technologies and best practices and fully understand the 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. Maintain data integrity and ongoing quality control of delivered reports. Validate system build/reports designs and perform audit and report findings of security and data controls. Work with external organizations and third?party vendors to securely extract and share data. Design and document 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 CEENTAs patients. Qualifications
Education
Bachelors degree in Computer Science, Business Administration or Health Information Management preferred. Experience
2+ years of Epic Cogito experience preferred. Certificates, Licenses, Registrations
Cogito Fundamentals, Caboodle Data Model, and Clarity Data Model certifications preferred. Certification must be obtained within 3 months of hire date. Certifications relating to other Epic modules, software applications, technology infrastructure, and/or clinical specializations are an advantage. Work Environment
The work environment characteristics described are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Supervisory Responsibilities
The BI Developer reports to the Manager of Data Analytics and BI. This position has no supervisory responsibilities. Position Type and Expected Hours of Work
Full?time. Standard hours of operation (and working hours): 8am?5pm, Monday?Friday. Additional evening/weekend hours may be required to complete system updates. Upon successful completion of a probationary period and in good standing, employee is eligible for remote work. Physical And Mental Requirements
Physical Demands: While performing the duties of this job, the employee is regularly required to talk and hear. The employee may be required to sit in front of a computer for long hours, type, and repetitively click a mouse. Mental Demands: Employee will need to have the ability to problem solve, work under pressure, thrive in a fast?paced environment, use discretion and sensitivity, and work alone for long stretches of time. Travel
Minimalmay travel to satellite offices as business needs arise. 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 will spend most of their time building custom reports that cannot be completed with the available reporting tools in Hyperspace (Reporting Workbench, Dashboards, SlicerDicer). They will accomplish this by using SQL to access the different databases (Clarity & Caboodle) and creating custom relational logic to fit the request of the user. After creating the custom report, the BI Developer will then assure the delivery of this report is appropriate by determining the best BI vehicle to utilize. The BI Developer will also work closely with our Database Administrator and ETL Administrator to assure all active reports are appropriately pulling the correct data and validate the integrity of the data. Seniority level
Entry level Employment type
Full?time Job function
Information Technology Industries
Hospitals and Health Care #J-18808-Ljbffr