YCCI USP Billing Specialist

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community, eligible for opportunities through the New Haven Hiring Initiative, or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

Overview
Yale Center for Clinical Investigations (YCCI) is seeking a highly motivated and detail-oriented University Service Provider (USP) Data Analyst and Billing Specialist. This position will be responsible for analyzing data from various YCCI service lines, with a specific focus on accurately reconciling and charging study-specific fees for tasks completed by these service lines to the respective study accounts.

The ideal candidate will have a strong background in data analysis and financial management, along with exceptional analytical skills. Experience in using multiple data tracking systems, including Workday, Salesforce, and OnCore, is preferred.

Key Responsibilities

• Data Analysis:
  • Collect and analyze data from various university service providers related to services utilized by different departments and study accounts.
  • Develop and implement data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
  • Interpret data, analyze results using statistical techniques, and provide ongoing reports.
• Billing and Reconciliation:
  • Prepare and process billing based on the services rendered to different departments and study accounts, ensuring accuracy and timeliness.
  • Monthly study invoice generation and submission to DBOs/PIs for research service billing, and track through to approval within stated timelines.
  • Post-approval, execute transactions to move internal revenue for cost recovery for services rendered by YCCI resources (Workday).
  • Reconcile discrepancies between service provider data and billing statements, and resolve billing issues through investigation and communication with the service providers and study teams.
  • Maintain accurate financial records in shared directories.
  • Respond to study team inquiries within 24 hours of receipt.
  • Resolve and document DBO/PI service billing inquiries and escalate as needed to ensure timelines are met.
• Financial Reporting:
  • Generate financial reports and statements to assist in future budget preparation, forecasting, and financial planning.
  • Provide detailed and summary reports on the utilization of services, billing patterns, and budget variance analysis.
  • Collaborate with the finance and accounting teams to support overall financial management and auditing processes.
• Stakeholder Communication:
  • Serve as the primary point of contact between university departments, study account holders, and service providers for billing and data-related inquiries.
  • Facilitate regular meetings with stakeholders to discuss utilization, billing discrepancies, and account reconciliations.
• Process Improvement:
  • Identify opportunities for process improvements in data collection, billing procedures, and reconciliation techniques.
  • Work with IT and other departments to develop and implement systems enhancements that streamline data analysis and billing processes.
• Special Projects:
  • Support and coordinate the annual USP rate setting process in collaboration with functional area leads of YCCI.
  • Support and coordinate new, amended, and annual renewals of YCCI service agreements with department DBOs and PIs and maintain related files.

Required Skills and Abilities
1. Strong analytical and quantitative skills with proficiency in financial modeling and data analysis.
2. Excellent oral and written communication skills, with the ability to adapt communication style to various audiences.
3. Advanced computer skills, particularly in Microsoft Excel, Word, and other relevant software.
4. Ability to manage multiple priorities, meet deadlines, and operate effectively in a fast-paced environment.
5. Demonstrated ability to work independently and as part of a team, showing initiative and problem-solving abilities.
Preferred Skills and Abilities
1. Bachelor's degree in Accounting, Finance, Data Science, Business Administration, or a related field.
2. Minimum of 3 years of experience in data analysis, financial management, or billing.
3. Minimum of 2 years' experience in invoicing, collecting, and reconciliation of clinical trial study accounts.
4. Proficiency with data analysis tools and software preferred (e.g., Excel, OnCore, Workday and Salesforce).
5. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

6. Excellent verbal and written communication skills.

7. Ability to work collaboratively and independently in a team-oriented environment.

8. Knowledge of university financial systems and policies is an asset.

Principal Responsibilities

Job Posting Date

Job Category

Bargaining Unit

Compensation Grade

Compensation Grade Profile

Salary Range