Financial Sr Analyst

Salary: $69,525.00 - $86,907.00 Annually
Location : 201 S Greene Street Greensboro, NC
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 03280
Department: Finance
Opening Date: 02/26/2024
Closing Date: 3/15/2024 11:59 PM Eastern
GUILFORD COUNTY GOVERNMENT
Empower Successful People to thrive in a Strong Community supported by Quality Government
Transparency & Communication | Equity & Inclusion | Accountability
Service & Outcomes Excellence | Our People Matter
Description
GENERAL STATEMENT OF DUTIES
Position performs complex analysis work in various aspects of the Finance Department. Monitors and advises other departments on various aspects of County financial operations. Responsible for preparing assigned regulatory and compliance reports including portions of annual comprehensive financial report (ACFR) in addition to reports specific to their respective areas. Maintains reports or subsidiary records to reconcile to general ledger balances. Prepares analyses and schedules in conjunction with projection of available fund balance.
DISTINGUISHING FEATURES OF THE CLASS
An employee in this class demonstrates analytical skills by successfully handling complex issues related to various aspects of Finance. The employee performs analytical work regarding revenues, expenditures and fund balances specific to their respective areas. Prepares reports as required by terms of grants, prepares assigned portion of the ACFR, and other reports as required by management. Examples include indirect cost reports, Tourism Authority financial statements, the annual financial information report, the schedule of expenditures of federal and state financial awards (SEFSA), fixed asset reports and select portions of official statements required in connection with bond offerings. May maintain subsidiary records summarizing activity in general ledger accounts and reconcile these records, or subsidiary reports prepared by others, to the balance in related general ledger accounts. Review contracts for compliance with budgetary and statutory as well as policy requirements. May fill in for management level positions during absences, including Financial Plan & Report Manager, Cash and Debt Manager and Accounting Manager. Assist in annual fund balance projections through analysis of activity in assigned areas to predict final outcome for fiscal year. The employee exercises independent judgment and discretion in applying and interpreting generally accepted accounting principles, County and Finance policies and provisions of grants or bond indentures. Communicates effectively and independently with employees and management. May work in a lead capacity to plan, direct, and review the work of others inside and outside the department. Work requires frequent and regular contact with customers both inside and outside of direct reporting relationship. Work is performed under the general supervision of Financial Plan & Report Manager, Cash and Debt Manager, or (Deputy) Finance Director.
Examples of Duties
DUTIES AND RESPONSIBILTIES
Essential duties and responsibilities include, but are not limited to:

• Assist with preparation of ACFR and SEFSA through completion of specific assignments
• Monitor expenditures related to certain grants and bond issues to ensure that expenditures are in compliance with governing documents
• Maintain subsidiary records supporting general ledger accounts such as maintenance of fixed asset system, schedules supporting debt service activity,
• Reconcile certain schedules/analyses to corresponding general ledger account balance
• Assist with completion of annual fund balance projections
• Assist with completion of indirect costs reports
• Assist in rate setting for Internal Services Fund
• May review the work of other employees
• Review contracts related to analyst's area
• Substitute for certain management level employees in their absence
• Perform other duties as assigned

PRIMARY FOCUS:
County Public Safety Grants/Cost Accounting Financial Analysis

• Monitor grant activity in Law Enforcement and Emergency Services (EMS) area
• Monitor miscellaneous grants outside of Human Service areas and Parks and Recreation
• Prepare monthly summary of activity in Inmate Trust Fund
• Assist in setting rates for various insurance funds of County
• Leads in preparation of indirect cost reports
• Analyze Law Enforcement and EMS to predict financial outcome at fiscal year-end in conjunction with annual fund balance projection
• Review contracts relating to Law Enforcement and EMS
• Prepare portions of ACFR and SEFSA relating to Law Enforcement and EMS
• Monitor County Internal Services Fund, including preparation of quarterly financial statements
• Prepare cost studies and cost analyses of various County services and operational functions
• Act as substitute for Planning and Report Manager and Accounting Manager as needed

SECONDARY FOCUS:
Capital Asset Financial Analysis

• Provide accounting and fiscal analysis involving activity in the County's capital asset system and the County Building Construction Fund
• Oversee financial reporting and analysis of School Capital Outlay Funds for Guilford County Schools and Guilford Technical Community College
• Monitor certain grants, including State Public School Building Capital Fund and park and recreation grants
• Review contracts and agreements relating to leases, fixed asset purchases and dispositions, facilities, and parks and recreation
• Review and process accounting and financial reporting functions for the Greensboro/Guilford County Tourism Development Authority including preparing monthly and annual financial statements
• Prepare and process payroll for the Greensboro/Guilford County Tourism Development Authority
• Lead in preparation of the Annual Financial Information Report (AFIR) to the Local Government Commission
• Other duties as assigned

Human Services Financial Analysis

