Business Intelligence Developer

Location of Job: Dover, DE

Status: FT-80

Position Summary

The BI Developer is responsible for working collaboratively with IT and operational staff to design and develop advanced reporting solutions using multiple BI development tools and programming languages to meet customer expectations. The BID 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 uses best practices and common processes for developing solutions to support key strategic organizational priorities, including data governance, population health management, clinical performance, quality/operational performance and regulatory reporting requirements.

Essential Functions & Accountabilities

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. Practices reflective listening skills. c. Assists with BI governance initiatives and workgroups. d. Establish and maintain strong third party vendor relationships. e. Ensures that consumers are satisfied with reports and distribution tools.

2. Using independent judgement designs, engineers, develops and validates advanced business intelligence solutions. a. Identifies 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 complex relational and multidimensional database queries and mapping. 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. g. Using independent judgement develops and troubleshoots advanced reports, dashboards, and other BI solutions to support clinical, regulatory, and revenue initiatives long-term.

3. Apply advanced knowledge of methodologies to evaluate and continuously improve reports, dashboards, applications, and other BI solutions and communicate results and outcomes to management team as required. a. Uses excellent analytical, mathematical, and creative problem-solving skills to support the organizations goals and objectives. b. Proficient with best practices and common processes for developing standardized, scalable business intelligence solutions using data governance principles. c. Responsible for testing, documentation and adherence to change management practices. d. Ensures a high level of availability for all critical reports and applications. e. Utilizes emerging technology research and presents findings to management and end-user community. f. Performs complex troubleshooting without assistance and evaluates overall consumer satisfaction with reports g. Makes recommendations to maintain, update and improve reporting processes and BI solutions and related documentation. h. Highly self-motivated and directed. Ability to effectively prioritize and execute tasks.

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

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

Position Requirements

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

Experience: 3 years of relevant experience attributable to to using business intelligence tools . Healthcare experience is strongly preferred.

Computer/Software Knowledge: Position requires proficiency with reporting tools and data visualization tools. 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.