We’re evolving health care so everyone can have the opportunity to live their healthiest life. It’s why we put your unique needs at the heart of everything we do, making it easy and affordable to manage health and well-being. We are delivering the right care how and when it’s needed; providing support to make smarter and healthier choices; and making prescription services easier, while helping you save money along the way. It’s everything health care should be. Together, for better health.

Primary Responsibilities:

Aids in the development of complex operational and project-related reports including analysis, design, documentation, versioning development, configuration, testing, implementation and ongoing support for Epic Cogito (Clarity and Caboodle)-based reporting

Extracts Epic data utilizing approved BI tools with SQL code

Receives and documents formal requests from customer including specifications (layout, calculations, data source, etc.) Evaluates requests for completeness and if needed work with customer to finalize request

Assists in the providing of technical direction, guidance and analysis during project development and accomplish all required formal sign-offs

Designs and documents the general functional requirements and detailed technical specifications for a report

Assists with Epic upgrades/updates by serving as a subject matter expert for the Epic Clarity data models

Implements reports/database software in an optimal manner to minimize the effect on production and development activities

Ability to troubleshoot technical issues with reports, including reviewing scripts and database issues

Provides technical/clinical workflow consultation including application configuration. Reviews, analyzes, and evaluates systems needs to develop recommendations for customers

Develops, supports and maintains all required system design and build documents and other system documentation related to Epic reporting

Provides support of application incidents reported through the help desk or ticketing systems; including potential 24/7 on call coverage as required

Adheres to organization standards for system configuration and change control

Develops solid relationships with end user communities, customers and business partners

Attends, participates in, and contributes to meetings throughout the facility

Troubleshoots and/or resolves application issues and escalates more complex issues as appropriate

The BI Developer may create new reports, using third party report writing tools to display Epic data

Key Competencies:

Excellent time management, organizational, and prioritization skills and ability to balance multiple priorities

Teamwork and Collaboration. Consultative and collaborative style with demonstrated ability with cross-functional teams

Aid in the creation of design specifications for new reports and identify and validate the appropriate technological solutions for various reporting needs

Consults with and advise vendors and technical groups concerning the continued support of reports and databases

Demonstrates the ability to build and maintain solid internal relationships as well as motivate and inspire other team members through solid consultative skills

Demonstrates a solid ability to build partnerships and influence others. Work across team, group and business boundaries to drive commonality and reusability in solution to real-world problems

Demonstrates solid relationship management skills and ability to handle challenging interpersonal situations

Required Qualifications:

2+ years of experience with Microsoft SQL Server or another relational database platform

1+ years of experience using SQL query techniques and stored procedures to access relational databases with the ability to write efficient queries

1+ years of Reporting tool experience or certifications (Oracle, Microsoft, Tableau, Qlik, SAS, Cognos, etc.)

Proficiency with MS Excel, Visio, PowerPoint and SharePoint

Preferred Qualifications:

Active Epic certification in any Cogito data model (Clarity or Caboodle)

3+ years of experience designing, creating, testing and implementing complex reports using SQL Management Studio, ETL, SSIS, SSRS, etc.

1+ years of experience with Epic applications and database structure

Demonstrated ability to demonstrate cross-team communication and leadership skills