Job TitleThis consultant will provide Microsoft SQL Server query tuning and optimization support to our developers, development of ETLs, BOE system maintenance, and operational support of reporting systems.
The role requires consultant communication skills, the ability to coalesce related requests and offer solutions that satisfy multiple requirements, and Software Development Life Cycle discipline: gathering & documenting and confirming requirements gathering, designing solution, obtaining SME signoff, coding, testing/validation, UAT, & documentation.Typical Tasks:Write and modify ETL for inbound and outbound payer/HEDIS/Gap-in-Care/procedure filesReview existing long running queries and make recommendations for performance improvementsMaintain and monitor production reporting systems for issues and areas of improvementUpgrade and patch reporting systems (BOE) as neededDatabase administration (DDL, partitioning, DB tuning)Required Skills & Abilities:Strong SQL and ETL development using best practice industry standardsStrong data warehousing best practice experienceEfficient creation/modification/optimization of queries for best performanceAbility to analyze and recommend changes based on query analyzer or other tuning toolsDesired Skills & Abilities:BOE Maintenance experience (Security, implementation, updates, scheduling)EPIC Clarity and Caboodle experienceCertifications: Epic Clarity/Cogito Preferred