"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!

Salary Range
$68,000.00 - $120,500.00

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

1. Financial Modeling and Forecasting. Provides technical analysis to determine present and future financial performance. Organizes information from a variety of sources for use in analyzing future plans and forecasts. Collaborates with all levels of management, both internally and externally, to gather, analyze, summarize, prepare, and present recommendations regarding financial plans and other complex financial matters. Researches and evaluates information to resolve issues and makes recommendations. Develops and/or executes complex financial models.
2. Financial Analysis and Reporting. Analyzes and synthesizes information and designs and creates accurate and timely reports. Designs financial reporting to meet the compliance needs of internal and external users. Extracts and consolidates data from multiple sources.
3. Financial Methods and Systems. Contributes to the planning and improvement of practices, processes and systems. Collaborates with all levels of internal and external contacts to carry out department goals. Provides a high level of service that cultivates and maintains strong working relationships and communicates effectively; takes ownership and accountability for timeliness, accuracy and relationship management.
4. Strategic Resource. Translates department finance goals into objectives. Identifies and raises potential financial opportunities, issues, risks, ideas and solutions. Identifies the appropriate stakeholders to include in consultations, communications, approvals or buy-ins for designing and implementing changes.
5. Compliance and Risk Management. Establishes, implements and/or maintains strong internal controls in areas of assigned responsibility to provide reasonable assurance of effective and appropriate resource use, accurate financial information, and adherence to contractual obligations and agreements, policies, procedures, and external regulatory requirements.
6. Mentors, leads and/or supervises staff.
7. May perform other duties as assigned.

Required Education and Experience

Bachelor’s degree in Accounting, Business, Economics or Finance and four years of related experience or an equivalent combination of education and experience. Demonstrated application of financial, accounting and economic concepts.