Business Intelligence Developer-Full-Time-Days

Cape Fear Valley Health; Fayetteville, Northern (NC, KY); On-site; USD 90,000 - 130,000; Full time

Job summary

Cape Fear Valley Health in Fayetteville, NC seeks a BI analyst to develop and support complex reporting, analytics, and dashboards for Epic data. You will work with Epics ETL teams to design data solutions and translate business needs into technical specs.

The role emphasizes SQL, Python, and visualization tools, plus governance and data quality across the BI lifecycle. Remote work is not indicated; on-site collaboration is expected.

Qualifications

• Proficiency in English language, both written and spoken.
• Strong SQL, Python, and data visualization skills (Tableau/PowerBI).
• Experience with data warehousing concepts and governance.
• Epic certification or plan to obtain within 3 months of training.
• Healthcare BI experience and understanding of EHR data is preferred.

Responsibilities

• Develop and support BI reports, analytics and datasets for stakeholders.
• Collaborate with Epic ETL teams to design data design strategies.
• Gather requirements and translate into BI solutions and dashboards.
• Ensure data security, governance, and data quality across reports.

Skills

SQL

Python

Tableau

PowerBI

Microsoft Fabric

Data warehousing

ETL

Data governance

Security & governance

Education

Bachelor's degree in Computer Science, Math, Engineering, Health Information Management or Statistics

Epic certification within 3 months of training

Tools

Epic Clarity

Epic Caboodle

Cogito

SQL Server

Visual Studio

PowerBI

Tableau

Microsoft Fabric

Synapse/Data Factory

Job description

Facility

Cape Fear Valley Medical Center

Location

Fayetteville, North Carolina

Department

EPIC

Job Family

Information Technology

Work Shift

Days (United States of America)

Summary

Develop and support complex operational, analytical and strategic reporting and analytics solutions for information consumers simplifying access to information. Working in close coordination with Application Subject Matter Experts, Cogito Project Manager and Business Analyst to develop understanding of financial and clinical workflows, business process flows and data relationships and operates in all phases of a Business Intelligence development life cycle which incorporates requirements definition, design, report development and deployment as well as support.

Major Job Functions

The following is a summary of the major essential functions of this job. The incumbent may perform other duties, both major and minor, that are not mentioned below. In addition, specific functions may change from time to time:

• Work with Epic Hosted ETL developers to determine report and data design strategies
• Develop reporting and analytics solutions for CFVH's electronic health record (EHR) system by gathering business needs, documenting requirements, identifying appropriate data sources, developing reports and datasets, and delivering them to stakeholders or Business Analyst
• Work with Application Subject Matter Experts and Business Analyst to identify and understand source data systems
• Look for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Work on security setup and maintenance, tool administration, and data modeling
• Develop and implement Cogito/Tableau/ PowerBI application documentation and training materials
• Maintain communication with management and users during development or maintenance cycle
• Work as part of the Data Governance Team to review, test, and evaluate reports, queries, dashboards, and analytical tools developed by teammates prior to moving to production
• Develop or assist in the creation of project time estimates
• Provide post implementation support of user questions and fine tuning of processes
• Collect requirements and specifications to aid BI Director in prioritization and resource allocation
• Coordinate users' activities during application development and maintain data and system integrity
• Maintain knowledge on current computer hardware and software technology
• Other duties as assigned

Minimum Qualifications

The following qualifications, or equivalents, are the minimum requirements necessary to perform the essential functions of this job:

• Education and Formal Training: Bachelor's degree in Computer Science, Math, Engineering, Health Information Management or Statistics required OR 8 years' experience in lieu of formal education will be considered Epic certification required OR if not currently certified in Cogito Fundamentals, Epic Clarity and Epic Caboodle, must obtain Epic certification within 3 months of training and must pass all certification exams with a passing grade within three attempts for each test from each class required
• Work Experience: 5 years of experience in a healthcare related organization required 5 years of demonstrated expertise in MS SQL Server required
• Knowledge, Skills, and Abilities Required: Proficiency in reading, writing, and speaking the English language Demonstrated flexibility with respect to changing end-users needs Advanced Proficiency in SQL, Python, Visual Studio, Tableau, PowerBI, Microsoft Fabric Knowledge of data warehouse concepts, data structures and reporting Demonstrated knowledge of Architecture Design leveraging OneLake, Lakehouse and Data Warehouse components Familiarity with Pipeline Engineering, ability to design scalable data integration and orchestration using Fabric Data Factory and Synapse Data Engineering Demonstrates knowledge of Governance and Security and the use of Microsoft Purview is a plus Extensive knowledge of best practices regarding reporting, workflows, policies, procedures, systems and culture in the healthcare environment Strong analytical, problem-solving and metadata skills Ability to translate business questions and requirements into reports, views, and BI query objects Experience in gathering, documenting, prioritizing and tracking requirements Strong organizational skills and customer service orientation Demonstrated experience synthesizing and analyzing large data and making program recommendations based on that data is required Excellent written and communication skills explaining complex quantitative models to business stakeholders, management and executives High functioning team skills, including active listening, rapport building, receiving and delegating work assignments Familiarity with Microsoft Office and Microsoft Teams preferred
• Physical Requirements: Ability to work independently, in a remote or office setting May require flight travel to Verona, Wisconsin Ability to see and read reports and computer display terminals Manual dexterity to keypunch data via keyboard May require extended periods of sedentary work and extended working hours to meet stated objectives
• Required Licenses and Certifications: Epic Software - EPIC Cape Fear Valley Health System is an Equal Opportunity Employer M/F/Disability/Veteran/Sexual Orientation/Gender Identity

Equal Opportunity

For exceptional healthcare come to Cape Fear Valley Health where caring employees are committed to integrity, patient-centeredness and excellence throughout the entire healthcare process. At Cape Fear Valley Health, our goal is to improve the quality of every life we touch. Our diverse team of doctors, nurses and staff work together to create a better experience for every patient, every time.

About Cape Fear Valley Health

Cape Fear Valley is a 950-bed, 8-hospital regional health system, the 8th largest in North Carolina, with more than 1 million inpatient and outpatients annually. A private not-for-profit organization with over 7,000 employees and 850 physicians. Our employees and physicians proudly serve a seven-county region of southeastern North Carolina, including Fayetteville, Fort Bragg, Hope Mills, Raeford, Lumberton, Elizabethtown, Clinton, Lillington, Dunn and beyond. Our medical facilities include Cape Fear Valley Medical Center, Highsmith-Rainey Specialty Hospital, Cape Fear Valley Rehabilitation Center, Behavioral Health Care, Bladen County Hospital, Hoke Hospital, Central Harnett Hospital, Betsy Johnson Hospital, as well as more than 60 medical offices and specialty care clinics spread throughout the Cape Fear region.