Principal Financial Analyst

Lawrence Berkeley National Lab’s (LBNL) Office of Chief Financial Officer Division has an opening for a Principal Financial Analyst to join the team.Matrixed from the OCFO Field Finance or Budget Office Departments to an assigned area/division, operating within the Lab’s financial policies and procedures and working under consultative direction of an assigned supervisor/manager, independently provide complex, detailed and comprehensive program/project budget management, planning and analysis services. This includes providing financial support and moderately complex consultative advice to scientific investigators and their research programs/projects or operations managers covering parts of the assigned division’s annual funding from the U.S. Department of Energy (DOE), other direct sponsors, and/or the Laboratory’s Operations Division. This position may either be performed in an individual contributor or in a supervisor/work lead capacity.Opportunities across our organization may support client groups in the following areas:BiosciencesComputing SciencesEarth and Environmental SciencesEnergy SciencesEnergy Technologies AreaPhysical Sciences AreaOperationsWhat You Will Do:Working under the consultative direction of an assigned supervisor/manager, you will work independently and will have the following key responsibilities that are complex in scope:Oversee highly complex program/project/functional activities from inception to close-out, including the formulation, execution, projection and analysis of budgets, funding, costs and commitments, and associated staffing levels.Leverage technical knowledge in developing highly advanced funding forecasts and spend plans for both PIs, Program Managers as well as external sponsors; analyze variances by identifying root causes, and revising forecasts as necessary.Develop highly complex standard and ad hoc financial reports and analyses for both PIs, Program Managers as well as external sponsors; develop highly complex financial data models in support of the overall area or division financial objectives.Exert significant latitude in resolving highly impactful issues, including cost allowability and compliance with the terms and conditions of DOE and other funding sponsor contracts; exercise judgment within broadly defined practices and policies in selecting methods, techniques and evaluation criteria for obtaining results, including Generally Accepted Accounting Principles (GAAP) and Cost Accounting Standards (CAS).Process, evaluate and approve financial transactions, including commitment of funds consistent with delegated authorities including both financial and personnel actions maintaining appropriate documentation.Establish and maintain robust collaborative working relationships with internal and external customers/partners including area/division management, and leverage these relationships in difficult and complex situations.Oversee proposal process and develop detailed, multi-year proposal budgets of various dollar amounts including subcontracting, justifications, and administrative documentation for programs of moderate to high complexity.Provide comprehensive contract and grant preparation and coordination support. Coordinate proposal development work with research project team and stakeholders/customers.Forecast resource requirements, costs and spending patterns based on proposed work scope, prior similar work, and timeline in order to ensure full cost recovery. Analyze and advise PI regarding alternative budget scenarios and recommended alterations to budgets.Develop highly complex and fully costed budgets in multiple formats as defined by agency and individual proposal submission guidelines. Modify and/or develop budget presentation spreadsheets and documents where applicable.Subcontract Preparation: Advise and assist PIs and technical staff in the review and development of all materials necessary to support R&D subcontracts, Requests for Proposals (RFPs) and consultant agreements.Provide leadership, supervision and workload management for assigned division resource analyst(s), working in financial management and budgets.Review the quality control of work products prepared by assigned staff members with respect to compliance with the funding agency’s guidelines, and compliance with LBNL, DOE and UC policies, processes and guidelines.What is Required:A Bachelor’s degree in accounting, finance, business or economics, and/or the equivalent of a minimum of 6 years related experience including experience in a research, academic or large/complex organization.Advanced knowledge of and applied experience with business, budgeting and accounting principles including Generally Accepted Accounting Principles (GAAP). Knowledge of cost accounting standards (CAS) and other Federal processes and regulations.Advanced knowledge, experience and achievement in planning and managing portfolios of complex budgets funded from multiple sources having varying contract terms and conditions.Substantial experience with spreadsheets and financial databases, such as Excel, and PeopleSoft financial applications and other relevant software applications. Extensive experience with Excel data analysis functions. Experience in creating standard and ad hoc reports and presentations, including the use of charts and graphs.Demonstrated experience in handling difficult, sensitive situations and conflicting priorities.Specialist in providing financial advice and consultative services, including short and long-range financial planning, estimating, budgeting, cost and effort tracking, analysis and forecasting, indirect rate development, monitoring expenses appropriateness, tracking and reporting and project close-out.Strong organizational, analytical, and problem solving skills. Ability to multi-task and deliver timely accurate and complete work on tight deadlines.Desired Qualifications:Master's degree or equivalent in accounting, finance, business or related field.Knowledge of DOE, UC, LBNL and SPP financial policies and procedures and reporting requirements.Deep knowledge of contract and grant proposal administration; reviewing & interpreting solicitations, proposal preparation, and understanding of research administration guidelines of federal and non-federal sponsors.Knowledge of PeopleSoft financial applications.Notes:This is a full-time career appointment, exempt (monthly paid) from overtime pay.Salary for this position will be commensurate with the final candidate’s qualification and experience, including skills, knowledge, relevant education, and certifications, and also aligned with the internal peer group. The budgeted annual salary range is $119,700 - $147,861.This position may be subject to a background check. Any convictions will be evaluated to determine if they directly relate to the responsibilities and requirements of the position. Having a conviction history will not automatically disqualify an applicant from being considered for employment.This position is eligible for a hybrid work schedule - a combination of teleworking and performing work on site at Lawrence Berkeley National Lab, 1 Cyclotron Road, Berkeley, CA.

#J-18808-Ljbffr