• Monitor grants in Human Service areas (Health Department, Department of Social Services, Child Support Enforcement, Transportation and Animal Services)
• Maintain detailed analytical work papers finalizing settlements with the grantors
• Review and approve the monthly 1571 report for Department of Social Services and Child Support Enforcement, and the monthly Public Health expenditure report
• Analyze Public Health, Social Services, Child Support Enforcement, and other assigned departmental accounts to predict financial outcome at fiscal year-end in conjunction with annual fund balance projections
• Review contracts relating to Health Department, Department of Social Services, and other assigned departments
• Prepare portions of ACFR and lead the preparation of the SEFSA
• Other duties as assigned

RECRUITMENT STANDARDSKnowledge, Skills, and Abilities

• Considerable knowledge of the laws and procedures governing County funds
• General knowledge of the financial operations of the County and the various funds involved
• Working knowledge of generally accepted accounting principles
• Working knowledge of general governmental accounting practices
• Working knowledge of Excel, Word and Outlook
• Strong analytical capabilities
• General knowledge of the operation of the banking system
• Ability to make accurate mathematical computations and to compile accurate and complete reports
• Ability to create and maintain subsidiary records (e.g., for tracking bond funds) in Excel
• Ability to establish and maintain effective working relationships with other employees.

Typical Qualifications
MINIMUM QUALIFICATIONS
Graduation from an accredited college or university with a Bachelor's degree with major course work in finance, accounting or business administration AND at least six years of progressive responsible experience in the analysis and maintenance of fiscal records, with emphasis on accounting for grant- or bond-funded expenditures, asset management, federal and state appropriations, and/or cost accounting.
Depending on the position's requirements, a current certification as a Certified Public Accountant (CPA) in the State of North Carolina may be required at the time of application. Proficient with Microsoft Office Suite, particularly Excel and Word.
Supplemental Information
Physical Demands
An employee in this position must be able to physically perform the basic life operational functions of kneeling, crouching, reaching, standing, walking, pushing, pulling, lifting, fingering, grasping, feeling, talking, hearing, and repetitive motions. The employee must be able to perform light work exerting up to 10 pounds of force routinely and/or in excess of 20 pounds of force occasionally to lift objects.
Working Conditions
Workspace consists of a normal office environment. No adverse environmental conditions.
May Require Driving
This position may require driving for this position whether driving a County owned or personal vehicle to conduct county business such as but not limited to attending conferences, meetings, or any other county related functions. Motor Vehicle Reports may be verified for valid driver's license and that the driving record is compatible with the county's driving criteria.
If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County's vehicle use policy.
Special Note: This generic class description gives an overview of the job class, its essential job functions and recommended job requirements. However, for each individual position assigned to this class, there is available a completed job description with physical abilities checklist which can be reviewed before initiating a selection process. These job descriptions can provide additional detailed information on which to base various personnel actions and can assist management in making legal and defensible personnel decisions.
Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation. The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.
We are excited about the opportunity of having you as a prospective new employee!
You probably already know our county is a wonderful county to live in, but did you know it is also a wonderful place to work?
Below are a few of the reasons why we love working for Guilford County.
We offer Health Insurance (UnitedHealthCare) to all benefitted employees working a minimum of 20 hours per week. The shared cost of the premium is based on scheduled/budgeted hours. If you are a full-time employee working 40 hours a week you can expect to pay less than $35 a month for medical coverage, dental coverage for $4 a month and vision coverage for $5 a month. That's less than $45 a month for medical, dental & vision coverage; that's unheard of.
Telehealth UHC Virtual Visits are available to you with no copay or out of pocket expense.
We are excited to inform you Guilford County has an Employee Wellness Center (24/7 access) with strength training equipment, cardio machines and a group exercise room with virtual or in person coaching from our Wellness Specialist!
Employee Assistance Program, 100% funded by the county. A superb benefit for you and your family absolutely free. Confidential help with personal or work-related issues.
13 paid holidays, 12 sick days, and 12 vacation days a year. That's 37 paid days a year, totaling almost 2 months of paid time off.
Employer contributes 5% into your 401(k) - no match required.
Enrollment in the State Retirement Plan by contributing 6%.
Longevity pay beginning at five years of service.
We provide a $10,000 Life and AD&D benefit to eligible employees.
Flexible spending accounts (FSA) allow you to set aside tax-free dollars for health care and dependent care.
Voluntary Life, AD&D, Short-Term and Long-Term Disability.
01
Which best describes your level of education?

• High school
• Associate's degree
• Bachelor's degree
• Master's degree or higher

02
If you have a degree, is the major field of study a degree with major course work in finance, accounting or business administration?

• Yes
• No
• I do not have a degree

03
Which best describes your years of progressive responsible experience in the analysis and maintenance of fiscal records, with emphasis on accounting for grant- or bond-funded expenditures, asset management, federal and state appropriations, and/or cost accounting?

• Less than 4 years
• 4 to less than 6 years
• 6 or more years

04
In which of the following do you have current certification? Check all that apply and add its information to the Certificates and Licenses section of your application.

• Certified Public Accountant (CPA)
• North Carolina Local Government Finance Officer (NCLGFO)
• Certified Public Finance Officer (CPFO)
• I currently do not have one

05
Which best describes your proficiency with Microsoft Office Suite, particularly Excel and Word?

• Beginner
• Intermediate
• Advanced

Required Question