Business Intelligence Developer II

Location : Kent Campus Hospital

Highly qualified candidates may be considered for hybrid / remote work.

Status : Full Time 80 Hours

Shift : Days

SALARY RANGE : 78,582.40 - 128,440.00YEARLY

General Summary :

The Business Intelligence Developer II / BI Developer II is responsible for working collaboratively with end users, subject matter experts, IT analysts and technical staff to understand, analyze and communicate complex reporting solutions using multiple BI development tools and programming languages to meet customer expectations. The BID II engineers solutions using advanced knowledge of data models, data definition and manipulation languages, data extraction, transformation, and load (ETL) design and development and integrates them into the workflow of end users on enterprise-wide hardware platforms, operating systems and software environments. The BI Developer II is responsible for selection, design and developing solutions to support key strategic organizational priorities, including data governance, population health management, clinical performance, quality / operational performance, and regulatory reporting requirements.

Responsibilities :

1. Demonstrates accountability and collaboration as a team member by working successfully with internal and external clients. a. Presents ideas and instructions clearly, verbally and in writing using appropriate presentation tools as needed. b. Assists with BI governance initiatives and workgroups. c. Establish and maintain strong third party vendor relationships.d. Ensures that consumers are satisfied with reports and distribution tools.

2. Using independent judgement analyzes, engineers, develops and validates advanced business intelligence solutions. a. Helps to identify appropriate data sources for data extraction into various data visualization and reporting tools. b. Reads and interprets conceptual, logical, and physical data models to include context, data flow, process flow, logical diagrams, and data dictionaries. c. Applies advanced understanding of data modeling concepts and techniques in relation to various BI applications in addition to application of knowledge related to : databases and tables, relations and constraints, attribute data types, and column data types.d. Writes and performs less complex relational and multidimensional database queries and mapping using requirements gathered by BI Developer I.e. Creates solutions using advanced knowledge of data models, data definition and manipulation languages, data extraction, transformation, and load (ETL) design and development.f. Performs performance tuning to optimize and debug queries to meet user needs.

3. Evaluate and continuously improve reports, dashboards, applications, and other BI solutions and communicate results and outcomes to management team as required.a. Proficient with best practices and common processes for developing standardized, scalable business intelligence solutions using data governance principles. b. Responsible for testing, documentation and adherence to change management practices.c. Ensures a high level of availability for all critical reports and applications.d. Utilizes emerging technology research and presents findings to management and end-user community. e. Performs basic troubleshooting without assistance and evaluates overall consumer satisfaction with reportsf. Makes recommendations to maintain, update and improve reporting processes and BI solutions and related documentation.

4. Mentors and assists other BIDs, application analysts, and end user report developers.

5. All other duties as assigned within the scope and range of job responsibilities

Qualifications :

Education : Bachelor's Degree required; Master's Degree preferred.

Experience : Position requires 5 or more years of experience attributable to using business intelligence tools, preferably in a Healthcare environment. Position also requires an understanding of Population Health concepts & Bayhealth's goals to incorporate them into systematic solutions, as well as the ability to probe for information about the underlying needs of the organization & user community, which directly influences how our systems are built.

Computer / Software Knowledge : Position requires expert working knowledge of relational databases, data element mapping, database management, report validation methods, data warehouse and dashboard development including concept design and build. Position also requires expert knowledge of IT standards, quality methods & metrics and knowledge of user business practices, concepts and terminology sufficient to support data mapping identification.

Preferred experience includes : Proficiency programming in SQL, R, SAS, Python or equivalent programming languages. Experience with relational databases, cubes, and data warehouses. Experience with business intelligence tools : SQL Server, Microsoft BI stack, SAP Business Objects, Qlik Sense, Tableau, or Crystal Reports. Healthcare applications experience, EPIC or similar, is strongly preferred.

Licensure / Certification : Certification attributable to the application being supported is required within 6 months of hire. Current Epic Clarity Data Model certifications preferred.

To view a full list of all open position at Bayhealth, please visit :