Excellus Health Plan Inc.
Treasury Coordinator I - 005863 (Finance)
The Treasury Coordinator is responsible for balancing and audit of premium and claims expense to actual deposits and disbursements made from/to providers, groups and subscribers from various systems including the national Blue Card system. This position investigates and works to resolve all operational issues identified during the financial balancing activities and initiates necessary requests for service to solve identified problems. In addition, the Treasury Coordinator performs assigned basic financial analysis and/or assists with testing activity related to the various reports and related processes and will be responsible for preparing a variety of reports used by Financial Reporting, Actuarial Services, Measures and Controls, and Treasury Management.
Essential Responsibilities/Accountabilities
Level I:
• Balances daily incoming and outgoing payments for more complex and/or evolving claims systems including but not limited to Blue Card and iFacets.
• Collects and analyzes division data, which will be used to identify and resolve system problems that result in discrepancies in the financial balancing reports.
• Performs assigned basic financial analysis, reconciling, balancing.
• Initiates and leads the research effort with IT and Claims when a payment run or Date of Service file is out of balance. Follows through to a conclusion and takes corrective action.
• Liaison between IT, Claims, Customer Service and Provider Relations to ensure timely and accurate payments are made to providers and subscribers in accordance with corporate policies.
• Releases checks and corresponding documentation for mailing.
• Releases the electronic payment file to the bank for processing before predetermined cutoff times.
• Works with various banks to identify and coordinate to resolution all transaction discrepancies, adjustments and bank errors.
• Maintains daily balancing totals using access databases and excel spreadsheets to verify month end file totals.
• Prepares monthly and annual 1099 balancing related to more complex claims systems.
• Assists in the development of balancing requirements and documenting procedures.
• Assists with the testing of balancing reports as a result of claims processing system changes.
• Completes research associated with check administrative problems within the department.
• Acts as a backup for the other members of the Treasury department whenever necessary.
• Prepares and/or maintains appropriate high level documentation of work.
• Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies' mission and values and adhering to the Corporate Code of Conduct.
• Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.
• Regular reliable attendance is expected and required.
• Performs other functions as assigned by management.
Level II:
In addition to Level I responsibilities:
• Performs assigned basic financial analysis, reconciling, balancing
• Works with various banks to identify and coordinate resolution or all transaction discrepancies, adjustments, and bank errors.
• As a member of a requirements team, assists in the definition of requirements for improving existing processes and/or developing new processes supporting the operational activities of the Cash Management Department.
• Performs testing of pre-defined sets of financial reports with little direction.
• Prepares regular and periodic reports for the review and guidance of management
• Identifies all transactions and records information on the appropriate cash control database by using daily reports produced by various bank software programs
• Analyzes trends regarding problematic issues and make recommendations to management offering suggestions and input on process improvement opportunities
• Performs assigned basic financial analysis for supervisory review and makes recommendations based on the analysis completed.
• Considered subject matter expert for numerous payment balancing processes.
• Shares knowledge with newer department employees.
• Manages groups' grace days on appropriate systems
• Responsible for authenticating the integrity of all data housed in Treasury Operations owned databases.
Minimum Qualifications
NOTE:
We include multiple levels of classification differentiated by demonstrated knowledge, skills, and the ability to manage increasingly independent and/or complex assignments, broader responsibility, additional decision making, and in some cases, becoming a resource to others. In addition to using this differentiated approach to place new hires, it also provides guideposts for employee development and promotional opportunities.
Level I:
• Associates degree in Accounting or Business and a minimum of four years of experience in finance or banking required. In lieu of degree six years in finance or banking required.
• Bachelor's degree preferred.
• Basic MS Excel skills required.
• Strong knowledge of MS Word, Access, PowerPoint, and mail databases required; Mainframe applications experience is preferred.
• Basic Cognos skills required.
• Demonstrated experience participating in the 1099 adjustment processes
• Familiarity with lower level requirements gathering
• Intermediate communication skills required.
• Must possess a high degree of professionalism and be able to establish effective working relationships with all levels of the corporation.
• Internal claims experience helpful.
Level II:
In addition to Level I qualifications:
• A minimum of five years of experience within Finance or banking
• Ability to perform basic testing of pre-defined test sets for complex claims systems.
Physical Requirements
************
The Lifetime Healthcare Companies aim to attract the best talent from diverse socioeconomic, cultural and experiential backgrounds, to diversify our workforce and best reflect the communities we serve.
Our mission is to foster an environment where diversity and inclusion are explicitly recognized as fundamental parts of our organizational culture. We believe that diversity of thought and background drives innovation which enables us to provide leading-edge healthcare insurance and services. With that mission in mind, we recruit the best candidates from all communities, to diversify and strengthen our workforce.
OUR COMPANY CULTURE:
Employees are united by our Lifetime Way Values & Behaviors that include compassion, pride, excellence, innovation and having fun! We aim to be an employer of choice by valuing workforce diversity, innovative thinking, employee development, and by offering competitive compensation and benefits.
In support of the Americans with Disabilities Act, this job description lists only those responsibilities and qualifications deemed essential to the position.
Equal Opportunity Employer
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Non Manager