RCM Analyst

Specialty1 Partners · Houston, Texas, United States

// classified as

Data Engineer (Pipelines, infra, ingestion, ETL.)

> stack

gosqlexcel

> description

Role Overview: The RCM Analyst supports the Revenue Cycle Management department through reporting, data analysis, and business intelligence activities, with primary responsibility for analytical support of the RCM Intelligence and Payor Relations functions. The RCM Analyst is expected to deliver accurate, timely, and actionable reporting and analysis that improves visibility into payor, credentialing, and revenue cycle performance.  The Analyst will identify meaningful trends and potential issues, support leadership decision-making with reliable data, maintain strong data integrity, and contribute to improvements in reporting efficiency and operational processes. This role requires solid technical skills in data analysis, database querying, and business intelligence tools. Healthcare and insurance knowledge is not a prerequisite, the RCM Intelligence Manager will provide domain training, but strong technical capability is required from day one    Essential Duties & Responsibilities:   Reporting & Analytics  <ul> <li>Develop, maintain, and enhance recurring reports, dashboards, scorecards, and ad hoc analyses supporting RCM operations. </li> <li>Collect, validate, organize, and analyze data from practice management systems, billing platforms, payor portals, credentialing systems, contract databases, and other data sources. </li> <li>Identify trends, variances, anomalies, and opportunities for improvement within operational and financial data. </li> <li>Support the development and monitoring of key performance indicators and provide timely reporting to leadership and business stakeholders. </li> <li>Perform data validation and reconciliation to ensure reporting accuracy, consistency, and integrity. </li> <li>Assist with automating recurring reports and improving reporting processes to reduce manual effort. </li> <li>Translate analytical findings into clear summaries, visualizations, and actionable insights for non-technical stakeholders. </li> <li>Participate in projects involving data integration, reporting improvements, system enhancements, and operational optimization. </li> </ul>  Payor Relations Support  <ul> <li>Analyze payor performance, reimbursement trends, negotiated rates, underpayments, denials, and reimbursement variances. </li> <li>Develop and maintain reporting processes to monitor negotiated reimbursement rates and payor compliance. </li> <li>Support benchmarking of reimbursement across commercial insurance, Medicare Advantage, Medicaid, and other payor arrangements. </li> <li>Assist with financial analysis related to payor contract negotiations, renewals, rate changes, and proposed contract terms. </li> <li>Maintain and update contract and reimbursement information within internal databases and reporting tools. </li> <li>Develop analyses and models to quantify the potential financial impact of reimbursement changes and other payor-related initiatives. </li> <li>Assist with identifying and escalating trends that may negatively impact reimbursement, collections, or overall revenue cycle performance. </li> <li>Support analysis of insurance contracts and reimbursement structures for existing and prospective practices. </li> <li>Credentialing Analytics Support </li> <li>Develop and maintain reporting related to provider credentialing, enrollment, participation, and related operational activities. </li> <li>Track and report on credentialing status, enrollment progress, aging, expirations, turnaround times, and outstanding requirements. </li> <li>Identify trends, bottlenecks, and opportunities to improve credentialing workflows and operational visibility. </li> <li>Support data reconciliation and validation between credentialing records, provider information, payor data, and other relevant systems. </li> <li>Maintain accurate and well-documented datasets related to providers, locations, payors, participation status, and credentialing activities. </li> </ul>   Qualifications  Education & Experience  <ul> <li>Bachelor's degree in Data Analytics, Business Analytics, Computer Science, Statistics, Information Systems, or a related technical field preferred. </li> <li>2 to 4 years of experience in data analysis, business intelligence, reporting, or related field. </li> <li>Demonstrated experience building reports and dashboards in Power BI or a comparable business intelligence platform required. </li> <li>Experience writing SQL queries to extract, transform, and analyze data from relational databases required. </li> <li>Experience working with financial, operational, or insurance-related data is an advantage but not required. </li> </ul> Knowledge, Skills & Abilities  <ul> <li>Proficiency in Power BI, including report building, data visualization, and working with data models. Experience with DAX measures is a strong plus. </li> <li>Working SQL skills with the ability to write queries independently, including joins, filters, aggregations, and subqueries. </li> <li>Advanced proficiency in Microsoft Excel, including formulas, pivot tables, lookups, and structured data analysis. </li> <li>Experience working with relational databases and understanding how data tables, relationships, and keys work. </li> <li>Familiarity with ETL concepts, data pipelines, or data integration between systems is preferred. </li> <li>Familiarity with healthcare data, practice management systems, billing platforms, or insurance data is helpful but can be developed on the job. </li> <li>Strong analytical and problem-solving skills with the ability to identify trends, variances, and meaningful patterns in data. </li> <li>Strong attention to detail and ability to work accurately with large and complex datasets. </li> <li>Ability to manage multiple priorities and complete assignments within established deadlines. </li> <li>Strong written, verbal, and presentation skills, with the ability to communicate analytical findings to both technical and non-technical stakeholders. </li> <li>Ability to work independently and collaboratively in a cross-functional environment. </li> <li>Commitment to data integrity, documentation, confidentiality, and continuous improvement. </li> </ul>   Working Conditions:  <ul> <li>Must be able to sit/stand for extended periods of time. </li> <li>Must be able to reach overhead as needed. </li> <li>Must be able to lift and carry up to 25 pounds as needed. </li> <li>Must be able to work in a fast-paced environment. </li> <li>Must be able to maintain attention to detail for extended periods. </li> <li>Must be able to operate standard office equipment. </li> <li>Must be able to work flexible hours, including evenings or weekends, if required. </li> <li>Must be able to perform duties with or without reasonable accommodation. </li> </ul>   Benefits: <ul> <li>BCBS High Deductible & PPO Medical Insurance Options </li> <li>VSP Vision Coverage   </li> <li>BCBS PPO Dental Insurance   </li> <li>Complimentary Life Insurance Policy   </li> <li>Short-term & Long-Term Disability   </li> <li>Pet Insurance Coverage  </li> <li>401(k) plan </li> <li>HSA / FSA Account Access </li> <li>Identity Theft Protection </li> <li>Legal Services Package </li> <li>Hospital/Accident/Critical Care Coverage </li> <li>Paid Time Off   </li> <li>Diverse and Inclusive Work Environment   </li> <li>Base salary and bonus structure</li> </ul>   About Us:  Specialty1 Partners is a practice services organization committed to providing non-clinical, business support services to the nation's leading specialty dental practices. The company was founded in 2019 by four endodontists who wanted to provide unique and differentiated support to specialty dental practices. Originally focusing on support to endodontics practices (under the Endo1 brand), Specialty1 Partners quickly expanded its support to periodontics and oral surgery practices. Since its founding, Specialty1 Partners has grown rapidly to become one of the largest private owners of specialty dental practices in the US. Headquartered in Houston, TX, Specialty1 Partners is led by its founders and a management team that is focused on ongoing growth and delivery of best-in-class services across its network of practices. Specialty1 Partners currently has over 230 locations across 28 states.   1800 West Loop S. Suite 2000, Houston, TX 77027<div class="content-pay-transparency"><div class="pay-input"><div class="description">We believe in transparency through the talent acquisition process; we support our team members, past, future, and present, to make the best decision for themselves and their families. Starting off on the right foot with pay transparency is just one way that we are supporting this mission. </div><div class="title">Position Base Pay Range</div><div class="pay-range">$70,000—$80,000 USD</div></div></div><div class="content-conclusion"><div>Specialty1 Partners is the direct employer of non-clinical employees only. For clinical employees, the applicable practice entity listed above in the job posting is the employer. Specialty1 Partners generates job postings and offer letters to assist with human resources and payroll support provided to the applicable practice. Clinical employees include dental assistants and staff assisting with actual direct treatment of patients. Non-clinical employees include the office manager, front desk staff, marketing staff, and any other staff providing administrative duties.</div> Specialty1 Partners and its affiliates are equal-opportunity employers who recognize the value of a diverse workforce. All suitably qualified applicants will receive consideration for employment based on objective criteria and without regard to the following (which is a non-exhaustive list): race, color, age, religion, gender, national origin, disability, sexual orientation, gender identity, protected veteran status, or other characteristics in accordance with the relevant governing laws. Specialty1 Partners' Privacy Policy and CCPA statement are available for view and download at <a href="https://www.specialty1partners.com/privacy-policy/">https://www.specialty1partners.com/privacy-policy/</a>  Specialty1 Partners and all its affiliates participate in the federal government’s E-Verify program. Specialty1 further participates in the E-Verify Program on behalf of the clinical practice entities which are supported by Specialty1. E-Verify is used to confirm the employment authorization of all newly hired employees through an electronic database maintained by the Social Security Administration and Department of Homeland Security. The E-Verify process is completed in conjunction with a new hire’s completion of Form I-9, Employment Eligibility Verification upon commencement of employment. E-Verify is not used as a tool to pre-screen candidates. For up-to-date information on E-Verify, go to <a href="https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.e-verify.gov%2F&data=05%7C01%7C%7Cbb038f33015f45d6fbcd08dbe9f93dbf%7C3a8040a2d24d4afabb7e3e8813baf4a7%7C0%7C0%7C638361028924275990%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=pMta90FMBgnG7yNjpYdsaKABDdnFscTpYIi8rIPh3F4%3D&reserved=0" target="_blank" data-auth="Verified" data-linkindex="0">www.e-verify.gov</a> and click on the Employees Link to learn more. Specialty1 Partners and its affiliates uses mobile messages in relation to your job application. Message frequency varies. Message and data rates may apply. Reply STOP to opt-out of future messaging. Reply HELP for help. View our Privacy & SMS Policy <a href="https://www.specialty1partners.com/privacy-policy/" target="_blank">here. </a>By submitting your application you agree to receive text messages from Specialty1 and its affiliates as outlined above.  <div style="text-align: justify;"> </div></div>