Capolicylab
Financial Analyst
Capolicylab, Los Angeles, California, United States, 90079
The California Policy Lab generates research insights for government impact. Through hands-on partnerships with government agencies, CPL performs rigorous research across issue silos and builds the data infrastructure necessary to improve programs and policies that millions of Californians rely on every day. CPL’s UCLA site is a dynamic and growing organization with nearly 20 full-time employees, half a dozen graduate student researchers, and numerous faculty affiliates.CPL recognizes the value of having a diverse staff at all levels of the organization. We are looking for equity-minded applicants who represent and understand the diverse racial and ethnic, gender identity, sexual orientation, educational, socioeconomic, cultural, and disability backgrounds present in California. When you join our team, you can expect to be part of an inclusive and equity-focused community.The role
The California Policy Lab is hiring a Financial Analyst on its UCLA team. This is a key role at CPL because their work ensures that CPL is able to conduct research on some of the most urgent issues facing California, including homelessness and economic inclusion. Under the direction of the CPL Executive Director, the Financial Analyst will be responsible for a portfolio of extramural research funding including federal and foundation research awards. CPL’s Financial Analyst will provide analysis of CPL’s funding streams and budgets to understand the lab’s past financial performance, determine present resource allocations, and proactively plan for future revenue and expense adjustments.This position will coordinate and implement CPL’s budget allocations, maintain our chart of accounts, and identify appropriate data management tools and business processes for these activities. The role is responsible for producing regular reports summarizing budget analysis and recommendations for CPL’s financial planning, including resource allocation approaches, trended future payroll and operational requirements, and likely revenue generation. Specific examples include implementing and monitoring recharge strategies and using past data to forecast CPL’s data infrastructure and payroll expenses.In addition, the Financial Analyst will provide a broad range of professional services, including proposal budgeting and submission and contracts and grants management. The Financial Analyst will collaborate in a team with CPL’s Executive Directors at UCLA and UC Berkeley, Development Director, and other operations staff. They will also work with various campus units to manage contracts and grants from inception to closeout. The Financial Analyst will work closely with CPL staff to coordinate the compensation of CPL’s Faculty Affiliates, Graduate Student Researchers, Postdoctoral Scholars, full-time employees, and consultants. The Financial Analyst will be managing a portfolio of about $7-8m in grants and contracts per year, which supports nearly 40 full time positions and comes from over two dozen unique funding sources.This position could be fulfilled either remotely, or in a hybrid manner, with some in-person meetings.Education and experience required
Applicants must have a bachelor’s degree in related area and/or equivalent experience/training. Applicants must also have at least two years of relevant experience; experience gained in school counts toward this requirement.Core functions:
A)
Financial analysis and forecasting (30%)● Provide analytic support for CPL’s overall financial planning, including analysis of CPL’s past financial performance, determine present resource allocation, and forecast future needs and adjustments.● Manage all purchasing, appropriations, and other expenditures for CPL’s operating budget, including grant accounts, state contracts, faculty research accounts, and discretionary funds. Proactively identify and perform necessary allocations and adjustments. Make recommendations to Executive Director and Faculty Director on where to charge expenditures based on an analysis of fund purposes and performance of the funds.● To support strategic planning and fundraising, prepare and summarize quarterly and annual financial analyses with recommendations for CPL’s resource plans, including resource allocations across CPL’s operational and payroll items.● Perform ad hoc, financial research for internal CPL constituents, such as independently gathering information and analyzing impacts of benefits changes to the organization.● Identify and use appropriate data management tools to coordinate and implement CPL’s budget and resource allocations.● Ensure appropriate internal controls are addressed, maintained, and strengthened to protect CPL and university resources.● Attend campus trainings on topics that impact CPL’s budget and financial analysis, such as the UCLA-wide transition to the Chart of Accounts (Ascend 2.0 Program) or changes to employee benefits.● Document procedures for CPL financial analysis.B)
Proposal submission (20%)● Inform the development of proposal budgets with CPL’s overall financial picture and funding gaps.● Prepare proposal submissions, including budgets, budget justifications and other required documents; ensure CPL staff are informed of deadlines and procedures.● Review and edit PI bio-sketches to ensure compliance with funding agency’s guidelines.● Prepare Current & Pending Support document for PIs and other key personnel listed on the proposal.● Frequent interaction with PIs and his/her collaborators and use Cayuse, NSF FastLane, Research.gov, and other web-based proposal submission systems for error-free proposal submission.● Follow up any requests after each proposal submission to ensure all agency questions are addressed in a timely manner.● Serve as a liaison to CPL’s UC Berkeley site and its Fund Manager and Director of Operations to create sub-award budgets and process recharge transactions.● Confirm the need for IRB protocols in certain proposal submissions and monitor the status of IRB to ensure compliance with OCGA.C)
Post-award financial management (40%)● Maintain electronic files of required documents of every award, including both active and closed within past 7 years.● Work closely with PIs for any funding agency’s requests prior to approval. Prepare drafts of correspondence and other documents.● Review each award letter to provide PI guidance on compliance.● Review each transfer of funds for awards (including non-competing award) to ensure the correct amount of funds were transferred.● Reconcile financial ledger on a monthly basis and remediate discrepancies. Prepare and justify cost transfers and non-payroll adjustment.● Monitor cost variances in project budgets. Identify and recommend solutions to ensure funds are appropriately expended before award closeout.● Frequent communication with OCGA, EFM, and Purchasing to solve any issues from contracts and grants.● Review Effort Report before sending out notice to PI for certification.● Prepare financial reports according to financial deliverable schedules.● Thorough financial review and reconciliation for each award before closeout. Prepare closeout packet.● Provide backup as preparer for travel express and purchasing and serve as a backup supervisor to ensure timely submission of employee timesheets.● Participate in CPL hiring processes to ensure accurate payroll budgeting.D)
Administrative Support (10%)● Schedule meetings, manage travel arrangements, expense report submissions and reimbursements for CPL leadership team members, CPL partners and visitors.● Work with CPL’s Program Manager to coordinate logistics related to CPL hosted special events. Provide support to CPL staff members during weekly in person research team lunch meetings as well as other team activities. Support overall general operations of the lab.Required● Thorough knowledge of finance policies, practices, and systems.● Demonstrated skill in spreadsheet and/or database software for complex financial analysis, fiscal management, and financial reports.● Excellent financial skills to monitor budgets, expenditures and project balances accurately. Ability to maintain accurate and complete records and reconcile financial activity on a regular basis.● Ability to synthesize quantitative data into compelling narratives or high-level summaries for non-financial audience.● Demonstrated analytical skill and problem-solving ability to formulate logical and objective conclusions.● Ability to prioritize complex workload to meet various deadlines.● Excellent interpersonal skills to interact and communicate effectively with faculty, staff, students and other campus departments. Ability to establish and maintain cooperative working relationships with other University Offices and funding agencies.● Demonstrated written communication skills to prepare concise, logical, grammatically correct analytical reports, correspondence, policies and procedures.● Ability to listen effectively and empathize with individuals to deal with confidential and sensitive information and situations.Preferred● Demonstrated knowledge of University accounting procedures, contracts and grants management policies, and regulations for federal grants, particularly NIH and NSF.● Strong knowledge of UCLA financial system. Familiarity with UCPath, NPEAR, EDB, CDW, TOF, ERS, ORA portal, Salesforce CRM software etc.To apply
All applicants must apply online at UCLA Career Opportunities by searching for requisition number 2024-3966. Candidates who pass an initial resume review will be contacted for additional pre-interview screening.The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
#J-18808-Ljbffr
The California Policy Lab is hiring a Financial Analyst on its UCLA team. This is a key role at CPL because their work ensures that CPL is able to conduct research on some of the most urgent issues facing California, including homelessness and economic inclusion. Under the direction of the CPL Executive Director, the Financial Analyst will be responsible for a portfolio of extramural research funding including federal and foundation research awards. CPL’s Financial Analyst will provide analysis of CPL’s funding streams and budgets to understand the lab’s past financial performance, determine present resource allocations, and proactively plan for future revenue and expense adjustments.This position will coordinate and implement CPL’s budget allocations, maintain our chart of accounts, and identify appropriate data management tools and business processes for these activities. The role is responsible for producing regular reports summarizing budget analysis and recommendations for CPL’s financial planning, including resource allocation approaches, trended future payroll and operational requirements, and likely revenue generation. Specific examples include implementing and monitoring recharge strategies and using past data to forecast CPL’s data infrastructure and payroll expenses.In addition, the Financial Analyst will provide a broad range of professional services, including proposal budgeting and submission and contracts and grants management. The Financial Analyst will collaborate in a team with CPL’s Executive Directors at UCLA and UC Berkeley, Development Director, and other operations staff. They will also work with various campus units to manage contracts and grants from inception to closeout. The Financial Analyst will work closely with CPL staff to coordinate the compensation of CPL’s Faculty Affiliates, Graduate Student Researchers, Postdoctoral Scholars, full-time employees, and consultants. The Financial Analyst will be managing a portfolio of about $7-8m in grants and contracts per year, which supports nearly 40 full time positions and comes from over two dozen unique funding sources.This position could be fulfilled either remotely, or in a hybrid manner, with some in-person meetings.Education and experience required
Applicants must have a bachelor’s degree in related area and/or equivalent experience/training. Applicants must also have at least two years of relevant experience; experience gained in school counts toward this requirement.Core functions:
A)
Financial analysis and forecasting (30%)● Provide analytic support for CPL’s overall financial planning, including analysis of CPL’s past financial performance, determine present resource allocation, and forecast future needs and adjustments.● Manage all purchasing, appropriations, and other expenditures for CPL’s operating budget, including grant accounts, state contracts, faculty research accounts, and discretionary funds. Proactively identify and perform necessary allocations and adjustments. Make recommendations to Executive Director and Faculty Director on where to charge expenditures based on an analysis of fund purposes and performance of the funds.● To support strategic planning and fundraising, prepare and summarize quarterly and annual financial analyses with recommendations for CPL’s resource plans, including resource allocations across CPL’s operational and payroll items.● Perform ad hoc, financial research for internal CPL constituents, such as independently gathering information and analyzing impacts of benefits changes to the organization.● Identify and use appropriate data management tools to coordinate and implement CPL’s budget and resource allocations.● Ensure appropriate internal controls are addressed, maintained, and strengthened to protect CPL and university resources.● Attend campus trainings on topics that impact CPL’s budget and financial analysis, such as the UCLA-wide transition to the Chart of Accounts (Ascend 2.0 Program) or changes to employee benefits.● Document procedures for CPL financial analysis.B)
Proposal submission (20%)● Inform the development of proposal budgets with CPL’s overall financial picture and funding gaps.● Prepare proposal submissions, including budgets, budget justifications and other required documents; ensure CPL staff are informed of deadlines and procedures.● Review and edit PI bio-sketches to ensure compliance with funding agency’s guidelines.● Prepare Current & Pending Support document for PIs and other key personnel listed on the proposal.● Frequent interaction with PIs and his/her collaborators and use Cayuse, NSF FastLane, Research.gov, and other web-based proposal submission systems for error-free proposal submission.● Follow up any requests after each proposal submission to ensure all agency questions are addressed in a timely manner.● Serve as a liaison to CPL’s UC Berkeley site and its Fund Manager and Director of Operations to create sub-award budgets and process recharge transactions.● Confirm the need for IRB protocols in certain proposal submissions and monitor the status of IRB to ensure compliance with OCGA.C)
Post-award financial management (40%)● Maintain electronic files of required documents of every award, including both active and closed within past 7 years.● Work closely with PIs for any funding agency’s requests prior to approval. Prepare drafts of correspondence and other documents.● Review each award letter to provide PI guidance on compliance.● Review each transfer of funds for awards (including non-competing award) to ensure the correct amount of funds were transferred.● Reconcile financial ledger on a monthly basis and remediate discrepancies. Prepare and justify cost transfers and non-payroll adjustment.● Monitor cost variances in project budgets. Identify and recommend solutions to ensure funds are appropriately expended before award closeout.● Frequent communication with OCGA, EFM, and Purchasing to solve any issues from contracts and grants.● Review Effort Report before sending out notice to PI for certification.● Prepare financial reports according to financial deliverable schedules.● Thorough financial review and reconciliation for each award before closeout. Prepare closeout packet.● Provide backup as preparer for travel express and purchasing and serve as a backup supervisor to ensure timely submission of employee timesheets.● Participate in CPL hiring processes to ensure accurate payroll budgeting.D)
Administrative Support (10%)● Schedule meetings, manage travel arrangements, expense report submissions and reimbursements for CPL leadership team members, CPL partners and visitors.● Work with CPL’s Program Manager to coordinate logistics related to CPL hosted special events. Provide support to CPL staff members during weekly in person research team lunch meetings as well as other team activities. Support overall general operations of the lab.Required● Thorough knowledge of finance policies, practices, and systems.● Demonstrated skill in spreadsheet and/or database software for complex financial analysis, fiscal management, and financial reports.● Excellent financial skills to monitor budgets, expenditures and project balances accurately. Ability to maintain accurate and complete records and reconcile financial activity on a regular basis.● Ability to synthesize quantitative data into compelling narratives or high-level summaries for non-financial audience.● Demonstrated analytical skill and problem-solving ability to formulate logical and objective conclusions.● Ability to prioritize complex workload to meet various deadlines.● Excellent interpersonal skills to interact and communicate effectively with faculty, staff, students and other campus departments. Ability to establish and maintain cooperative working relationships with other University Offices and funding agencies.● Demonstrated written communication skills to prepare concise, logical, grammatically correct analytical reports, correspondence, policies and procedures.● Ability to listen effectively and empathize with individuals to deal with confidential and sensitive information and situations.Preferred● Demonstrated knowledge of University accounting procedures, contracts and grants management policies, and regulations for federal grants, particularly NIH and NSF.● Strong knowledge of UCLA financial system. Familiarity with UCPath, NPEAR, EDB, CDW, TOF, ERS, ORA portal, Salesforce CRM software etc.To apply
All applicants must apply online at UCLA Career Opportunities by searching for requisition number 2024-3966. Candidates who pass an initial resume review will be contacted for additional pre-interview screening.The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
#J-18808-Ljbffr