City of Raleigh North Carolina logo

City of Raleigh North Carolina

Fiscal Analyst, Senior

SALARY

$51,822.00 - $95,871.00 Annually

LOCATION

Raleigh, NC

JOB TYPE

Full-Time

JOB NUMBER

2018-00311

DEPARTMENT

Accounting & Financial Reporting

OPENING DATE

05/17/2018

CLOSING DATE

Continuous

FLSA

Exempt

BARGAINING UNIT

8888

SALARY

$51,822.00 - $95,871.00 Annually

LOCATION

Raleigh, NC

JOB TYPE

Full-Time

JOB NUMBER

2018-00311

DEPARTMENT

Accounting & Financial Reporting

OPENING DATE

05/17/2018

CLOSING DATE

Continuous

FLSA

Exempt

BARGAINING UNIT

8888

Header for Print Bulletin

Job Description

The hiring range for this position is: $51,822.00 - $75,000.00 (Promotional Hiring Range may vary)
The Fiscal Analyst, Senior serves in a lead position in the Accounting Division overseeing complex accounting transactions for the City, being preparer or 1st reviewer for internal and external financial reporting in compliance with Generally Accepted Accounting Principles, and serving as a subject-matter expert for regulatory requirements and legislation. The candidate will have unique opportunities to collaborate with positions throughout municipal government, and will serve as a fiscal liaison while coordinating financial services both to departments and external parties.  This position will also serve an integral role in conducting special projects for management to assess the effectiveness of controls, accuracy of financial records, and opportunities for improvement surrounding fiscal policies or operations. The City of Raleigh is looking for a highly competent and motivated CPA who can apply professional judgment and initiative to drive results.  Governmental accounting experience is preferred.

Duties and Responsibilities

This position supports accounting staff as they manage the day-to-day operations for City-wide accounting services and coordinates annual reporting requirements. Duties and responsibilities include:

  •  Detailed reviews over accounting transactions to ensure the City maintains compliant with accounting principles, State and Federal regulations.
  • Monitors deadlines and coordinates timely reporting of financial information and deliverables due throughout the year to internal departments, external partners, and regulatory agencies.
  • Prepares and/or serves as 1st reviewer for various schedules and financial statements related to the Finance Department's two major fiscal reports - Comprehensive Annual Financial Report (CAFR) and Citizens Annual Financial Report (PAFR).
  • Acts as point person for contract and wire reviews with regards to the City's compliance to the Fiscal Control Act.
  • Serves as part of a multi-level review for reporting requirements outside of year-end reporting as assigned.
  • Assists accounting team with maintaining an accurate and timely monthly, quarterly and year end close process.  
  • Prepares or serves as reviewer for complex journal entries, analyses, reconciliations and accruals to ensure data integrity.
  • Reviews and evaluates the soundness, adequacy, and application of financial and other operating controls.
  • Collaborates on revisions and recommendations for accounting policies and procedures, as well as special projects to drive efficiencies in operations and reporting.
  • Assists with setting up new account chartfields in the system, and ensuring data integrity.
  • Maintains an understanding of the ERP PeopleSoft accounting system and the interaction of sub-modules. Collaborates on strategic system design decisions involving these financial systems.
  • Performs data modeling and helps lead data-driven dashboards and reports for end users.
  • Assists with data requests for the City's external auditor for financial, pension, and grant audits.
  • Mentors and trains staff in the Accounting division, helping management steer assignments or oversee work of Fiscal Analysts.
  • Other duties and Committee appointments as assigned.

Typical Qualifications

Education and Experience
Bachelor's (4-year) degree in Finance or Accounting. Government Finance and Accounting experience preferred and five years of progressive accounting and/or auditing experience required. Prior working knowledge of an Enterprise Wide Financial System and prior working knowledge of annual reporting process.
OR
An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job such as those listed above, unless otherwise subject to any other requirements set forth in law or regulation.
Licensing/Certifications
Current certification as a Certified Public Accountant (CPA) required.
Valid North Carolina Driver's License.

Additional Information

