Texas Biomed is searching for a Senior Award and Reporting Manager to join our team. This integral member of the Applied Science and Innovation Contract Finance team is responsible for the design and development of solutions to complex data integration, reporting, and contract accounting problems. Help implement new information technology systems with a focus on contract accounting and reporting, enter data and manage data integrity across all systems. Use contract accounting and project management skills to prepare contract revenue forecasts aligned with ASI schedule. Liaise with accounting for proper contract invoicing and ERP formulas. This role reports to the Applied Science and Innovation (ASI) Director of Contract Finance and Administration.
THE ROLE:
Reporting and Data integrity
• Lead complex unit projects needed for reporting key performance indicators of faculty, the unit, and the organization. Projects will require extensive knowledge of business systems, contract accounting, and formula writing.
• Develop, validate, and modify reports and dashboards in all financial systems to create efficiency and effectiveness for ASI. This will require merging data from multiple sources using advanced formulas.
• Prepare internal reporting monthly, quarterly and annual reports, of key metrics, financial results, and variance reporting.
• Prepare contract specific external monthly, quarterly and annual reports, including budget to actuals, percent complete, rolling forecast, invoice status, hours, small business reporting.
• Take data, understand it, process it, extract value from it, and communicate it visually / verbally to team members and management across the organization
• Lead ASI input for configuration of Information technology systems to ensure functionality is leveraged to streamline analytical and contract reporting processes
• Serve as Applied Science and Innovation administrator for all financial systems and create new processes, and data validations to ensure data integrity across systems.
• Assist leaders in identifying opportunities to streamline, improve, and/or automate business processes while actively implementing changes as needed.
• Contributes to business and process improvement by assessing and anticipating stakeholder needs.
Contract Accounting
• Responsible for reading contracts and ensuring proper setup and close out of ASI accounts in a timely manner and ensures accuracy for proper business reporting, including all databases and files.
• Liaise with accounting to ensure proper invoicing per contract requirements and milestone completions.
• Direct accounting and tracking of Fixed Fee and Retained Earnings allocations in accordance with contract requirements and Institute policy. Communicate and validate proper setup of ERP formulas for indirect, Fixed fees, and Retained earnings.
• Use contract accounting and project management skills to prepare rolling, annual, and multi-year budgets/forecasts for ASI and Contract Revenues aligned with ASI schedule.
OUR IDEAL CANDIDATE:
• Bachelor's Degree in Finance, Accounting, Business, Computer Science, Information Technology, Engineering, Biology, or a related field; MBA / Master's Degree preferred
• Expert level federal contract accounting knowledge for both cost plus fixed fee and firm fixed price contracts while working in a research organization, such as contract research organization, research institute, non-profit, university, or entity funding/performing biomedical research.
• 5+ years demonstrated experience in report building, data validation, and contract accounting
• 5+ years demonstrated Advanced Microsoft 365 Excel skills, including advanced formula writing and pivot tables.
• Operational understanding of Power BI, SQL Reporting, and relational databases
• Demonstrated analytical, decision-making, and problem-solving skills experience and a desire to use data to solve problems with a team.
• Ability to leverage technology to extract and analyze data
• Ability to generate financial reports and key performance indicators with a high degree of accuracy
• Ability to determine how a system should work and how changes in conditions, operations, and the environment will affect outcomes
• Ability to identify and implement opportunities to streamline and achieve efficiencies
• Ability to communicate with others to convey complex information effectively
• Ability to organize time, prioritize deadlines and remain productive
