Business Intelligence Developer-Full-Time-Days

Cape-Fear-Valley-Medical-Center-; Fayetteville (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

Cape Fear Valley Medical Center is seeking a seasoned BI Analyst/Developer to build and support complex reporting across clinical and financial workflows. You will work with Epic Hosted ETL, Cogito, and Business Analysts to transform data into actionable dashboards and datasets.

Required 5+ years in healthcare BI, strong SQL and visualization skills, and Epic certification or commitment to obtain within 3 months.

Qualifications

• Bachelor's degree or 8+ years experience in healthcare IT.
• Epic certification required or must obtain Epic Certification within 3 months of training and pass exams.

Responsibilities

• Develop and support reporting and analytics solutions for EHR data and other sources.
• Collaborate with Epic ETL developers, Subject Matter Experts, Cogito Project Manager and Business Analyst to gather requirements.
• Design scalable data integration and data governance using Fabric Data Factory and Synapse.
• Maintain security, data modeling, and documentation; provide post-implementation support.

Skills

Advanced SQL

ETL design

Data warehousing concepts

Healthcare BI experience

Analytical thinking

Communication

Education

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

Epic Certification (required or within 3 months)

Tools

MS SQL Server

Tableau

PowerBI

Python

Fabric Data Factory / Synapse Data Engineering

Job description

FacilityCape Fear Valley Medical CenterLocationFayetteville, North CarolinaDepartmentEPICJob FamilyInformation TechnologyWork ShiftDays (United States of America)SummaryDevelop 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 FunctionsThe 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 strategiesDevelop 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 AnalystWork with Application Subject Matter Experts and Business Analyst to identify and understand source data systemsLook for opportunities to improve current processes or find efficiencies by applying industry best practices for BI developmentWork on security setup and maintenance, tool administration, and data modelingDevelop and implement Cogito/Tableau/ PowerBI application documentation and training materialsMaintain communication with management and users during development or maintenance cycleWork 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 productionDevelop or assist in the creation of project time estimatesProvide post implementation support of user questions and fine tuning of processesCollect requirements and specifications to aid BI Director in prioritization and resource allocationCoordinate users' activities during application development and maintain data and system integrityMaintain knowledge on current computer hardware and software technologyOther duties as assignedMinimum QualificationsThe 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 consideredEpic 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 requiredWork Experience:5 years of experience in a healthcare related organization required5 years of demonstrated expertise in MS SQL Server requiredKnowledge, Skills, and Abilities Required:Proficiency in reading, writing, and speaking the English languageDemonstrated flexibility with respect to changing end-users needsAdvanced Proficiency in SQL, Python, Visual Studio, Tableau, PowerBI, Microsoft FabricKnowledge of data warehouse concepts, data structures and reportingDemonstrated knowledge of Architecture Design leveraging OneLake, Lakehouse and Data Warehouse componentsFamiliarity with Pipeline Engineering, ability to design scalable data integration and orchestration using Fabric Data Factory and Synapse Data EngineeringDemonstrates knowledge of Governance and Security and the use of Microsoft Purview is a plusExtensive knowledge of best practices regarding reporting, workflows, policies, procedures, systems and culture in the healthcare environmentStrong analytical, problem-solving and metadata skillsAbility to translate business questions and requirements into reports, views, and BI query objectsExperience in gathering, documenting, prioritizing and tracking requirementsStrong organizational skills and customer service orientationDemonstrated experience synthesizing and analyzing large data and making program recommendations based on that data is requiredExcellent written and communication skills explaining complex quantitative models to business stakeholders, management and executivesHigh functioning team skills, including active listening, rapport building, receiving and delegating work assignmentsFamiliarity with Microsoft Office and Microsoft Teams preferredPhysical Requirements:Ability to work independently, in a remote or office settingMay require flight travel to Verona, WisconsinAbility to see and read reports and computer display terminalsManual dexterity to keypunch data via keyboardMay require extended periods of sedentary work and extended working hours to meet stated objectivesRequired Licenses and CertificationsEpic Software - EPICCape Fear Valley Health System is an Equal Opportunity Employer M/F/Disability/Veteran/Sexual Orientation/Gender Identity