FINANCIAL ANALYST II

City of Houston; Houston (TX); On-site; USD 60,000 - 90,000; Full time

Job summary

The City of Houston is seeking a Financial Analyst II to perform professional financial analysis, develop dashboards, and support multiple City departments with reporting and forecasting.

You will design Power BI dashboards, develop data models, and blend financial data from various sources to produce actionable insights that drive budgeting and performance improvement.

Qualifications

• Requires a Bachelor's degree in Finance, Accounting, Business Administration or closely related field.
• One year of professional experience in finance, economics, financial analysis or related field required.
• Substitutions may substitute education with more experience or degrees as described in the posting.

Responsibilities

• Designing Power BI dashboards to provide timely visibility into budgets, expenditures, revenues, forecasts and performance measures.
• Developing data models and measures to support recurring financial and operational reporting.
• Combining data from financial systems, spreadsheets, databases, and other sources for comprehensive analyses.
• Automating recurring reports to reduce manual data preparation where practical.
• Establishing consistent reporting definitions and methodologies across departments.

Skills

Power BI

Data visualization

Data modeling

SQL

Education

Bachelor's degree in Finance/Accounting/Business Admin

Tools

Power BI

Excel

Job description

Position Overview

Applications accepted from

All Persons Interested

Job Classification

FINANCIAL ANALYST II

Division

Director's Office

Reporting Location

611 Walker 10th Floor

Workdays & Hours

Monday – Friday 8:00 a.m. – 5:00 p.m.* *Subject to Change*

Description Of Duties / Essential Functions

Performs professional financial analysis and provides analytical support to multiple City departments. Analyzes financial statements, budgets, expenditures, revenues, and operational data; prepares financial reports, schedules, graphs, dashboards, and other analytical products; and develops interpretations and recommendations to assist management in making informed financial and operational decisions. This position emphasizes the use of data analytics and visualization tools to transform financial and operational information into meaningful, actionable insights. The Financial Analyst II works collaboratively with City departments to identify trends, monitor financial performance, improve reporting processes, and strengthen financial management practices.

Essential Duties And Responsibilities

DATA & BUSINESS INTELLIGENCE The Financial Analyst II is expected to increasingly leverage data visualization and business intelligence tools to improve the City's ability to understand and act upon financial information. Key responsibilities may include:

• Designing Power BI dashboards that provide timely visibility into departmental budgets, expenditures, revenues, forecasts, and performance measures.
• Developing data models and measures to support recurring financial and operational reporting.
• Combining information from financial systems, spreadsheets, databases, and other sources to produce comprehensive analyses.
• Automating recurring reports and reducing manual data preparation where practical.
• Establishing consistent definitions, calculations, and reporting methodologies across departments.
• Developing visualizations that allow users to drill into financial information by department, division, program, fund, account, period, or other relevant dimensions.
• Identifying opportunities to improve data accessibility, reporting efficiency, and financial transparency.
• Training or assisting departmental users in interpreting dashboards and using analytical tools effectively.

WORKING CONDITIONS

This position is physically comfortable; the individual has discretion about walking, standing, etc. There are no major sources of discomfort in a normal office environment.

EDUCATION

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

Experience

One year of professional experience in finance, economics, financial analysis or a closely related field are required.

SUBSTITUTIONS

Five years of pertinent professional or para-professional experience may substitute for the education requirement.

An Associate’s degree in Finance, Accounting, Business Administration or a closely related field and three years of pertinent professional or para-professional experience may substitute for the education requirement.

A Master's degree in a field directly related to the job may be substituted for the above experience requirement.

LICENSE

None

PREFERENCES

• 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 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

18

EOE Equal Opportunity Employer

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.