R1 is the leading provider of technology-driven solutions that transform the patient experience and financial performance of hospitals, health systems and medical groups. We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry’s most advanced technology platform, encompassing sophisticated analytics, AI, intelligent automation, and workflow orchestration.
As our SQL Denials Automation Associate, you will help the company by performing trending and analysis on 837/835 data, client extracts and other data sources. Every day, you will create mappings based on payer, CARC/RARC codes, and CPT codes to drive workflow decisions and assist with automating processes and driving efficiency improvements. You will also collaborate with various internal teams to develop workflows and automation needs and build/validate mappings.
To thrive in this role, you must have intermediate+ level experience with SQL programming and advanced MS Excel experience to develop processes and create clear and accurate reports for internal team members. This position needs someone that thrives in combining technical SQL skills and critical thinking/project-based analysis skills.
Here’s what you will experience working as a SQL Denials Automation Associate:
-
Identify and implement opportunities to optimize internal processes through SQL automation.
-
Review various data sets for inconsistencies, errors, or omissions, as well as work with internal teams to import, cleanse and leverage data fields.
-
Recommend and assist in implementation of techniques and processes to improve productivity, increase efficiencies, cut costs, and take advantage of potential revenue expanding opportunities.
-
Design and maintain ETL pipelines as well as assist database administrators with SQL Server maintenance and updates.
Required Skills:
-
Strong conceptual, quantitative, and qualitative analytical skills.
-
Intermediate+ level experience with SQL programming.
-
Experience with ETL processes in a SQL environment.
-
Understanding of ICD-10, HCPCS/CPT coding, medical terminology.
-
Understanding of EOB and hospital billing form (UB-04) requirements.
-
Proficient in Microsoft Excel (experience using Microsoft Access is a plus).
For this US-based position, the base pay range is $64,657.00 - $80,821.00 per year . Individual pay is determined by role, level, location, job-related skills, experience, and relevant education or training.This job is eligible to participate in our annual bonus plan at a target of 10.00%
The healthcare system is always evolving — and it’s up to us to use our shared expertise to find new solutions that can keep up. On our growing team you’ll find the opportunity to constantly learn, collaborate across groups and explore new paths for your career.
Our associates are given the chance to contribute, think boldly and create meaningful work that makes a difference in the communities we serve around the world. We go beyond expectations in everything we do. Not only does that drive customer success and improve patient care, but that same enthusiasm is applied to giving back to the community and taking care of our team — including offering a competitive benefits package.
R1 RCM Inc. (“the Company”) is dedicated to the fundamentals of equal employment opportunity. The Company’s employment practices , including those regarding recruitment, hiring, assignment, promotion, compensation, benefits, training, discipline, and termination shall not be based on any person’s age, color, national origin, citizenship status, physical or mental disability, medical condition, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status or any other characteristic protected by federal, state or local law. Furthermore, the Company is dedicated to providing a workplace free from harassment based on any of the foregoing protected categories.
If you have a disability and require a reasonable accommodation to complete any part of the job application process, please contact us at 312-496-7709 for assistance.
CA PRIVACY NOTICE: California resident job applicants can learn more about their privacy rights California Consent
To learn more, visit: R1RCM.com
Visit us on Facebook
Top Skills
What We Do
R1 is a leading provider of technology-driven solutions that transform the patient experience and financial performance of healthcare providers
R1’s proven and scalable operating models seamlessly complement a healthcare organization’s infrastructure, quickly driving sustainable improvements to net patient revenue and cash flows while reducing operating costs and enhancing the patient experience.
