Sr Financial Analyst Genomic Medicine - MD Anderson
Houston, TX
About the Job
The primary purpose of the Senior Financial Analyst position is to apply accounting principles and techniques in meeting assigned responsibilities and in preparing data for financial reports to support the Faculty, Department Administrator and Grant Program Manager. This position requires independent thinking, independent production, independent problem-solving (both within and across departments) and initiative.
JOB SPECIFIC COMPETENCIES
Account Maintenance and Reconciliation:
* Ensures timely and accurate expense and income tracking by performing monthly reconciliations and reporting on departmental chart field strings including Staff Development funds for assigned faculty, Research M&O, Chairman's fund and other departmental designated and restricted funds (Fund Groups 10, 30 and 80). Monitors chart field string balances using the Status of Departmental Fund (SODF) reports. Important to also utilize the peoplesoft tool.
* Designs, creates, and maintains financial forecasting models for expenses for all funding sources. Meets regularly with senior management and principal investigators to review and monitor their financial portfolios. Monthly and quarterly reports will be needed.
* Designs, analyzes, and develops financial dashboard and statement for financial reports and tracking system for forecasting, trending, and result analysis. Performs budget-to-actual monitoring.
* Analyze accounts for budget to actual variances, specifically for Core Services and Patient Mosaic funds.
* Identifies policies, processes and procedures needing refinement and/or enhancement and makes recommendations for changes to senior management.
* Demonstrates superior knowledge of accounting expertise and progressive administrative leadership in the daily management of department's accounting system.
* Initiate, design, and implement accounting procedures according to institutional, divisional, and departmental guidelines/requirements and controls within departmental administrative and research sections for reporting and tracking fund activities.
* Provides accurate and timely budget reports and is able to present financial status and projections with clarity to internal and external stakeholders.
* Prepares and provides summarizing available funds to the Department Administrator for submission to the Division of Cancer Medicine, Physician Referral Services, etc.
* Reviews purchase requisitions and expenses for designated departmental chart field strings.
* Requests new chart field strings to the Development Office/Research Finance for internal grants, gifts, endowments, etc.
* Reviews invoices for accuracy and ensures that payments are received in a timely manner.
* Reviews Pos for correctness and processes closure requests.
* Audits assigned financial and administrative personnel on monthly basis to ensure consistency, accuracy and appropriate separation of duties is maintained. Researches, identifies and recommends solutions to problems which arise in the daily course of business. Personnel should be on appropriate CFS and not in default.
* Maintains controlling records required to ensure accuracy of all data in the accounting system for designated departmental chart field strings.
* Provides recommendations and creates more efficient methods for financial management through macro creation, standard operating procedure preparation and enhanced reporting.
* Pulls data and creates ad hoc OBIEE dashboard reports based on routine departmental needs.
* Ensures compliance with departmental, institutional and state guidelines and reports discrepancies to Department Administrator and Grant Program Manager.
* Interacts with all levels of personnel within the department, other institutional departments, as well as outside companies to resolve problems/errors or questions regarding basic accounting reconciliation items.
* Submit NSCTs for all chartfields within the department
Grants and Contracts Management
* Responsible for correct and timely salary allocation on all assigned grants (Fund Group 90) by utilizing the Personnel Trending Report in OBIEE.
* Provides assistance to faculty in the expenditure of funds available to them through the dissemination of information and guidelines of the various sponsoring agencies. Serves as a Fund Manager and resource for directors, principal investigators in all aspects of planning and managing the finances for their grant activities.
* Assists with creating grant budgets, re-budget requests and budget transfer requests for initial grant proposals and subsequent funding years.
* Provides monthly projection reports to faculty, Department Administrator and Grant Program Manager regarding grant financial status including salary projections for all personnel. Meets with faculty and works closely with the Grant Program Manager to resolve any accounting issues and/or discrepancies.
* Conducts monthly financial meetings with Faculty including Grant Program Manager.
* Pulls financial data from multiple institutional sources and consolidates information in meaningful way, advises faculty and presents complex financial information to all levels of personnel.
* Assists with contract submission through RCTS.
* Responsible for the account maintenance in PeopleSoft for designated chart field signers.
* Serves as a Fund Manager and resource for directors, principal investigators in all aspects of planning and managing the finances for their grant activities.
* Works independently and collaboratively with research team to ensure that protocol research charges tickets is appropriately captured and billed. Resolves charges capture and billing issues. Works with Patient Business Services and Research Finance Office as needed.
* Responsible for all stages of research funding management, from pre-award activities working closely with principal investigators to create Coeus and budget proposal and submission of contract and grant proposals, to post-award research financial administration; assist in establishing controls as needed to ensure full compliance.
* Oversees and processes effort reporting.
* Draft BAF requests as outlined in the NOGAs and make necessary adjustments as needed. Responsible for ensuring that grants are setup in PeopleSoft correctly according to the budget and/or BAF.
* Consistently monitors grants during the project life cycle and prepares them for closeout.
* Performs monthly audits of grant account reconciliation reports for designated departmental chart field strings to ensure compliance with departmental, institutional, and state guidelines and reports audit findings to Grant Program Manager & Department Administrator.
* Collaborates with grant personnel to ensure funding components including subcontracts are budgeted correcting in PeopleSoft. Performs budget transfers if needed.
Core Services and Department Management
* Acts as a resource to administrative support staff regarding fund expenditure guidelines, purchasing procedures, and travel reimbursements.
* Responsible for adhering to institutional and state guidelines and deadlines to include purchasing, fiscal, and travel
* Monitors project invoicing for designated Core Services
* Prepares monthly statement of operations reports, monthly variance reports and various cost analysis reports to Core Director.
* Assists in preparing and managing budget, pricing, reconciliation and account management for designated Institutional Core Services
* Responsible for reviewing purchase orders for funding source
* Responsible for maintaining the CAT Tool per award setups
* Responsible for completing the STAT sampling for Genomic Medicine, Operational Priorities, STRIDE, and Therapeutics Discovery.
* Prepares and analyzes Personnel Trending for department and researches and documents variances for Genomic Medicine and Prime-TR.
* Responds to faculty, Department Administrator and Grant Program Manager's inquiries regarding budget and expenses.
* Performs audits of any and all departmental funds at the request of Chair, DA or Grant Program Manager.
* Responsible for compliance with institutional, state and federal regulations and requirements and ensures departmental system of internal controls are met.
* Ability to organize, prioritize and complete work in a timely manner under a fluctuating workload and competing deadlines.
* Proactively identifies process and system deficiencies and bring them to resolution. Proven track record of success in managing a range of financial activities.
* Processes payroll reconciliations including institutional, philanthropic, gift, industry, and foundation sponsored funds.
* Overviews monthly statistical sampling reports and personnel trending reports for Division and Financial Control Office.
* Develops and maintains a comprehensive financial/protocol database capable of query to reconcile research charge tickets vs Memo Bills posting.
* Demonstrated ability to work with confidential and privileged information. Maintains sensitive information and records and exhibits appropriate sensibility regarding not sharing sensitive information unnecessarily.
* Goes beyond normal scope of duties to ensure financial resources are optimally utilized and safeguarded.
* Effectively coordinates resources and projects with other MDACC departments.
* Oversees administrative support staffs in the monthly purchase orders, ePAF updates.
Other duties as assigned.
EDUCATION:
Required: Bachelor's degree in Business Administration or related business specialty.
EXPERIENCE:
Required: Five years experience in data analysis, accounting or financial project management.
Preferred: Ideal candidate will be familiar in MDACC systems, such as ResourceOne, PeopleSoft, EIW, SmartStream, FReD, Coeus, ClnicStation, MSDS Online, OnBase, NetPass, Microsoft Excel, Word, PowerPoint, Visio, etc.
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
#LI-Remote
JOB SPECIFIC COMPETENCIES
Account Maintenance and Reconciliation:
* Ensures timely and accurate expense and income tracking by performing monthly reconciliations and reporting on departmental chart field strings including Staff Development funds for assigned faculty, Research M&O, Chairman's fund and other departmental designated and restricted funds (Fund Groups 10, 30 and 80). Monitors chart field string balances using the Status of Departmental Fund (SODF) reports. Important to also utilize the peoplesoft tool.
* Designs, creates, and maintains financial forecasting models for expenses for all funding sources. Meets regularly with senior management and principal investigators to review and monitor their financial portfolios. Monthly and quarterly reports will be needed.
* Designs, analyzes, and develops financial dashboard and statement for financial reports and tracking system for forecasting, trending, and result analysis. Performs budget-to-actual monitoring.
* Analyze accounts for budget to actual variances, specifically for Core Services and Patient Mosaic funds.
* Identifies policies, processes and procedures needing refinement and/or enhancement and makes recommendations for changes to senior management.
* Demonstrates superior knowledge of accounting expertise and progressive administrative leadership in the daily management of department's accounting system.
* Initiate, design, and implement accounting procedures according to institutional, divisional, and departmental guidelines/requirements and controls within departmental administrative and research sections for reporting and tracking fund activities.
* Provides accurate and timely budget reports and is able to present financial status and projections with clarity to internal and external stakeholders.
* Prepares and provides summarizing available funds to the Department Administrator for submission to the Division of Cancer Medicine, Physician Referral Services, etc.
* Reviews purchase requisitions and expenses for designated departmental chart field strings.
* Requests new chart field strings to the Development Office/Research Finance for internal grants, gifts, endowments, etc.
* Reviews invoices for accuracy and ensures that payments are received in a timely manner.
* Reviews Pos for correctness and processes closure requests.
* Audits assigned financial and administrative personnel on monthly basis to ensure consistency, accuracy and appropriate separation of duties is maintained. Researches, identifies and recommends solutions to problems which arise in the daily course of business. Personnel should be on appropriate CFS and not in default.
* Maintains controlling records required to ensure accuracy of all data in the accounting system for designated departmental chart field strings.
* Provides recommendations and creates more efficient methods for financial management through macro creation, standard operating procedure preparation and enhanced reporting.
* Pulls data and creates ad hoc OBIEE dashboard reports based on routine departmental needs.
* Ensures compliance with departmental, institutional and state guidelines and reports discrepancies to Department Administrator and Grant Program Manager.
* Interacts with all levels of personnel within the department, other institutional departments, as well as outside companies to resolve problems/errors or questions regarding basic accounting reconciliation items.
* Submit NSCTs for all chartfields within the department
Grants and Contracts Management
* Responsible for correct and timely salary allocation on all assigned grants (Fund Group 90) by utilizing the Personnel Trending Report in OBIEE.
* Provides assistance to faculty in the expenditure of funds available to them through the dissemination of information and guidelines of the various sponsoring agencies. Serves as a Fund Manager and resource for directors, principal investigators in all aspects of planning and managing the finances for their grant activities.
* Assists with creating grant budgets, re-budget requests and budget transfer requests for initial grant proposals and subsequent funding years.
* Provides monthly projection reports to faculty, Department Administrator and Grant Program Manager regarding grant financial status including salary projections for all personnel. Meets with faculty and works closely with the Grant Program Manager to resolve any accounting issues and/or discrepancies.
* Conducts monthly financial meetings with Faculty including Grant Program Manager.
* Pulls financial data from multiple institutional sources and consolidates information in meaningful way, advises faculty and presents complex financial information to all levels of personnel.
* Assists with contract submission through RCTS.
* Responsible for the account maintenance in PeopleSoft for designated chart field signers.
* Serves as a Fund Manager and resource for directors, principal investigators in all aspects of planning and managing the finances for their grant activities.
* Works independently and collaboratively with research team to ensure that protocol research charges tickets is appropriately captured and billed. Resolves charges capture and billing issues. Works with Patient Business Services and Research Finance Office as needed.
* Responsible for all stages of research funding management, from pre-award activities working closely with principal investigators to create Coeus and budget proposal and submission of contract and grant proposals, to post-award research financial administration; assist in establishing controls as needed to ensure full compliance.
* Oversees and processes effort reporting.
* Draft BAF requests as outlined in the NOGAs and make necessary adjustments as needed. Responsible for ensuring that grants are setup in PeopleSoft correctly according to the budget and/or BAF.
* Consistently monitors grants during the project life cycle and prepares them for closeout.
* Performs monthly audits of grant account reconciliation reports for designated departmental chart field strings to ensure compliance with departmental, institutional, and state guidelines and reports audit findings to Grant Program Manager & Department Administrator.
* Collaborates with grant personnel to ensure funding components including subcontracts are budgeted correcting in PeopleSoft. Performs budget transfers if needed.
Core Services and Department Management
* Acts as a resource to administrative support staff regarding fund expenditure guidelines, purchasing procedures, and travel reimbursements.
* Responsible for adhering to institutional and state guidelines and deadlines to include purchasing, fiscal, and travel
* Monitors project invoicing for designated Core Services
* Prepares monthly statement of operations reports, monthly variance reports and various cost analysis reports to Core Director.
* Assists in preparing and managing budget, pricing, reconciliation and account management for designated Institutional Core Services
* Responsible for reviewing purchase orders for funding source
* Responsible for maintaining the CAT Tool per award setups
* Responsible for completing the STAT sampling for Genomic Medicine, Operational Priorities, STRIDE, and Therapeutics Discovery.
* Prepares and analyzes Personnel Trending for department and researches and documents variances for Genomic Medicine and Prime-TR.
* Responds to faculty, Department Administrator and Grant Program Manager's inquiries regarding budget and expenses.
* Performs audits of any and all departmental funds at the request of Chair, DA or Grant Program Manager.
* Responsible for compliance with institutional, state and federal regulations and requirements and ensures departmental system of internal controls are met.
* Ability to organize, prioritize and complete work in a timely manner under a fluctuating workload and competing deadlines.
* Proactively identifies process and system deficiencies and bring them to resolution. Proven track record of success in managing a range of financial activities.
* Processes payroll reconciliations including institutional, philanthropic, gift, industry, and foundation sponsored funds.
* Overviews monthly statistical sampling reports and personnel trending reports for Division and Financial Control Office.
* Develops and maintains a comprehensive financial/protocol database capable of query to reconcile research charge tickets vs Memo Bills posting.
* Demonstrated ability to work with confidential and privileged information. Maintains sensitive information and records and exhibits appropriate sensibility regarding not sharing sensitive information unnecessarily.
* Goes beyond normal scope of duties to ensure financial resources are optimally utilized and safeguarded.
* Effectively coordinates resources and projects with other MDACC departments.
* Oversees administrative support staffs in the monthly purchase orders, ePAF updates.
Other duties as assigned.
EDUCATION:
Required: Bachelor's degree in Business Administration or related business specialty.
EXPERIENCE:
Required: Five years experience in data analysis, accounting or financial project management.
Preferred: Ideal candidate will be familiar in MDACC systems, such as ResourceOne, PeopleSoft, EIW, SmartStream, FReD, Coeus, ClnicStation, MSDS Online, OnBase, NetPass, Microsoft Excel, Word, PowerPoint, Visio, etc.
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: 168737
- Employment Status: Full-Time
- Employee Status: Regular
- Work Week: Days
- Minimum Salary: US Dollar (USD) 75,000
- Midpoint Salary: US Dollar (USD) 94,000
- Maximum Salary : US Dollar (USD) 113,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
Source : MD Anderson