Knowledge of:                                                  

  • Techniques and methods for organizing, prioritizing, and monitoring work as needed.
  • Principles and practices of general accounting theory and financial management.
  • Preparing complex financial statements, supporting schedules, and footnote disclosures.
  • Microsoft Excel with at least an intermediate skillset, including pivot tables, V-lookup, and formulas.
  • Internal control frameworks and ability to assess and monitor financial controls.
  • Project management principles.
  • Best practices, trends and emerging technologies.
  • Enterprise-wide software programs (ERP General Ledger and all associated modules)
  • Principles and methods of qualitative and quantitative research.
  • Principles and applications of critical thinking and analysis.
  • Principles and techniques of effective oral presentations.
  • Principles and practices of conflict resolution.
  • Applicable federal, state and local laws, codes, regulations, as it relates to government accounting.
  • Customer service principles.
  • Practices and methods of coaching and leading the work of others (as assigned).
 Skill in:             
  • Working effectively under pressure, with multiple deadlines and balancing changing priorities and work demands.
  • Problem solving and decision-making skills, especially as this relates to reactions to unanticipated issues.
  • Managing a project.
  • Overseeing the implementation and adherence to quality assurance and standards.
  • Gathering data, analyzing findings, and applying critical thinking and reason. Articulating issues and recommendations.
  • Interpreting, compiling, and preparing complex analytical, financial, and administrative data for reports.
  • Researching industry trends, solutions and best practices. Ability to provide recommendations.
  • Authoring and preparing original reports, documents and presentations.
  • Serving in a reviewer capacity for financial transactions and reporting.
  • Facilitating group discussions and building consensus using persuasive reasoning.
  • Providing technical guidance, direction, and education to program stakeholders.
  • Developing and managing business relations in support of financial management.
  • Interpreting and applying applicable laws, codes, regulations and standards, particularly those applicable to governmental accounting.
  • Providing good customer service to internal and external stakeholders.
  • Exercising political acumen, tact, and diplomacy.
  • Establish and maintain cooperative working relationships in support of financial management.
  • Training and coaching staff. Leading the work of others (as assigned).
ADA and Other Requirements: 
Positions in this class typically require: fingering, grasping, talking, hearing, seeing and repetitive motions.
Sedentary Work: 
Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.
Working Conditions:
Work is routinely performed in an indoor, office environment.
Note:
This job classification description is intended to be generic in nature. It is not necessarily an exhaustive list of all duties and responsibilities. The essential duties, functions and responsibilities and Fair Labor Standards Act (FLSA) designation may vary based on the specific tasks assigned to the position.

Benefits

City of Raleigh Employee Benefits
http://www.noegov.net

When you join the City of Raleigh's work family, your benefits are an important part of your "total rewards". Your benefits impact many aspects of your life including your health, your finances, and the protection of your family. The City provides a comprehensive benefits package as part of our total rewards program to support you through important events in your life, to enhance your life outside work, and to help you plan and prepare for the future.

This benefits summary describes benefits that are available to:

  • Regular full-time employees
  • Regular part-time employees
  • Firefighters
  • Police Officers (Law Enforcement Officers)
  • Temporary employees
  • Seasonal employees
  • Interns
Full - Time Regular Employees:

The City's Benefits Package includes:

Paid Time Off

Holidays (12 paid holidays determined by the City Council):

  • New Year's Day
  • Dr. Martin Luther King Jr. Day
  • Good Friday
  • Memorial Day
  • Independence Day
  • Labor Day
  • Veteran's Day
  • 2 Days for Thanksgiving
  • 3 Days for Christmas

Vacation

The City of Raleigh provides paid vacation for you to be away from work for rest and relaxation. Vacation is earned at the rate of 1 day per month, beginning the first of the month, following the completion of 30 days of employment. You are required to complete six months of service before vacation leave will be granted.

Vacation Accrual Schedule is shown below for years of service:

  • 0 - 3 years | (1 day/month = 12 days/year)
  • 4 - 10 years | (1.25 days/month = 15 days/year)
  • 11 - 15 years | (1.5 days/month = 18 days/year)
  • 16 - 20 years | (1.75 days/month = 21 days/year)
  • 20+ years | (2 days/month = 24 days/year)

Note: Employees may accrue up to 50 day. Vacations days over 50 are automatically converted to sick leave.

Sick Leave

