Financial Analyst IV - FRO

Print (https://www.governmentjobs.com/careers/houston/jobs/newprint/4500894)

Apply



Financial Analyst IV - FRO

Salary

$66,482.00 - $88,000.12 Annually

Location

611 Walker Street

Job Type

Full Time

Job Number

34125

Department

Finance

Opening Date

05/09/2024

Closing Date

6/8/2024 11:59 PM Central

• Description

• Benefits

• Questions

POSITION OVERVIEW

Applications accepted from: ALL PERSONS INTERESTED

Job Classification: Financial Analyst IV

Division: Financial Reporting & Operations

Reporting Location: 611 Walker Street

Workdays & Hours: MONDAY – FRIDAY 8:00 AM – 5:00 PM Subject to Change

DESCRIPTION OF DUTIES / ESSENTIAL FUNCTIONS

Coordinates and supports the development, implementation and monitoring of various financial activities, including preparation of full cost of service studies for the City of Houston and assist with the development of the City of Houston's Annual Indirect Cost Allocation Plan.

RESPONSIBILITIES:

• Identify the full costs of providing user fee services.

• Establish revenue recovery and cost subsidy policy and recommendations.

• Determine a defensible methodology and process to perform cost of service studies.

• Apply General Accepted Accounting Principles (GAAP) and the Office of Management and Budget (OMB) Circular A-87 federal regulations when performing full cost of service studies.

• Develop written results of cost-of-service studies.

• Perform comparative user fee surveys, comparing the City of Houston user fees to other agencies.

• Perform complex financial analysis and reconciliations.

• Assist with the development of various cost models.

• Develop data request schedules required to perform a full cost analysis and development of the annual Indirect Cost Allocation Plans in accordance with requirements to GAAP and 2 CFR Part 200, Uniform Administrative requirements, Cost Principles and Audit requirements.

• Develop schedules with the proper data to calculate a full cost of service study and indirect cost rates.

• Compile and analyze data; interpret results and draw conclusions and make recommendations.

• Develop specialized reports working with a wide variety of financial data.

• Document results of the analysis and study related to various cost elements.

• Prepare and query SAP reports including interfacing with other City departments to successfully complete various analyses with quality results.

• Represent Division Manager/Finance Department in meetings and gather information.

• Negotiate solutions for problems of medium to high complexity as assigned by the Division Manager/Deputy Assistant Director.

• Interpret administrative policies and oversee communication with department personnel regarding such policies.

• Participate in evaluation and design of workflow, processes, various operations systems, etc.

• Develop technological solutions and systems for continuous improvement programs and other appropriate applications.

• Coordinate and conducts special long term and short-term projects.

  WORKING CONDITIONS

This position is physically comfortable; the individual has discretion about walking, standing, etc. There are no major sources of discomfort in a normal office environment.

MINIMUM REQUIREMENTS

EDUCATION REQUIREMENTS

Requires a Bachelor's degree in Finance, Accounting, Business Administration or a closely related field.

EXPERIENCE REQUIREMENTS

Six years of professional experience in finance, economics, budget analysis or a closely related field are required.

SUBSTITUTIONS:

Experience cannot be substituted for the Bachelor’s degree requirement.

A Master's degree in Finance, Accounting, Business Administration or a closely related field may be substituted for two years of the above experience requirement.

LICENSE REQUIREMENTS

None

PREFERENCES

Preferences will be given to candidates with:

Prefer knowledge of Generally Accepted Accounting Principles (GAAP), 2 CFR Part 200 Office of Management and budget (OMB) guidelines and demonstrates abilities in handling various projects simultaneously developing cost models. Experience in interpreting and remaining in compliance with federal and state regulations related to grants management.

Special consideration will be given to applicants with experience in grant writing and management; SAP and financial reporting experience as well as applicants with strong Microsoft Office products such as Excel, Word, PowerPoint and Publisher. Work is substantially complex and varied and requires the interpretation of technical and detailed guidelines, policies and procedures in combination. Analytical ability is needed to gather and interpret data.

Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6.

GENERAL INFORMATION

SELECTION / SKILLS TESTS REQUIRED - Yes

The department will administer and the applicant must successfully complete a skills-assessment relevant to job description.

SAFETY IMPACT POSITION - No

If yes, this position is subject to random drug testing if a promotional position; candidate must pass an assignment drug test.

SALARY INFORMATION

Factors used in determining the salary offered include the candidate's qualifications as well as the pay rates of other employees in this classification.

Pay Grade: 25

APPLICATION PROCEDURES

Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during posting opening and closing dates shown. Applications must be submitted online at: www.houstontx.gov or call (832)393-6051.

To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm

If you need special services or accommodations, call (832)393-6051. (TTY 7-1-1)

If you need login assistance or technical support call 855-524-5627.

Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process.

All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of the information provided.

EEO Equal Employment Opportunity

The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy.

The city offers a competitive benefits program, including competitively priced health coverage and a defined contribution pension plan.

Benefits include:

• Medical

• Dental

• Vision

• Wellness

• Life insurance

• Long-term disability

• Retirement pension

• 457 deferred compensation plan

• Employee Assistance Program

• 10 days of vacation each year

• 11 city holidays, plus one floating holiday

• Flexible schedules

• Professional development opportunities

• Transportation/parking plan

• Section 125 pretax deductions

• Dependent Care Reimbursement Plan

• Healthcare Flexible Spending Account

For plan details, visit http://www.houstontx.gov/hr/benefits.html

01

Are you a veteran who served on active duty in the Armed Forces (United States Army, Navy, Air Force, Marines Corps, or Coast Guard) for more than 90 consecutive days and received either an honorable discharge or a general discharge under honorable conditions?

• Yes

• No

  02

  Which best describes your education and experience?

• Master's Degree or beyond in Finance, Accounting, Business Administration or a closely related field and AT LEAST four (4) years of professional experience in finance, economics, budget analysis or a closely related field.

• Master's Degree or beyond in Finance, Accounting, Business Administration or a closely related field and LESS THAN four (4) years of professional experience in finance, economics, budget analysis or a closely related field.

• Bachelor's Degree in Finance, Accounting, Business Administration or a closely related field and AT LEAST six (6) years of professional experience in finance, economics, budget analysis or a closely related field.

• Bachelor's Degree in Finance, Accounting, Business Administration or a closely related field and LESS THAN six (6) years of professional experience in finance, economics, budget analysis or a closely related field.

  03

  Which area of concentration did you obtain your degree?

• Accounting

• Business Administration

• Finance

• Other

• I have no degree

  04

  Which of the following best describes your experience in federal and state grants area?

• Less than one (1) year of experience

• One (1) year of experience

• Two (2) years' experience

• Three (3) years' experience

• Four (4) years' experience

• Five (5) years' experience

• More than five (5) years' experience

• I have no experience

  05

  Please indicate your level of proficiency in the Microsoft Office Suite.

• BASIC MICROSOFT OFFICE SUITE: Create a new document, enter text, and save it; navigate in a document and perform a search; format cells, rows, and columns; modify a database and insert data from another; application; create title and bullet slides; work with text, drawn objects, and drawing tools.

• INTERMEDIATE MICROSOFT OFFICE SUITE: Create mail merges, sort and filter them; customize toolbars; run and record Macros; filter data and manage a filtered list; create and modify some Macro commands; create, modify, and format charts; create basic Macros to automate forms and data entry; customize the appearance and functionality of reports; use hyperlinks and perform data integration.

• ADVANCED MICROSOFT OFFICE SUITE: Manage Macro commands, create dialogue boxes, and understand the notions of Visual Basic application programming; use advanced functions (Names, VLOOKUP, IF, IS); work with Pivot Tables; manage Macro commands: concepts, planning, operations, execution, modification, interruption; use Visual Basic to create a public function or event procedures, or add general procedures in a form module; plan and examine an application, develop a distributed application design.

• None of the above

  06

  Which of the following best describes your experience with SAP Financial Systems?

• Less than one (1) year of experience

• One (1) year of experience

• Two (2) years' experience

• Three (3) years' experience

• Four (4) years' experience

• Five (5) years' experience

• More than five (5) years' experience

• I have no experience

  07

  Please indicate which of the following you have strong knowledge of and have worked with on a daily or weekly basis. (Check all that apply)

• Generally Accepted Accounting Principles (GAAP)

• 2 CFR Part 200 Office Management and Budget (OMB) Guidelines

• Ability to understand developing cost models

• Interpreting and remaining in compliance with federal and state regulations related to grants management

• Development of cost modeling and indirect cost allocation plans

• None of the above

  08

  How many years of verifiable progressive professional experience do you have in financial analysis and reconciliation?

• Less than one (1) year of experience

• 1 - 2 years of experience

• 3 - 4 years of experience

• 4 - 5 years of experience

• More than 5 years of experience

• I have no experience

  09

  Please explain your progressive professional experience in financial analysis and reconciliation. (Please note: stating 'See Resume' may delay your application process)

  10

  How many years of verifiable progressive professional experience do you have in financial reporting, including SAP Funds Management?

• Less than one (1) year of experience

• One (1) year of experience

• Two (2) years' experience

• Three (3) years' experience

• Four (4) years' experience

• Five (5) years' or more experience

• I have no experience

  11

  Please describe your experience in preparing Audit reports. (Please note: 'See Resume' may delay your application process)

  12

  Are you currently a City of Houston Employee?

• Yes

• No

  Required Question