The Business Intelligence Developer (BID) develops and maintains reports, dashboards and related data extracts 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 key administrative medical and operational stakeholders to answer questions, set expectations, plan, and
implement products and services to meet organizational reporting and data analysis needs. This individual will become proficient in the use of institutional and third-party Business Intelligence (BI) tools and related system data models. This role requires an in-depth knowledge and understanding of data patterns and operational workflows. The proper individuals possess experience in all stages of Business Intelligence project work such as requirements gathering, logical and physical design, documentation, testing and deployment

Essential Functions:

• Develops reports using any BI application, such as Epic Cogito Tools, SAP Business Objects toolset (i.e. Crystal
  Reports), Cognos and Tableau.
• Proficiently works with MS SQL Server, including the development and management of T-SQL scripts and
  stored procedures.
• Fluency with RDBMS concepts such hierarchical, relational and multidimensional database modeling
  concepts. 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 add
  value.
• Develops, distributes, and provides support for reports and or dashboards in a timely manner, prioritizing
  multiple 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 and
  documentation.
• Conducts validation testing of all data exchanged, migrated, archived, imported, to and from the enterprise
  EHR system and related applications.
• Maintains knowledge of industry standards, as well as, federal, state and local healthcare regulatory
  requirements, including but not limited to, HIPAA and IRB policies and procedures, to ensure all deliverables
  meet 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 the
  IT customer base, as needed.
• Provides support for the Help Desk functions, and IT 
• 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 perform
  other emergency duties including, but not limited to, responses to threats or disasters, man-made or natural.

Education:

• Associates Degree in Business Administration, Information Systems, Computer Science, or similar discipline required. 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 education requirements.

Experience:

• Minimum of five (5) years of proven business analysis experience with work in a data analytics/data warehouse role and with business process re-engineering and architecture required. Solid MS SQL experience (T-SQL scripts, stored procedures, ETL, etc.) and Microsoft BI Suite (SSRS, SSIS, SSAS) required. Experience developing 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 into answers. Experience with healthcare industry data required. Preferred experience with healthcare EHR systems, ideally Epic.

Certification:

• Epic certification desirable. Ability to become Epic certified within 6 months of training 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.