Overview

The Business Intelligence Developer (BID) develops and maintains reports, dashboards and related dataextracts from the enterprise EHR system and other sources including, but not limited to, clinical inpatient,clinical ambulatory, revenue cycle/financial and patient access data. This position works directly with keyadministrative medical and operational stakeholders to answer questions, set expectations, plan, andimplement products and services to meet organizational reporting and data analysis needs. This individual willbecome proficient in the use of institutional and third-party Business Intelligence (BI) tools and related systemdata models. This role requires an in-depth knowledge and understanding of data patterns and operationalworkflows. The proper individuals possess experience in all stages of Business Intelligence project work such asrequirements gathering, logical and physical design, documentation, testing and deployment

Responsibilities

• Develops reports using any BI application, such as Epic Cogito Tools, SAP Business Objects toolset (i.e. CrystalReports), Cognos and Tableau.
• Proficiently works with MS SQL Server, including the development and management of T-SQL scripts andstored procedures.
• Fluency with RDBMS concepts such hierarchical, relational and multidimensional database modelingconcepts. In-depth understanding of database management systems, online analytical processing (OLAP),and ETL (Extract, transform, load) framework.
• Analyzes and understands various data models in depth; proactively define data structures additions (views,distribution methods, intermediate tables, multidimensional cubes) that would improve performance or addvalue.
• Develops, distributes, and provides support for reports and or dashboards in a timely manner, prioritizingmultiple requests and maintaining a support relationship with all users.
• Manages and monitors scheduled execution of routine processes and reports, diagnosing and fixing any reportrelated issues while maintaining excellent open communication internally and externally.
• Excellent attention to detail, patience, and a positive, customer centric attitude.
• Develops and maintains positive relationships with all customers, key stakeholders and departmental colleagues.
• Clear demonstrations of critical thinking, technical, analytical, organizational, and problem-solving skills.
• Ability to identify the appropriate technological solutions for various reporting needs.
• Works within established guidelines, standards and methodologies for creating BI solutions anddocumentation.
• Conducts validation testing of all data exchanged, migrated, archived, imported, to and from the enterpriseEHR system and related applications.
• Maintains knowledge of industry standards, as well as, federal, state and local healthcare regulatoryrequirements, including but not limited to, HIPAA and IRB policies and procedures, to ensure all deliverablesmeet those standards.
• Provides support for any District audits.
• Utilizes change management processes and techniques in an appropriate manner.
• Adheres to all District Policies and Procedures.
• Provides adequate back up for personnel technical requirements, including on-call first level support across theIT customer base, as needed.
• Provides support for the Help Desk functions, and IT On-Call duties, as needed.
• Travels to remote locations on-request appropriately to provide IT support.
• Emergency duty may be required of the incumbent that includes working in Red Cross shelters or to performother emergency duties including, but not limited to, responses to threats or disasters, man-made or natural.

Qualifications

Education:

Associates Degree in Business Administration, Information Systems, Computer Science, or similar disciplinerequired. Bachelor's degree in the same or related field preferred. Equivalent combination of experience,consisting of seven (7) plus years of same or similar work experience, may substitute for minimum educationrequirements.

Experience:

Minimum of five (5) years of proven business analysis experience with work in a data analytics/data warehouserole and with business process re-engineering and architecture required. Solid MS SQL experience (T-SQLscripts, stored procedures, ETL, etc.) and Microsoft BI Suite (SSRS, SSIS, SSAS) required. Experiencedeveloping reports/dashboards with any BI application, such as Epic Cogito, Crystal reports, Cognos, Tableau,etc. required. Ability to take large data sets and summarize down to actionable levels, turning analysis intoanswers. Experience with healthcare industry data required. Preferred experience with healthcare EHRsystems, ideally Epic.

Certification:

Epic certification desirable. Ability to become Epic certified within 6 months of training required.Business Intelligence Developer

Licensure:

Valid Florida Driver’s License required

Health Care District of Palm Beach County is proud to be an Equal Opportunity Employer and Drug Free Workplace. We embrace diversity and do not discriminate based on race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.