Business Intelligence Developer

Facility Cape Fear Valley Medical Center Location Fayetteville , North Carolina

DepartmentEPICJob 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 required5 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 One Lake, Lakehouse and Data Warehouse components

Familiarity with Pipeline Engineering, ability to design scalable…