Epic HB/PB Report Writer

Location: United States

Duration: 9 months

Responsibilities:

• 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
• Participate in project meetings and project decisions to ensure that deliverables support Analytics & project goals and deadlines, coalesce related requests and offer solutions that satisfy multiple requirements, and Software Development Life Cycle discipline
• Gather, document and confirm requirements, design solutions, obtain SME signoff, coding, testing/validation, UAT, & documentation
• Collaborate with cross-functional team, working on collaborative solutions with operational clinical leaders, application build analysts, Epic boost and resources, as well as other analytics business intelligence developers and peer testers
• 5+ years of SQL query and stored procedure development experience
• 3+ years of experience with Epic reporting in a hospital/health system setting
• 3+ years of experience with Epic Clarity HB & PB reporting
• 3+ years of experience with SSIS development
• 2+ years of experience with SAP Crystal report development
• Experience with SQL writing stored procedures (Microsoft), and extracting SQL logic from existing SAP Crystal reports
• Prior experience with Government, public or non-profit sector experience
• Epic Clarity, Caboodle Financial or Clinical Data Model (or legacy equivalents) certifications
• #LI-Remote
• #LI-JK1