The City provides sick leave for you, which is earned at the rate of 1 day per month (12 days per year), beginning the first of the month following completion of 30 days of employment.

Additional Sick Leave

In addition to sick leave, after 8 years of employment, you will have an Additional Sick Leave account and will accrue 5.44 days per month during your 8th year. After 15 years, you will accrue 5.44 days per month during your 15th year. After 25 years, you will accrue 10.88 days per month during your 25th year.

Petty Leave

As a City employee, you earn 12 hours of petty leave per year. Petty leave can be used for attending to personal matters which usually cannot be transacted outside of office hours, such as medical appointments, etc., not to exceed 4 hours in one day.

Health Benefits

Medical Coverage

For many employees, one of the most important decisions you make is selecting the medical plan option that is best for you and your family. The City provides you with the choice of two medical plan options (Blue Options PPO Plan A and PPO Plan B), administered by Blue Cross and Blue Shield of N.C. When you enroll in medical coverage, prescription drug coverage is included.

  • Plan A: The City pays a significant portion of your and your dependents' premiums under Plan A.
  • Plan B: The City pays the full cost of individual coverage and a significant portion of your dependents' premiums under Plan B

Note: The City offers a wellness incentive on medical insurance premiums for employees who complete the requirements of the Health Risk Screening/Assessment and Tobacco Attestation each year.

Coverage for new employees is effective the first day of the month following your date of hire. Premiums for the plan are paid through payroll deductions on a pre-tax basis. We offer the following levels of coverage to cover yourself and your eligible dependents:

  • individual (for employee only)
  • parent/children
  • employee/spouse
  • family

Dental Coverage

Good dental care is an important part of your overall health care. The City provides you with dental coverage and pays a significant portion of the cost for you and your family. Coverage for new employees is effective the first day of the month following your date of employment. Premiums for the plan are paid through payroll deductions on a pre-tax basis. We offer the following levels of coverage to cover yourself and your eligible dependents:

  • individual (for employee only)
  • parent/children
  • employee/spouse
  • family
Life Insurance Benefits

Group Term Life/Accidental Death and Dismemberment Insurance

An important concern for most employees is providing economic security for your family in the event of your death or accidental dismemberment. All regular employees are provided basic life insurance and accidental death and dismemberment in an amount equal to 1 times their base annual salary, up to a maximum of $250,000. The coverage is effective the first day of the month following your date of hire. The City pays the full premium cost for Basic Life/AD&D insurance for you.

Voluntary Term Life Insurance

You may purchase additional Voluntary Life for yourself through payroll deductions in the amount of 1, 2, and 3 times your base annual salary, not to exceed $400,000. You may apply for as much as $125,000 without medical evidence of insurability if you elect it within 31 days of your initial eligibility.

Dependent Life Insurance

You may also purchase Dependent Life coverage for your spouse or dependent children. You may purchase coverage for your dependents in the amount of $2,500 or more through payroll deductions.

Whole Life Insurance

To provide additional life insurance for yourself, you may purchase Whole Life Insurance. Whole Life Insurance is permanent insurance that supplements your term life insurance. Coverage includes a long term care rider, which allows you to access a death benefit for long term care and home health care needs. Guaranteed issue coverage premiums range from $3 to $25 per week.

Flexible Spending Accounts (FSAs)

Flexible Spending Accounts are another valuable feature of the City's Benefits package. A Flexible Spending Account (FSA) is a tax-free account that allows you to pay for essential health care expenses that are not covered, or are partially covered. Expenses include medical/ dental/ vision expenses, child/dependent care expenses, or monthly parking fees. The City has established medical, dependent care, and parking "reimbursement" accounts so that employees may pay for these expenses on a pre-tax basis.

Disability/Accident/Critical Illness

Disability Income Plan

You may purchase short-term disability insurance to replace a portion of your income if you are unable to work due to an off-the-job accident, illness, surgery, or pregnancy. You may enroll in this voluntary payroll deduction plan, which provides up to 60% of your income up to a maximum monthly benefit of $5,000 if you are unable to work.

Accident Insurance

