The City of Houston FINANCIAL ANALYST III in Houston, Texas
FINANCIAL ANALYST III
FINANCIAL ANALYST III
$44,000.00 - $60,300.00 Annually
601 Sawyer, TX
Housing and Community Development
12/18/2018 11:59 PM Central
Applications Accepted from: All Persons Interested
Department: Housing and Community Development
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.
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
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.
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 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
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.
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.
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
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.
• 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
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?
Are you currently an employee of the City of Houston - Housing and Community Development Department?
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
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)
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)
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.)
How much experience do you have in accounting, finance and budgets in a grant-funded environment?
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
What is your proficiency in SAP – Financial module?