Job ID :
34287
Company :
Internal Postings
Location :
Woonsocket, RI
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
30 Oct 2021
Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Responsibilities:

  • Collaborate with business users to understand and determine business requirements for data extraction out of the Epic platform.
  • Demonstrate end-to-end understanding of the Epic platform, specifically Clarity and Caboodle.
  • Create and document technical design for ETL implementation, including data model design, tool selection, and cross-system integration
  • Leverage diverse array of tools to execute on business requirements and technical design, including but not limited to SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Tableau
  • Build custom SSIS packages to support ETL
  • Design automatic data acquisition or data delivery process leveraging Control-M, batch scripts, SSIS and SQL Server Database
  • Design and build scalable reporting solutions to continuously monitor trends, pattern, outliers on various clinical and operational metrics which impacts patient s health and operation performance
  • Build Radar dashboards and Reporting Workbench reports with in Epic Hyperspace environment for Clinical, Revenue Cycle, Operations and other business teams
  • Work collaboratively with the business users in testing phase and ensures the final deliveries of extracts and reports meet the business needs
  • Conduct rigorous data analysis of clinical and operational data and to drive insights that advance enterprise strategic goals
  • Identify, assess, and resolve complex business problems, issues, risks and facilitate issue resolution and risk mitigation
  • Review Epic upgrade documentation related to reporting and implement the changes as per the guidelines defined
  • Respond promptly to the needs of end-users, and meets Service Level Agreements as defined with business partners
  • Participate in project meetings as a key contributor with stakeholders from operations, clinical, payer relations and analytics team
  • Share the expertise and coach other less experienced developers in Epic reporting
  • Partner across teams to drive organizational data strategy and best practices in data management

Required Qualifications:

  • 3+ years of experience with data modeling and data management in a relational database management system, such as Oracle, Microsoft SQL Server
  • 3+ years of experience with SQL development. Ability write complex relational and multidimensional SQL queries and complex stored procedures.
  • 3+ years experience with ETL tools, such as SQL Server Integration Services (SSIS)
  • Strong analytical and problem-solving skills

Preferred Qualifications:

  • Experience working in Epic Caboodle and Clarity ETL
  • Familiarity or experience acting in the DBA admin role, specifically on Epic Clarity or Caboodle
  • Healthcare reporting/analytics experience
  • Prior experience working with an EHR system and understanding of clinical and revenue cycle data
  • Understanding or exposure to cloud-based platforms, such as AWS, GCP, or Azure
  • Strong verbal and written communication skills and ability to translate technical concepts to non-technical audiences
  • Ability to build consensus across teams, with staff and leadership
  • Ability to work effectively in a matrixed, agile reporting environment

Minimum years of experience*: 3+