Epic Business Intelligence Reporting and Analytics Developer/Analyst

Position Epic Business Intelligence Reporting and Analytics Developer/Analyst

Santa Clara, CA

Contract Term: 9 months

Objective:This consultant will provide end-to-end delivery of reporting and analytics solutions in an Epic

Clarity cross-functional Clinical/Financial domain. Work focuses on developing Global Payment

Program (GPP) population, metrics, and quality performance measures, ensuring compliance with deliverables by performing quality data audits and analysis. Works with and is a liaison between the customers, application teams and appropriate IT personnel, when necessary, on a regular basis to align technology functionality to operational processes. Applies knowledge of clinical workflows to understand and interpret regulatory specifications, and additional duties as assigned.

This consultant's primarily deliverables will be supporting the development of the GPP population SQL logic, GPP quality measure architecture, and optimizing existing GPP workflow to leverage stored procedures and SSIS to execute the queries.

The role requires consultant communication skills - in particular, independently participating in project meetings and project decisions to ensure that deliverables support Analytics & project goals and deadlines. It further requires the ability to coalesce related requests and offer solutions that satisfy multiple requirements, and Software Development Life Cycle discipline:

gathering & documenting and confirming requirements, designing solutions, obtaining SME signoff, coding, testing/validation, UAT, & documentation.

This role also requires collaborative cross-functional team skills - in particular, working on collaborative solutions with operational clinical leaders, application build analysts, Epic boost and TS resources, as well as other analytics business intelligence developers and peer testers.

• Review GPP program's metric specifications for logic and data set changes and translate them into technical requirements.
• Develop new quality measure code (leverage existing QIP measure code) or update existing metric code based on new or revised metric definitions.
• Work closely with business SMEs to interpret specifications and requirements, quickly iterating on changes.
• Help design the GPP architecture using SQL Server tables, stored procedures and SSIS packages.
• Analyze result sets and present to operational leadership in easy to read and actionable formats.

• Exceptional SQL coding skills in Epic Clarity, and familiarity with all financial tables, views and functions.
• Metric development experience with pay-for-performance programs like QIP, GPP or

HEDIS.

• Experience with developing complex SQL queries, stored procedures and SSIS packages.
• Strong ability to work directly with operational clinical leaders, project office, clinic staff and other stakeholders.
• Epic PB/HB reporting experience.