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+