Grant Analyst IV

Position Description

Harris County Public Health has earned the 2023 Best Place for Working Parents Business Designation.

About Harris County Public Health:

Harris County Public Health (HCPH) includes a network of more than 700 public health professionals working together to improve health outcomes for the third most populous county in the United States. HCPH provides a multitude of services such as medical and dental services, community programming, and health education for the approximately 2.3 million people in unincorporated Harris County. Through its core values of innovation, engagement, and health equity, HCPH strives to bring meaningful solutions to public health issues while keeping Harris County healthy and vibrant.

Position Overview:

The Grant Analyst is responsible for key financial analysis and management functions related to the administration of Ryan White Part A, Ending the HIV Epidemic (EHE), and related HIV services federal funding from the Health Resources and Services Administration (HRSA). This position will provide leadership and guidance for statutory and ad-hoc audits of HRSA-funded subrecipients, support overall subrecipient monitoring efforts and assist in the preparation of prepared financial reports to the County and HRSA.

Duties & Responsibilities:

• Performs assessments of subcontractor fiscal management systems, prepares reports, and manages internal Excel spreadsheets, such as the Allocations & Procurement report.

• Documents all findings and ascertains that policies and procedures are being followed and proper accounting procedures are in effect. Prepares audit programs to plan and schedule Subrecipient audits to assure grant compliance is part of audit activities.

• Prepares formal reports of site visits and desk reviews summarizing agency compliance with applicable standards including recommendations for improving internal contractors and operational deficiencies.

• Conducts analysis of Final Financial Reports submitted annually by Subrecipient agencies for each funded subcontract to ensure funds are expended in accordance with applicable laws, rules and HRSA grant policies.

• Provides financial management training and technical assistance to enhance overall monitoring efforts. Assists in the review of Subrecipient contracts, budget forms and Contract Review Certification (CRC) prior to their submission for final approval.

• Coordinates submission of Subrecipient independent audit report (A-133) to Harris County Auditor. Assists in the review of annual, fiscal and/or single Audit reports of grant Subrecipients.

• Assists with the development of annual Part A and EHE budgets, monitoring expenditures, operational planning, quarterly forecasts, and strategic plans in alignment with internal strategic priorities and strategies.

• Provides timely, accurate reports and analysis of operational performance against historical data and current Part A and EHE budgets.

Harris County is an Equal Opportunity Employer

https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx

If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net

Requirements

Education:

• Bachelor's Degree in Business, Accounting, Public Administration, Finance, or a related field

Experience:

• At least five (5)years of grant, non-profit, or government financial or accounting experience

• At least one (1) year Oracle/PeopleSoft experience

• TX Driver's License required

Knowledge, Skills and Abilities

• Proficient in MS Office Suite (Word, Excel, PowerPoint, Outlook)

• Excellent communication skills (verbal & written)

• Budget management skills and strong analytical abilities

• Skilled in providing technical assistance on complex budget issues.

Core Competencies:

Organizational Leadership

• Understands the organizational mission

• Understands ethics and public good; is concerned with public trust

• Demonstrates respect for the opinions and beliefs of others

Collaboration

• Contributes to an inclusive workplace where equity, diversity, inclusion, and individual differences are valued and leveraged to achieve the vision and mission

• Demonstrates a sense of responsibility for the success of the group

• Collaborates with others to improve quality and address needs

Innovation

• Ability to adapt to change

Interpersonal Abilities/Personal Characteristics

• Treats others with courtesy, sensitivity, and respect

• Behaves in an honest, fair, and ethical manner

• Assesses and recognizes own strengths and weaknesses

• Uses sound judgment

• Self-motivated

• Organizes and maintains work environment to allow for maximum productivity

Communication

• Communicates clearly and effectively, both orally and in writing

NOTE: Qualifying education, experience, knowledge, and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.

Preferences

Experience:

• Two (2) years of auditing experience working on grants

General Information

Position Type, and Typical Hours of Work:

• Full Time | Regular

• Monday

• Friday | 8:00a.m.

• 5:00p.m

• Other days and hours as necessary.

• Position requires local travel 20% of the time to make financial monitoring site visits of Ryan White funded agencies.

Work Environment:

• This job operates in a professional office environment.

• This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical Demands:

• This is largely a sedentary role; however, some filing is required. This would require the ability to lift files up to 10 pounds, open filing cabinets and bend or stand as necessary.

Work Location:

• 1111 Fannin St, Houston, 77002

Employment is contingent upon passing a background check.

Due to a high volume of applications positions may close prior to the advertised closing date or at the discretion of the Hiring Department.

