Financial Analyst IV - FRO

POSITION OVERVIEW

Applications accepted from: All persons interested

RESPONSIBILITIES:

• Query large data sets from SAP, analyze the data, and prepare financial reports.
• Perform accounting functions such as journal entries, reviewing support for journal entries, year-end accruals, reconciliations of the trial balance, variance analysis, and other technical accounting duties
• Use spreadsheet software to create dashboards, analyses, data forecasts, cash flows, and expense and budget analysis

• Request and validate for adequacy or prepare documents in response to audits, monitoring, and reviews; provide guidance to responses and follow-up requests
• Executes internal review programs, communicates findings to management, and prepares draft reports which include formal recommendations to management for review and implementation

• Acts as a liaison to assigned City departments to provide assistance in handling inquiries and problems.
• Assists with the coordination and fulfillment of compliance and audit requests.
• Participants in improvements to citywide operations and processes.
• Reviews, analyzes, and recommends enhancements to financial programs and systems.
• Assists with preparation of ad-hoc, monthly, quarterly, and annual reports.
• Coordinates with external agencies and City staff to ensure compliance with funding agreements, audit, and reporting requirements

MINIMUM REQUIREMENTS

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

EXPERIENCE REQUIREMENTS
Four years of professional experience in finance, economics, budget analysis or a closely related filed is 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

• Demonstrated ability to work independently under strict time deadlines; able to organize heavy workloads and prioritize multiple responsibilities; good organizational, verbal and written communication skills.
• Advance knowledge of SAP and Microsoft Office, especially Excel.
• Knowledge of analytical financial operations and researching skills.
• Knowledge of and experience with municipal budgeting, accounting, auditing, and reporting procedures.

GENERAL INFORMATION

SELECTION / SKILLS TESTS REQUIRED
Department may administer skills assessment test

SAFETY IMPACT POSITION: NO
If yes, this position is subject to random drug testing and 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.

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

• Medical
• Dental
• Vision
• Wellness
• Supplemental Insurance
• Life insurance
• Long-term disability
• Retirement pension
• 457 deferred compensation plan
• Employee Assistance Program
• 10 days of vacation each year
• 13 city holidays, plus one floating holiday
• Compensable Sick Leave
• Personal Leave
• Flexible schedules
• Hybrid-Telework for eligible positions
• Professional development opportunities
• Transportation/parking plan
• Section 125 pretax deductions
• Dependent Care Reimbursement Plan
• Paid Prenatal, Parental and Infant Wellness Leaves
• Healthcare Flexible Spending Account

• Yes
• No

• Master's Degree or beyond in Finance, Accounting, Business Administration or a closely related field and AT LEAST two (2) 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 two (2) 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 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 LESS THAN four (4) years of professional experience in finance, economics, budget analysis or a closely related field.
• None of the above.

• Accounting
• Finance
• Business Administration
• Other
• I have no degree

• 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

• 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

• Generally Accepted Accounting Principles (GAAP).
• 2 CFR Part 200 Office Management and Budget (OMB) Guidelines.
• Coordinating and managing state/federal audits or compliance reviews.
• Interpreting and remaining in compliance with federal and state regulations related to grants management.
• Utilizing large datasets to create dashboards, analysis, and reports.

• 1 - 2 years of experience
• 3 - 4 years of experience
• 5 years or more of experience
• None of the above

• Yes
• No

Required Question