(While navigating through the site, please be sure to disable your pop-up blocker.)
Associate Financial Analyst
The Associate Financial Analyst will provide analytical support for the financial and budget activities of five areas: three sections of the Palliative, Rehab, Integrative Medicine Department.
The role will include a variety of duties including: data analysis, advance reporting and database creation, financial forecasts, assistance with budget preparations, and long-term planning and assist with variance explanation preparation. This position will be expected to use their financial background in the completion of job duties and problem solving.
JOB SPECIFIC COMPETENCIES
Financial Analysis and Operational Reporting
1. Develop complex reporting systems capable of providing customizable reports via coding and macros utilized for operational decision-making. Including by not limited to the following:
2. Purchase order management.
3. Free Balance/ Cash Balance monitoring
* 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.
* Analyze departmental accounting and financial operations on a continuous basis; discuss findings with senior management and makes recommendations for policy and/or operational changes.
* Verify availability of funds on accounts prior to requisition approval for department financial/purchasing/travel actions in compliance with internal controls.
* Maintain tracking mechanisms for invoicing and monitor general ledger for payment confirmation.
* 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.
* Review and educate faculty and staff on existing departmental and institutional financial policies and procedures necessary to assist with financial planning efforts, budget management of accounts, and department financial operations.
* Provide direction to financial staff, accounting staff, and administrative staff to ensure deadlines are met and standard operating procedures are followed. Conduct trainings covering departmental financial processes on an individualized and group basis.
* Understand variety of financial and operational systems variables and their definitions to utilize in creating a comprehensive analysis of department financial operations, including OneConnect (Crystal and WEBI), PeopleSoft, OBIEE, Hyperion Financial Planning, Oracle SmartView, Access, and FileMaker. Multifaceted systems are utilized to create customizable reports and dashboards specific to the financial needs of the department.
* Prepare and disseminate weekly mobile team census reports (not published institutionally) involving inpatient and outpatient service lines. Collaborate with faculty regarding reporting metrics and communicate changes effectively.
* Adhere to department leadership and faculty ad hoc reporting request.
4. Departmental Budget Preparation/Monitoring
* Perform current year forecasting of non-personnel expense and project future year budget figures while anticipating departmental needs. Discuss recommendations with Finance Manager and Director.
* Collaborate with the Finance Manager in developing the annual budget for the department to include three (3) sections and two (2) centers.
* Upload annual budget information utilizing the Hyperion Financial Planning/SmartView/OBIEE ad-hoc systems and analyzes all activity of prior year expenses, revenue projections, budget revisions, etc. to establish relative trends and activity patterns.
* Verify budget maintained in Hyperion Financial Planning for accuracy and is loaded correctly to the general ledger and monitors budget activity/margins throughout the fiscal year ensuring the department meets annual fiscal goals.
* Design complex financial reports to map trends and identify potential budgetary issues.
* Review actual expenses to budgeted expenses on a monthly basis and assist with variance explanation preparation.
5. Financial Account Management & Reconciliation
* Safeguard the daily operations of the departmental accounting systems to achieve maximum accuracy and efficiency of all department/center clinical and research funds, to include three sections and two centers.
* Ensure reconciliation process is conducted in accordance with MD Anderson Policy ADM1100 Department Fund Transaction Reviews.
* Review and complete monthly Statistical Sampling entries for assigned PIs by institutional deadlines.
* Ensure adherence of guidelines set forth by the institutional compliance office.
* Govern monetary instruments in adherence with the segregation of duties objective outlined by the Financial Controls Office. Work with cross-functional departments including Research Finance, Grants and Contracts, Treasury Services, Development Office to ensure proper handling of monetary instruments and proper payment postings.
* Prepare, process, and track ePAFs for new hires, staffing changes, or to correct any errors or study deficits.
* Assist in Effort Certification process by providing effort card inputs. Process all ePAFs/retros needed to ensure that the effort certified matches actual payroll.
* Develop monthly personnel expense reports based on personnel expense data sources. Monitor variances for eight (8) organizational codes and 180 organizational and research employees. Ensure institutional compliance with UT System Policy UTS142.1 by providing justification for any variances +/-10%. Review of ePAFs, personnel timesheets, and other Kronos generated reports (e.g. PVD report; PVJ/PVH report) are necessary for proper justification.
* 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.
* Serve as departmental liaison to the Division, Financial Controls, and other institutional contacts and outside agencies to follow-up and resolve financial issues.
* Develop applications and reports to enhance account creation, tracking, reconciliation and other general accounting practices within the department to ensure fulfilment of internal controls.
Other duties as assigned
EDUCATION:
Required: Bachelor's degree in Business Administration or related business specialty.
EXPERIENCE:
Required: None. May substitute required education degree with additional years of equivalent experience on a one to one basis.
Preferred: Budget Experience specifically in financial modeling and forecasting. Experience with Excel, Power BI.
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
