Staff Analyst

City-of-Houston,-T; Houston (TX); On-site; USD 55,000 - 75,000; Full time

Job summary

The City of Houston’s Housing and Community Development Department is seeking a data-forward analyst to support reporting and forecasting for diverse funding sources. You will manage master map portfolios, ensure data consistency, and build dashboards that visualize program costs and personnel expenditures.

Required are a Bachelor's degree and at least three years of analytical experience, with strong Excel and Power BI skills.

Qualifications

• Bachelor's degree in Public Administration, Business Administration, Finance or related field.
• Three years of professional administrative, financial or analytical experience.

Responsibilities

• Compile and manage master map portfolios supporting data interoperability and funding sources.
• Investigate discrepancies in master maps and improve data consistency across reports.
• Ensure financial reports are accurate, accessible, and aligned with program requirements.
• Oversee data source refreshes to keep dashboards current.
• Prepare and maintain procedure manuals for the reporting team.
• Respond to inquiries and ad hoc analytics requests.
• Represent supervisor in meetings to present findings.

Skills

Excel

Power BI

Education

Bachelor's degree

Tools

Microsoft Excel

Job description

DESCRIPTION OF DUTIES/ESSENTIAL FUNCTIONS

The City of Houston’s Housing and Community Development Department (HCD) 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, HCD strives to strengthen Houston’s neighborhoods and provide true housing choices.

Key Responsibilities

• Compile and manage multiple master map portfolios to support data interoperability across diverse and complex funding sources.
• Investigate discrepancies in master maps and recommend solutions to improve data consistency across all reported funding sources.
• Ensure financial reports are accurate, accessible, and aligned with program requirements.
• Oversee regular refreshes of internal, external, and disconnected data sources to ensure dashboards reflect complete and current program data.
• Prepare, edit, and maintain digital and written procedure manuals for the reporting team.
• Respond to inquiries, correspondence, and ad hoc analytics requests as assigned by the supervisor.
• Represent the supervisor in meetings to gather insights or present findings.
• Collaborate on the creation of dashboards to visualize program and personnel costs.
• Engage with division stakeholders to align dashboard features with operational needs and leverage existing tools.
• Maintain and update projection templates to support accurate forecasting.
• Evaluate and implement technological solutions to streamline systems and enhance the group’s reporting framework such as data maps, data repositories and data flows.
• Support the implementation of DR21, ramp-up activities for DR24, and closeout processes for grants including DR16, DR17, ERA2, and others.
• Contribute to high-priority projects including presentations for the executive team, City Council, and the mayor.
• Participate in professional development activities that elevate work outcomes.
• Perform other responsibilities as assigned by the supervisor.

Essential Attributes

• Detail-Oriented & Analytical: Exceptional organizational and time management skills, with a sharp eye for detail. Capable of prioritizing tasks effectively while applying innovative problem-solving and critical thinking to complex data challenges.
• Self-Motivated & Collaborative: A proactive self-starter who thrives under tight deadlines and maintains a positive, solutions-focused mindset. Able to work seamlessly across cross-functional teams throughout the department to deliver high-impact results

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.

MINIMUM EDUCATIONAL REQUIREMENTS

Requires a Bachelor's degree in Public Administration, Business Administration, Finance or directly related to the type of work being performed.

Substitution:

• Graduate degrees related to the type of work performed may substitute for the experience requirement on a year-for-year basis.

MINIMUM EXPERIENCE REQUIREMENTS

Three years of professional administrative, financial or analytical experience related to the type of work being performed are required.

Substitution:

• Professional experience related to the type of work to be performed may substitute for the education requirement on a year-for-year basis

MINIMUM LICENSE REQUIREMENTS

None.

• Advanced proficiency in MicroSoft Excel
• Intermediate to Advanced proficiency in PowerBI

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

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 26

EEO 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.