The City of Houston FINANCIAL ANALYST III in Houston, Texas

FINANCIAL ANALYST III

Print

Apply

FINANCIAL ANALYST III

Salary

$44,000.00 - $60,300.00 Annually

Location

601 Sawyer, TX

Job Type

Full-Time

Department

Housing and Community Development

Job Number

20549

Closing

12/18/2018 11:59 PM Central

  • Description

  • Benefits

  • Questions

POSITION OVERVIEW

Applications Accepted from: All Persons Interested

PN 20549

Department: Housing and Community Development

Division: Finance

Section: Financial Reporting

Reporting Location: 601 Sawyer, Houston, TX 77007

Workdays & Hours: 8 am - 5 pm, Monday - Friday*

  • Subject to change

DESCRIPTION OF DUTIES/ESSENTIAL FUNCTIONS

The City of Houston's Department of Housing and Community Development (HCDD) seeks to create a city in which every resident has an affordable home in a community where they can thrive. Partnering with non-profit, governmental, and local entities, HCDD seeks to strengthen Houston's neighborhoods, provide true housing choice and execute the Mayor's vision for One Houston with complete communities throughout. Since Hurricane Harvey, HCDD is managing more than one billion dollars that are dedicated to helping low and moderate-income families recover.

To achieve this vision, HCDD is seeking a Financial Analyst III to join its financial reporting team. In this position, you will manage the financial reports of one or more grants, including Federal, State and/or Local funding sources.

Key Responsibilities

  • Responsible for timely grant and fund reporting requests such as Budget versus Actuals, Fund Balance, Appropriation Balances, track revenue, budgets, project spending, etc.

  • Prepare dashboards and presentations for monthly financial review meetings

  • Collect project forecast from other departments and maintain the forecasting model

  • Analyze budgets and expenditures in SAP to off premise systems such as IDIS, DRGR, etc. to identify red flags and propose corrective measures

  • Maintain federal reporting as prescribed by The Federal Funding Accountability and Transparency Act

  • Perform other duties as required

Essential Attributes

  • Detail Oriented: Job requires a high level of organizational, time management and prioritizing skills, attention to detail and innovative problem solving

  • Motivated: Must be a self-starter who is well organized with strong analytical skills and work well in a team environment.

  • Computer literate: Must be able to create and generate reports in Excel and Word. SAP experience is a plus.

This is a grant funded position subject to cancellation when funds are depleted and/or contract period ends.

WORKING CONDITIONS

There are no major sources of discomfort, i.e., essentially normal office environment with acceptable lighting, temperature and air conditions. There are occasional minor discomforts from exposure to less-than optimal temperature and air conditions.

MINIMUM REQUIREMENTS

MINIMUM EDUCATIONAL REQUIREMENTS

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

MINIMUM EXPERIENCE REQUIREMENTS

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

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

MINIMUM LICENSE REQUIREMENTS

None

PREFERENCES

  • Strong SAP, Excel and Power BI experience

  • Effective oral and written communication skills

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

Department may administer skills assessment relevant to job description.

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 21

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: http://www.www.houstontx.gov

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

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 information provided.

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.

If you need special services or accommodations, please call 832.393.6090; TTY 7-1-1.

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

• 10 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, Marine 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

Are you currently an employee of the City of Houston - Housing and Community Development Department?

  • Yes

  • No

03

Which of the following best describes your highest level of completed education and related, professional work experience?

  • High school diploma or GED and less than seven years of directly related professional experience,Master's degree or Ph.D. in a closely related field and at least two years of directly related professional experience

  • High school diploma or GED and at least seven years of directly related professional experience

  • Associate's degree in a closely related field and less than five years of directly related professional experience

  • Associate's degree in a closely related field and at least five years of directly related professional experience

  • Bachelor's degree in a closely related field and less than four years of directly related professional experience

  • Bachelor's degree in a closely related field and at least four years of directly related professional experience

  • Master's degree or Ph.D. in a closely related field and less than two years of directly related professional experience

  • Master's degree or Ph.D. in a closely related field and at least two years of directly related professional experience

04

What is your proficiency in MS Excel?

  • No experience with software/program

  • Beginner (e.g. data cleansing, sorting, filtering, duplicating, grouping, formatting, moving/copying data, applying cell borders, simple mathematical formulas, producing summary tables from large data files)

  • Intermediate (e.g. validating data, use advanced functions, MATCH, VLOOKUP, SUM IFS, Pivot Tables)

  • Advanced (All of the above listed skills including power query, power pivots, dashboard like reports in excel with drill downs/ synchronized filters)

05

What is your proficiency in MS Power BI?

  • No experience with software/program

  • Beginner (e.g. clean and transform dirty data to get it ready for modelling. Import and model data from different data sources to create data tables, reports and dashboards. Collaborate and share reports from Power BI)

  • Intermediate to Advanced (All of the above skills including use of simple DAX measures to make the dashboards insightful, and comfortable with using most features in the Power BI tool)

06

What is your proficiency in MS PowerPoint?

  • No experience with software

  • Beginner (e.g. create new presentation, navigate within presentation, formatting characters, etc.)

  • Intermediate (e.g. modify/save template, assign transition to a slide, etc.)

  • Advanced (e.g. insert sound file, embed all/part of a file from another program, add CD audio, etc.)

07

How much experience do you have in accounting, finance and budgets in a grant-funded environment?

  • None

  • Less than one year

  • At least one year but less than three years

  • At least three years but less than five years

  • Five years or more

08

What is your proficiency in SAP – Financial module?

  • Beginner

  • Intermediate

  • Advanced

  • None

    Required Question