Healthcare Information & Data Analyst I
Location: Pearland Administrative Office
Job Type: Full-Time
Department: Healthcare Finance
Kelsey-Seybold Clinic. Your Doctors for Life.
Since 1949, Kelsey-Seybold Clinic has served its patients with one goal in mind – combine the expertise of physicians in a variety of medical specialties, with the close personal care of a family doctor. Kelsey-Seybold is Houston’s largest community-based physician group, caring for more than 400,000 patients. With 19 clinic locations, we are growing to meet the health care needs of our diverse patient population. Our mission is to provide our team members with exceptional opportunities for professional and personal growth.
This analyst will serve as the primary resource for providing reporting, support, and analysis to the Central Business Office (CBO), which is responsible for billing and collections of insurance and self-pay accounts for 300+ physicians and two Ambulatory Surgery Centers in the greater Houston area. In addition to supporting the CBO, the analyst will be responsible for the verification and analysis of the Clinic’s fee-for-service contracts to ensure correct and adequate reimbursement by insurers. The analyst in this position will develop a thorough understanding of the revenue cycle (insurance verification, charge and claim creation, payment posting, insurance follow-up, and refunds) and the related systems used within the organization. The position requires development of an in-depth knowledge of Epic Resolute Professional Billing and the associated Clarity SQL reporting warehouses.
Daily activities will require heavy use of Excel, including advanced formulas, pivot tables, Power Pivot, and Visual Basic and/or macros, writing and editing SQL queries via SQL Server Management Studio (SSMS), and basic knowledge of Access and Crystal Reports to maintain and troubleshoot existing processes. Technical skills can be acquired on the job.
EDUCATION REQUIREMENTS & EXPERIENCE REQUIREMENTS
(A = basics; B = preferred)
A. Bachelor’s Degree in Finance, Economics, Mathematics, Healthcare Administration, or related field; or Associate’s Degree with equivalent work experience
A. 0-3 years of experience in data analysis, decision support, medical economics, healthcare informatics, or managed healthcare or equivalent combination of education and experience to demonstrate ability to succeed in healthcare analytics
Demonstrated initiative and problem solving skills
B. Demonstrated ability to analyze and report on business units, products or service lines
Experience in the healthcare industry with understanding of data in healthcare organizations (including claims data, ICD10, Medicare Advantage, Health Insurance Marketplace, capitated payment models)
Demonstrated analytical/modeling skills with ability to convert raw data into actionable business insights
A. Proficient in Microsoft Excel
Basic knowledge of Microsoft Power Point and Microsoft Word
B. Experience writing, debugging and documenting complex queries against relational databases
Experience with SQL or other programming tools (including Visual Basic and Excel macros)
Experience with Statistical Software (including SAS, R, Minitab, SPSS)
Familiarity with EPIC and Clarity reporting data warehouse
Knowledge of Crystal Reports, Microsoft Access, or SSRS
A. Fluent in English both verbal and written, effective communicator
High level of accuracy with excellent attention to detail
Strong organizational and time management skills
Proven ability to work in a dynamic setting and balance multiple priorities while meeting deadlines
B. Ability to communicate complex information in a clear and concise manner