BENEFITS

Harris County offers a competitive benefits program, including comprehensive group health and related benefits plan as well as defined benefit retirement plan.

The following list of benefits is offered only to employees in regular (full-time) positions:

• Medical Coverage

• Dental Coverage

• Vision Coverage

• Wellness Plan

• Life Insurance

• Long-term disability

• Employee Assistance Program

• Ten (10) days of vacation each year for the first five (5) years of service

• Accrual rates increase based on years of service

• Eleven (11) County-observed holidays and one (1) floating holiday

• Professional development opportunities

• Dependent Care Reimbursement Plan

• Healthcare Reimbursement Account

• 457 Deferred Compensation Plan

The following benefits are also available to regular (full-time) employment and may be available to part-time employees:

• Retirement Pension (TCDRS)
• Flexible schedule (varies by department)
• Transportation Assistance (Metro RideSponsor Program)

In accordance with the Harris County Personnel Regulations, Group Health and related benefits are subject to amendment or discontinuance at any time. Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.

For plan details, visit the Harris County benefits website:

https://benefitsathctx.com/

01

Which of the following best describes your highest level of education completed as it relates to this position?

• High School or GED diploma

• Associate Degree

• Bachelor's Degree

• Master's Degree or higher

• None of the above

02

If you selected a college degree in response to the previous question, which of the following best describes your major?

• Business

• Accounting

• Public Administration

• Finance

• Other Related Field

• Unrelated Field

• N/A; No Degree

03

Please describe your educational background including level of education completed, area of study and completed major and minor programs.

04

Which of the following best describes your verifiable grant, non-profit, or government financial or accounting experience? (To be considered, qualifying experience must be documented in your application's employment history)

• Less than five (5)
• Five (5) or more
• I do not have this experience

05

Please provide details about your verifiable grant, non-profit, or government financial or accounting experience. Do not use "Please see Resume" or "See Resume" (To be considered, qualifying experience must be documented in your application's employment history) Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilities If you do not have this experience, please type "None" in the space provided.]

06

Which of the following best describes your verifiable Oracle/PeopleSoft experience? (To be considered, qualifying experience must be documented in your application's employment history)]

• Less than one (1) year

• One (1) year or more

• I do not have this experience

07

Please provide details about your verifiable Oracle/PeopleSoft experience. Do not use "Please see Resume" or "See Resume" (To be considered, qualifying experience must be documented in your application's employment history) Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilities If you do not have this experience, please type "None" in the space provided.

08

Which of the following describes your level of proficiency using a personal computer and common office software such as MS Office Suite (Word, Excel, PowerPoint, and Outlook). Please select your level of proficiency based on the following descriptions: Advanced: A person with this level of skills is able to produce very large, complex formal documents that require a table of contents, footnotes, endnotes, bookmarks, and other special elements; a wide range of graphic effects, and use advanced techniques for analyzing and manipulating data. Has full mastery of Macro commands and skills to tie the objects together into a cohesive system by using Macros and Visual Basic for Applications code. Makes interactive presentations by using hyperlinks and action buttons. Intermediate: A person with this level of skills is able to customize toolbars, import and insert graphs, embed Excel data, and elaborate reports. Understands the concepts of databases and is able to work with charts and to use the list management capabilities of Excel. Able to use complex query techniques, create efficient forms and reports, and create Macros to automate these forms. Makes interactive presentations by using hyperlinks and action buttons. Basic: A person with this level of skills is able to use basic formatting, editing, printing functions, and understands the document page setup. Has the ability to enter and correct data, modify a workbook, format a worksheet, and use printing functions. Understands the different database concepts and structures and is familiar with data validation and is able to create a simple presentation in PowerPoint, run it, and print it. Entry Level: A person with this level of skills has the ability to open, create, save and modify documents in Word, send and receive email in Outlook and create spreadsheets in Excel. Format documents for printing, comfortable using the printer menu to preview documents. Has ability to change the font, the margins, insert or delete pages and use the built-in spellchecker and grammar check.

• Advanced

• Intermediate

• Basic

• Entry Level

• Not proficient

09

This role requires a Valid Driver's License (Texas upon hire) Do you have a Valid Driver's License?

• Yes, I have a Valid Texas Driver's License

• Yes, I have a Valid Driver's License but understand I must obtain a Valid Texas Driver's License prior to start date

• No, I'm not interested

Required Question

Agency Harris County

Address 1111 Fannin St

Ste. 600

Houston, Texas, 77002

Phone 713-274-5445

Website https://www.governmentjobs.com/careers/harriscountytx