Overview 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, andimplement 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 Responsibilities Essential Functions: 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 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 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 onrace, 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.
irb Business Intelligence (BI) OLAP Tableau T-SQL Cognos HIPAA Microsoft SQL Server SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) Information technology (IT) ETL RDBMS epic SSAS