Financial Analyst

　　MISSION STATEMENT

　　The mission of The University of Texas M. D. Anderson Cancer Center is to eliminate cancer in Texas, the nation, and the world through outstanding programs that integrate patient care, research and prevention, and through education for undergraduate and graduate students, trainees, professionals, employees and the public.

　　SUMMARY

　　Provides accounting support for Clinical Research financial and operational activities of the Department of Lymphoma/Myeloma.

　　KEY FUNCTIONS

　　Financial Analysis & Reporting

　　· Prepare and maintain reports for all industry sponsored studies belonging to assigned PIs that show the financial status of each study, including both current revenue and expenses along with anticipated revenue and expenses.

　　· Prepare and maintain reports for all assigned PIs summarizing free balances for all ancillary accounts (30s, 40s, 80s, etc.).

　　· Provide account information when study team members and PIs need to make purchases or request services or new hires.

　　· Regularly review all invoices from other departments within MD Anderson for accuracy and ensure that they are paid in a timely manner - IDSR, CTRC, etc.

　　· Assist in creating reports and database applications to promote better flow of information between different groups within the department.

　　· Review and complete monthly Statistical Sampling entries for assigned PIs by institutional deadlines.

　　· Review and analyze data from above reports to identify trends or problem areas and formulate strategic solutions to address any deficiencies.

　　· Regularly meet with assigned faculty to review financial account status and provide updates regarding invoicing and payments, as well as discuss personnel financing and plan for their continued support.

　　· Provide guidance and advice to faculty regarding the appropriate use of funds according to institutional policies and procedures.

　　· Maintain projections of current and anticipated personnel spending along with anticipated personnel funding.

　　· Create break even report for PI clinical trial portfolio and determine their team's monthly burn rate.

　　· Review all sources of personnel funding (infrastructure accounts, department accounts, and any relevant individual study accounts) to ensure all personnel are being charged to the correct accounts.

　　· Prepare and process ePAFs for new hires, staffing changes, or to correct any errors or study deficits.

　　· Regularly calculate personnel money earned on each sponsored project, and regularly prepare IDTs to move that personnel funding from individual study accounts to fund the personnel Infrastructure Accounts.

　　· Assist in the preparation of other monthly and annual financial reports as assigned.

　　· Collaborate with alliance team, manage complex Alliance trials for faculty, calculate and request internal budget transfer, provide quarterly expense report to the sponsor or CRO

　　· Resolve issues related to accounting transactions and reconciliation items.

　　· Ensure clear out deficits, accuracy of revenue and expenses, residual transfer and study close out.

　　· Review actuals vs budgets, monitor patient enrollments, oversee spending trending, analyze protocol financial situation, adjust as necessary.

　　· Ensure budgets are being adhered to and expenses are allowable.

　　· Review BAF, track protocol amendment, ensure core fund is included and all costs are reflected in budget.

　　· Request no cost extensions. Follow up advance set up for CFS.

　　Invoicing

　　Review all sponsored contracts and invoice as appropriate on a timely basis.

　　Review accounts to be sure that all invoices have been paid and that all automatic payments have been received as expected.

　　Coordinate with Grants & Contracts to make sure that the accounting for all invoices is accurate and all payments are posted to the correct accounts.

　　Review hospital billing records, study accounts, and coordinate with study teams to be sure that all invoiceables listed on the contract are properly invoiced.

　　Review patient travel reimbursement submissions from the patient, review for accordance with sponsor's contract and institutional rules, prepare check request submissions, prepare invoices for sponsor reimbursement, and monitor accounts to be sure that all patients have been properly reimbursed and all reimbursements have been paid by the sponsor. Analyze and manage travel reimbursement BOA prepaids GL account

　　Coordinate with Pre-Award on contract amendments for those studies where the existing contract does not provide adequate coverage for the expenses incurred.

　　Ensure timely invoicing for both milestone and regular visits, follow up and collect payment, ensure payment is being allocated correctly.

　　Reconcile EPIC research charge to GL, identify variance and findings, conduct a solution. Ensure all research costs are covered or advise if negotiation/amendment is needed.

　　Effort Certification

　　· Coordinate the quarterly effort certification process in accordance with institutional policy.

　　· Review all effort cards for alignment with department records.

　　· Meet with principal investigators to review their own effort cards as well as the cards for all employees whose salary is supported from their sponsored projects.

　　· Monitor ECC system to track timely certification and processing of reports.

　　· Process all ePAFs/retros needed to ensure that the effort certified matches actual payroll.

　　· Maintain high level of expertise for effort certification through educational opportunities and interactions with Grants & Contracts personnel.

　　The performance for all functions is measured by observation by supervisor, reports from faculty and co-workers, the accuracy and timeliness of work produced, and the demonstrated ability to effectively work under stress. The position also requires one to anticipate needs, to recognize situations requiring assistance and have the ability to refer or perform any necessary tasks, and to comprehend the goals of the department and take the initiative in making decisions and taking actions to further these goals.

　　The above functions require the following abilities and skills:

　　· Demonstrated proficiency in MS Excel, MS Access, Hyperion, and other institutional financial systems.

　　· Demonstrated thorough working knowledge of institutional and state guidelines, which include purchasing, check requests, petty cash and travel. Also, a demonstrated working knowledge of mainframe access programs to monitor company center activities.

　　· Ability to practice independently, strong verbal and written communication skills, organizational and critical judgment skills, and be able to interact effectively with patients and co-workers.

　　· Strong attention to detail.

　　· Ability to work with personal computers using standard word processing software, spreadsheets, and programs for database and graphics usage.

　　· Ability to maintain a satisfactory work environment by organizing and redistributing files, records, etc., requiring bending, stooping, reaching, manual handling, walking, visually inspecting, extended standing, sitting and repetitive motions. May be required to lift up to 15 pounds.

　　· Requires use of computer via keyboard, and operating facsimile machine, calculator, printer, photocopy machine, etc. Requires the use of push-button, multiple line telephone set. Must be able to master new software by utilizing available resources (other program personnel, reference manual, training classes, etc.)

　　· Be clearly understood by verbal communication in face-to-face encounters and by telephone.

　　· Strong command of the English language, including spelling, writing, and verbalizing and ability to communicate well verbally and in writing.

　　Other duties as assigned.

　　Bachelor's degree in Business Administration or related business specialty. Two years business experience to include project management, data analysis or accounting. It is the policy of The University of Texas MD Anderson Cancer Center to provide equal employment opportunity without regard to race, color, religion, age, national origin, sex, gender, sexual orientation, gender identity/expression, disability, protected veteran status, genetic information, or any other basis protected by institutional policy or by federal, state or local laws unless such distinction is required by law. http://www.mdanderson.org/about-us/legal-and-policy/legal-statements/eeo-affirmative-action.html

　　Additional Information

　　Requisition ID: 165075

　　Employment Status: Full-Time

　　Employee Status: Regular

　　Work Week: Days, Evening/Night, Varied

　　Minimum Salary: US Dollar (USD) 66,000

　　Midpoint Salary: US Dollar (USD) 82,500

　　Maximum Salary : US Dollar (USD) 99,000

　　FLSA: exempt and not eligible for overtime pay

　　Fund Type: Soft

　　Work Location: Remote (within Texas only)

　　Pivotal Position: No

　　Referral Bonus Available?: No

　　Relocation Assistance Available?: No

　　Science Jobs: No

　　#LI-Remote