You are eligible to enroll in this voluntary payroll deduction plan, which may supplement your health insurance providing 24-hour coverage for accident-related injuries. Coverage provides lump-sum payments directly to employees for accident related injuries including, but not limited to, broken bones, cuts, burns, eye injuries, ruptured discs, etc. An annual wellness (health screening) benefit is included.

Critical Illness

You are eligible to enroll in this voluntary payroll deduction plan, which provides a lump sum payment if you are diagnosed with a covered critical illness. You may purchase coverage for your spouse. Each dependent child is covered at 50% of the amount of coverage you purchase at no additional cost. A wellness (health screening) benefit is available.

Retirement

N.C. Local Governmental Employees' Retirement System (NCLGERS)

All regular full-time employees are covered under the North Carolina Local Governmental Employees' Retirement System (NCLGERS). As an employee, you contribute 6% of your annual salary on a tax-deferred basis. The City contributes a percentage of your annual salary to your retirement accounts.

Regular Full-Time Employees are eligible for a full unreduced retirement benefit after they:

  • Complete 30 years of creditable service at any age
  • Reach age 60 and complete at least 25 years of creditable service
  • Reach age 65 and complete at least 5 years of creditable service

Regular Full-Time Employees are eligible for a reduced early retirement benefit after they:

  • Reach age 50 and complete at least 20 years of creditable service
  • Reach age 60 and complete at least 5 years of creditable service

Purchase of Creditable Service

Effective January 1, 2003 pre-tax money from an eligible retirement plan or IRA may be accepted via rollover on an in-service plan-to-plan transfer to purchase creditable service. This was approved in October 2003 by Prudential 401(k) and City of Raleigh Supplemental Retirement Plan.

What Does This Mean To You?

If you have withdrawn service, military service, or part time local service, etc., then you can use your funds from your Prudential 401(k) or the City of Raleigh Supplemental Retirement Plan to purchase this service by rolling over the funds.

How Can You Do This?

Contact Human Resources at 919-996-3315 to obtain the forms. You may also go to the following websites to download the forms

Supplemental Retirement Plans

To maximize your retirement income, all regular full-time employees may voluntarily participate in either the City's Supplemental Retirement Plan or the Supplemental Retirement Income Plan of North Carolina 401(K) Plan, or in both plans.

Supplemental Retirement Plan

Participation in this Plan is voluntary. Employees may contribute a minimum of 1.0% of their salary to receive the City's match of 2%, except for law enforcement officers. Contributions can be made on a tax-deferred or after-tax basis.

Supplemental Retirement Income Plan of N.C. 401(k) Plan

All regular full-time employees may participate in the Supplemental Retirement Income Plan of North Carolina 401(K) Plan. Participation is voluntary and officers may contribute up to a maximum level as provided by IRS regulations. Contributions can be made on a tax-deferred or after-tax basis.

The maximum contribution limits for both Plans are $17,500 in 2014.

Note: If you are age 50 or older, you may contribute an additional $5,500 in 2014.

Social Security

City employees are members of the Social Security System. The employee contributes 7.65% of their annual salary and the City contributes the same amount. Social Security benefits include retirement and disability payments and survivor's insurance.

Other Important Benefits

Employee Health & Wellness Center

The City operates an Employee Health Center for its employees, which is used to treat job related injuries and illnesses which occur while employees are at work. All employees are required to have a pre-employment drug screening. Screenings of new employees are to be completed within the first two weeks of employment. Periodic health screenings that include vision, hearing, and blood pressure screening are provided and are required for certain departments.

Wellness Program

The City provides a comprehensive and innovative wellness program, Wellness for Life, to employees. Our wellness program is designed to help employees prevent disease and illness by lowering health risks through education, adopting healthy lifestyles, increasing the use of preventative medical screenings, and preventative health care. Our program also provides management for employees with diseases through work sessions and customized health strategies.

Raleigh Employee Assistance Program (Reap)

The City of Raleigh provides employees and family members with confidential counseling to help resolve problems that may affect their work or family life.

Credit Union

The Local Government Federal Credit Union is available to all regular employees. Employees must complete 6 months of continuous employment and be a Credit Union member before becoming eligible to obtain a loan. In order to keep your membership in the Credit Union, you must have a minimum of $25 on deposit. Savings and loans are insured in the event of your death.

Worker's Compensation

