Epic Business Intelligence Reporting and Analytics Developer/Analyst

Epic Business Intelligence Reporting and Analytics Developer/Analyst

Location: San Jose, California

Hire Type: Contract (6+ Months)

Client: County of Santa Clara

Skills Needed:

SQL query, SSIS development, Epic Clarity, Caboodle Financial or Clinical Data Model, Epic reporting in a hospital / health system setting, stored procedure development, Epic Clarity HB & PB reporting, SAP Crystal report development, Epic certifications / experience reporting against Epic data, Professional (PB) and Hospital Billing (HB) reporting, Government, public or non-profit sector experience

This consultant will primarily convert existing Finance SAP Crystal reports into stored procedures and SSIS packages. The ideal candidate would have a working knowledge of SSIS development, SQL experience writing stored procedures (Microsoft), and be able to extract SQL logic from existing SAP Crystal reports. Knowledge of Epic Professional and Hospital Billing are required.

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.

Job Description

Typical Tasks:

Extract SQL query / logic from existing finance SAP Crystal reports.

Evaluate/consolidate multiple instances of similar reports into a single output.

Create stored procedures on SQL server.

Create SSIS packages to call stored procedures while passing parameters.

Optimize any existing SQL queries (knowledge of Clarity HB and PB required).

Produce comprehensive documentation of developed processes and workflows.

Required Skills & Abilities:

Minimum 3 years of experience with Epic reporting in a hospital / health system setting.

5+ years of SQL query and stored procedure development experience.

Working knowledge of Epic Clarity HB & PB reporting.

3+ years of SSIS development experience.

2+ years of SAP Crystal report development.

Must be a self-starter comfortable working under general direction.

Desired Qualifications:

Any Epic certifications / experience reporting against Epic data.

Professional (PB) and Hospital Billing (HB) reporting experience.

Government, public or non-profit sector experience.

Certifications:

Required: Epic Clarity, Caboodle Financial or Clinical Data Model (or legacy equivalents)

Kiran Kumar View email address on click.appcast.io ARGYLL INFOTECH Inc Chicago, Illinois.