Rev Cycle Analyst Cash Ops

Job Details Revenue Cycle Analyst Cash Ops Job Description The Rev Cycle Analyst Cash Ops, plays a critical role in supporting the reconciliation, reporting, and data management functions within the Cash department. Reporting directly to the Manager, Cash Operations & Systems, Reporting & Data Management, this role is responsible for executing daily and periodic cash and transactional reconciliations, identifying and resolving data discrepancies, and contributing to the accuracy and timeliness of financial reporting. The ideal candidate possesses strong analytical and technical skills, including advanced proficiency in Excel (pivot tables, Power Query, Power Pivot, and other Excel Power tools) SQL and data management tools, along with a solid understanding of financial processes. This role involves close collaboration with internal teams such as Finance, IT, and Operations, as well as external partners, to ensure data integrity and support ongoing process automation and reporting initiatives. The Analyst will help design and maintain automated reconciliation tools, build dynamic Excel/Power BI reports, document processes, and continuously identify opportunities for operational improvement. Essential Functions Interacts with co-workers, visitors, and other staff consistent with the values of Jefferson. Reconciliation Support Perform daily, weekly, and monthly cash and transactional reconciliations across internal systems and external sources (e.g., bank accounts, payment processors, and third-party billing vendors). Support reconciliation of Epic transactions to ensure accuracy in patient billing and financial reporting. Monitor and investigate discrepancies in cash, payment, and transaction data using internal reconciliation tools and cross-functional communication. Escalate unresolved variances or high-risk issues to the Manager for resolution. Third-Party Reconciliation Assist in managing and validating reconciliation processes related to third-party billing and payment vendors. Collaborate with vendor contacts and internal teams to troubleshoot and resolve issues affecting external reconciliations. Compliance & Controls Ensure reconciliation activities are conducted in accordance with internal control policies, compliance standards, and audit guidelines. Maintain accurate documentation for audit trails, supporting reports, and exception tracking. Reporting & Data Management Prepare and deliver routine and ad hoc reports on reconciliation status, variances, and performance metrics. Support efforts to improve automation and standardization of reconciliation workflows using SQL or similar tools, under the guidance of the Manager. Contribute to data quality initiatives by validating financial data and ensuring accuracy across systems. Competencies (Knowledge, Skills, and Abilities Required): Strong ability to write coding formulas in tools such as Excel, Access, and SQL to support complex data analysis Basic scripting and automation VBA and Macros Advanced MS Excel and Access Data integrity and validation techniques Strong technical proficiency Strong attention to detail Minimum Education and Experience Requirements: High School Diploma required, Associate’s in computer science preferred AND Experience: 1 year of progressive experience in finance, accounting operations, or revenue cycle management with at least one year experience in SQL Proficient technical expertise required in Excel tools including Power Query, Power Pivot, and Pivot Tables; SQL for data extraction and reconciliation. Work Shift Workday Day (United States of America) Worker Sub Type Regular Employee Entity Jefferson University Physicians Primary Location Address 615 Chestnut Street, Philadelphia, Pennsylvania, United States of America Nationally ranked, Jefferson, which is principally located in the greater Philadelphia region, Lehigh Valley and Northeastern Pennsylvania and southern New Jersey, is reimagining health care and higher education to create unparalleled value. Jefferson is more than 65,000 people strong, dedicated to providing the highest-quality, compassionate clinical care for patients; making our communities healthier and stronger; preparing tomorrow's professional leaders for 21st-century careers; and creating new knowledge through basic/programmatic, clinical and applied research. Thomas Jefferson University, home of Sidney Kimmel Medical College, Jefferson College of Nursing, and the Kanbar College of Design, Engineering and Commerce, dates back to 1824 and today comprises 10 colleges and three schools offering 200 undergraduate and graduate programs to more than 8,300 students. Jefferson Health, nationally ranked as one of the top 15 not-for-profit health care systems in the country and the largest provider in the Philadelphia and Lehigh Valley areas, serves patients through millions of encounters each year at 32 hospitals campuses and more than 700 outpatient and urgent care locations throughout the region. Jefferson Health Plans is a not-for-profit managed health care organization providing a broad range of health coverage options in Pennsylvania and New Jersey for more than 35 years. Jefferson is committed to providing equal educational and employment opportunities for all persons without regard to age, race, color, religion, creed, sexual orientation, gender, gender identity, marital status, pregnancy, national origin, ancestry, citizenship, military status, veteran status, handicap or disability or any other protected group or status. Benefits Jefferson offers a comprehensive package of benefits for full-time and part-time colleagues, including medical (including prescription), supplemental insurance, dental, vision, life and AD&D insurance, short- and long-term disability, flexible spending accounts, retirement plans, tuition assistance, as well as voluntary benefits, which provide colleagues with access to group rates on insurance and discounts. Colleagues have access to tuition discounts at Thomas Jefferson University after one year of full time service or two years of part time service. All colleagues, including those who work less than part-time (including per diem colleagues, adjunct faculty, and Jeff Temps), have access to medical (including prescription) insurance. For more benefits information, please click here In keeping with Jefferson's Mission, We Improve Lives, it is our goal to recruit, retain, develop and reward highly-qualified employees. If you are enthusiastic, caring and dedicated to service excellence, we invite you to consider joining Jefferson. Jefferson encourages its employees to expand their knowledge and develop their careers through growth opportunities and continuing education. With a long standing history, Jefferson has been advancing the medical field from the heart of Center City Philadelphia for nearly 200 years. Our Mission, We Improve Lives, expands to every corner of the organization. From our weekly farmer’s market, to our new Jefferson Accelerator Zone for innovation, our employees’ passion for the community is evident by the daily gestures towards our patients, students and each other.