Title Technical Analyst - Revenue Cycle and Claims
Location Remote
Required SQL Proficiency (Intermediate to Advanced)
The experience we need goes beyond basic / sufficient levels. Candidates must demonstrate proficiency in the following :
- Common Table Expressions (CTEs) : Using the WITH clause to break down a complex query into smaller, readable, and reusable blocks.
- Subqueries : Proficiency in using nested SELECT statements (in the FROM, WHERE, and SELECT clauses) and knowing when to use them versus a JOIN.
- Advanced Joins : Deep understanding of all join types (INNER, LEFT, RIGHT, FULL), and the ability to join multiple tables (5+) correctly.
- Set Operations : Using UNION, UNION ALL, INTERSECT, and EXCEPT to combine results from multiple queries.
- Conditional Logic : Extensive use of the CASE statement for complex data categorization, pivoting, and transforming data based on business rules.
Job Summary
Works with stakeholders to discover, clarify, and document current and future data needsPerforms mapping of revenue cycle, clinical and claims data to a normalized data model.Serves as a subject matter expert on the revenue cycle data domains such as Registration, Scheduling, Accounting and Billing, Cost Accounting and ClaimsBuilds data concepts to support Revenue Cycle and Claims use casesServes as a key resource for an assigned customer area to understand and explain business and technical issues and to provide viable technology solutions.Responsibilities :
Act as a quality consultant and subject matter expert, performing testing and validation of the mapping of data elements to standardsCollaborates with technical resources to perform root cause analysis and complete remediation of data quality issuesWorks with customers to clarify and plan for their current and future technology needs. Determines and maps existing business processes / functions and recommends changes required to fit a tightly integrated system.Designs and implements projects requiring systems integration, small teams and multiple technical platforms.Conducts Return on Investment (ROI) and other financial analysis to support project funding / prioritization.Collaborates on driving improvement activities to achieve department and organizational goals.Coordinates with functional team to assure consistency and optimization of overall work productAssumes a proactive role in driving improvement activities to achieve department and organizational goals to deliver value.Maintains current knowledge of industry and business process trends and is able to apply that knowledge to existing business processes.Provides subject-matter expertise of Health Ministry processes, policies and requirements in support of functional area process design, testing and implementationIdentifies opportunities for process improvement and makes recommendations that lead to improvementsMonitors task assignments to ensure they are performed on schedule, within intended scope and to a defined level of quality.Escalates process and project issues that cannot be resolvedExperience :
Prior experience working as a Revenue Cycle analyst in the Healthcare system.Must have a working knowledge of relational databases / database structures, SQL expertise desiredMust have a strong understanding of data collected and used in EMRs, Revenue Cycle and Patient Accounting Systems .Knowledge and experience with ambulatory and acute clinical, billing and claims workflows and clinical information systems.Bachelor or Masters degree in related health or finance field ex informatics or bioinformatics.Complexity of work : Within the scope of job, requires critical thinking skills, decisive judgment and the ability to work with minimal supervision. Must be able to work in a stressful environment.5 years of experience preferred