Financial Reporting Analyst

Position Description

About Harris County Housing & Community Services Department:

This office is focused on addressing the housing, infrastructure and public service needs of the low to moderate-income community in Harris County. This is accomplished through a process of securing and managing grants from the U.S. Office of Housing and Urban Development (HUD) and partnerships with other government and non-profit agencies, resulting in a variety of programs, projects, and services.

Financial Reporting Analyst Overview

Under broad guidance, the Financial Reporting Analyst is responsible for a variety of analytical tasks that include data set management, developing & preparing financial statements, tracking and evaluating budget performance against metrics and actual expenditures, developing ad-hoc financial models and reports (bound, e-format, dashboards, etc...), and funding and resource management. The individual in

this role must be highly creative & energetic and will use their knowledge of data analysis tools, financial reporting & accounting practices to aid the organization in identifying trends, performance, and areas of improvement in a modern and creative financial reporting modeling environment. Analyst will possess great attention to detail, strong analytical skills, proficiency in financial software and reporting platforms (e.g., PowerBI, Tableau, Google Data Studio, Looker, etc...), and must be able to communicate with and at all levels of the organization and participate in the development of information useful for providing input and recommendations on strategic direction.

Duties & Responsibilities:

• Data Management and Collaboration:

• Interfaces with CSD management, financial staff, and technology support team members of the department in identifying relevant data sources with the ability to work efficiently, and deadline oriented while establishing and maintaining quality control over the input and output of data.

• Financial Analysis and Reporting:

• Provides financial analysis and support for operational programs and grants while developing and publishing mission-critical performance reports, and tracking financial performance against metrics and goals for internal and external stakeholders and grantors; responds to requests for information and special report designs for service units & divisions of the department.

• Budget Assistance:

• Assists in the oversight of operational and program budgets that provide control of expenditures to carry out activities associated with federal, state, and local programs as well as working on budget rolls, budgetary adjustments for the ERP, maintaining a reconciliation of appropriations and third-party reporting systems, and performing other special budgetary projects and job-related duties as assigned by management.

• Financial Data Organization:

• Organizes, prepares, and assembles the financial information of the department's service units and programs by fund, project, and activities into user-familiar and friendly formats.

• Account Maintenance:

• Recommends and performs maintenance of account code structure relevant to the general ledger, project & grant ledger yielding flexible and financial reporting formats that the users can easily comprehend.

• Compliance and Performance Analysis:

• Researches and interprets the impact of federal, state, and local regulations of ongoing programs and integrates financial and performance metric benchmarks into reporting.

• Other duties as assigned.

• This Job Description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this position.

• Management may, at its discretion, assign, or reassign duties and responsibilities to this job at any time.

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

This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.

Requirements

Education:

• Bachelor's degree in business, Accounting, Finance, Information Systems, Data Management, or a directly related field from an accredited college or university

Experience:

• Three (3) years of working experience with financial software, financial

data organization, and reporting platforms (e.g., PowerBI, Tableau, Google Data Studio, Looker, etc...).

Licensure:

• Valid Class "C" driver's license (Texas upon hire)

Knowledge, Skills & Abilities:

• Ability to report on performance and outcome-based concepts.

• Ability to pay attention to detail.

• Demonstrated working knowledge of databases, data mapping & analysis.

• Proficient in financial software and reporting platforms (e.g., PowerBI, Tableau, Google Data Studio, Looker, etc...).

• Possesses a high level of analytical skills.

• Intermediate knowledge of Excel.

• Working knowledge of Accounting and reporting practices (Project, Cost, Grant, and Administrative Accounting).

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

Preferred Knowledge:

• Advanced knowledge of Excel.

• Advanced knowledge of complex ERP systems i.e., (PeopleSoft, SAP, Workday, or similar ERP systems).

General Information

Position Type, and Typical Hours of Work:

• Full-Time | Regular

• Monday

• Friday | 8 a.m.

• 5 p.m. (weekends if necessary)

Work Environment and Physical Demands:

• Working in an office environment

• Sedentary work

• Exerting up to 10 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.

• Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Employment may be contingent on passing a drug screen and meeting other standards.

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

• Finance

• Accounting

• Information Systems

• Data Management/Analytics

• Other Related Field

• Unrelated Field

• N/A; No Degree

03

Please describe your educational background (i.e. diploma, degree, certifications, etc.) including the level of education completed, area of study, and completed major and minor programs.

04

Which of the following best describes your verifiable experience with financial software, financial data organization, and reporting platforms (e.g., PowerBI, Tableau, Google Data Studio, Looker, etc...)? (To be considered, qualifying experience must be documented in your application's employment history)

• Less than three (3) years

• Three (3) years or more but less than four (4) years

• Four (4) years or more but less than five (5) years

• Five (5) years or more

• I do not have this experience

05

Please provide details about your verifiable experience with financial software, financial data organization, and reporting platforms (e.g., PowerBI, Tableau, Google Data Studio, Looker, etc...).

• Do not use "See Resume", as we do not use resumes to assess qualifications.* (To be considered, qualifying experience must be documented in your application's employment history) 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

In which of the following concepts do you have professional knowledge and/or experience? (Select all that apply)

• Accounting and reporting practices (Project, Cost, Grant, and Administrative Accounting).

• Databases, data mapping & analysis.

• Advanced knowledge of complex ERP systems i.e., (PeopleSoft, SAP, Workday, or similar ERP systems)

• Advanced knowledge of Excel

• None of the above

07

If you made a selection in regard to the previous question, please describe your knowledge and/or experience. NOTE: Please DO NOT use "See Resume" as we do not use resumes for qualifications. (Type N/A if not applicable)]

08

How would you rate your organization, written and oral communication skills?

• High: Confident/Competent

• Medium: Some areas of strength

• Low: Limited skills

• I do not possess this skill and/or experience

09

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, inser

• Advanced

• Intermediate

• Basic

• Entry Level

• Not proficient

10

This position requires possession of a valid Texas-issued driver's license. Do you meet the above requirement? (Please be sure to include all related details in the Certificates and Licenses section of your application.)

• 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