All City employees are covered under the North Carolina Worker's Compensation Act. This act covers those employees who suffer injuries as a result of an accident while performing duties. It will pay medical expenses and a portion of the employee's salary if the individual is out of work as a result of a work related disability.

Tuition Assistance

The City offers a Tuition Assistance Program to those employees who wish to further their education and training. An employee may receive financial assistance up to $1,250 per fiscal year for courses relating to their present job or future position with the City.

Part-Time Regular Employees

Regular part-time employees who work at least 20 hours or more per week are eligible for the City's benefit package. These benefits include:

  • Medical, Dental, and Life insurance (employee pays on prorated basis)
  • Vacation, Sick, and Holidays (earns and is charged on prorated basis)
  • Additional Sick Leave (employee must work the full-time equivalent of the years of service required in order to receive benefit)
  • Petty Leave (6 hours per year)
  • Retirement Plan (employee participates in both NCLGERS and Supplemental Plans; City contributes also)
  • City of Raleigh Credit Union

Part-time regular employees are not eligible for:

  • Award for Service (Longevity)
  • Tuition Assistance
  • Employee Service Awards
Firefighters

If you become a firefighter for the City, you are eligible for all of the benefits listed under the "Regular Full-Time Employees" section of this summary. However, the eligibility for a reduced early retirement benefit under the N.C. Local Governmental Employees' Retirement System is different than the eligibility for a regular full-time employee. (See below)

N.C. Local Governmental Employees' Retirement System (NCLGERS)

Firefighters are eligible for a full unreduced retirement benefit after they:

  • Complete 30 years of creditable service at any age
  • Reach age 60 and complete at least 25 years of creditable service
  • Reach age 65 and complete at least 5 years of creditable service

Firefighter are eligible for a reduced early retirement benefit after they:

  • Reach age 50 and complete at least 20 years of creditable service
  • Reach age 55 and complete at least 5 years of creditable service
Police Officers

Law enforcement officers are eligible for all of the benefits listed under the "Regular Full-Time Employees" section of this summary except for the benefits shown as follows:

N.C. Local Governmental Employees' Retirement System (NCLGERS)

Police Officers are eligible for a full unreduced retirement benefit after they:

  • Complete 30 years of creditable service at any age
  • Reach age 55 and complete at least 5 years of creditable service

Police Officers are eligible for a reduced early retirement benefit after they:

  • Reach age 50 and complete at least 15 years of creditable service

Special Separation Allowance for Law Enforcement Officers

As a law enforcement officer, if you retire on a service allowance (i.e., 30 years of service at any age or age 55 with at least 5 years of service, you may be eligible for a monthly separation allowance payable until you reach age 62, or until you return to any employment with the local government if a LGERS retiree. Other conditions also apply. Contact Human Resources for details, since the City is responsible for making all determinations of eligibility and for making these benefit payments when you retire.

Temporary/Seasonal Employees and Interns

The City employs temporary and seasonal employees and interns who generally are scheduled to work on a short-term basis. However, if you are hired as a temporary or seasonal employee, or as an intern, you are not eligible for the City of Raleigh's benefits package as described in this summary.

Employer
City of Raleigh North Carolina
Department
Accounting & Financial Reporting
Address
222 W. Hargett Street

Raleigh, North Carolina, 27602
Employer
City of Raleigh North Carolina
Department
Accounting & Financial Reporting
Address
222 W. Hargett Street

Raleigh, North Carolina, 27602
Fiscal Analyst, Senior Supplemental Questionnaire
* QUESTION 1
Please select your highest level of education completed.







* QUESTION 2
How much relevant work experience do you have in this field?












* QUESTION 3
How much relevant work experience do you have in financial reporting for government entities?












* QUESTION 4
Does your experience include writing and/or reviewing complex financial statements? Yes or No. If you answered yes to the question above, please describe.
* QUESTION 5
Rate your ability to utilize advanced excel functionality.




* QUESTION 6
How much relevant work experience do you have in enterprise wide software solutions?












* QUESTION 7
Are you a current/active Certified Public Accountant (CPA)?


* QUESTION 8
Do you have a valid North Carolina driver's license (or the ability to obtain within 30 days of hire)?


* Required Question