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+