HCV Data Analyst

Summary

The primary purpose of this position is to ensure the procedures of the program are followed by staff through providing data ticketing, maintaining accurate reports, submission of pertinent data, and reviewing performance and engagement of team members.

All activities must support the Housing Authority of the City of Fort Myers (“HACFM” or “Authority”) mission, strategic goals, and objectives.

Essential Duties and Responsibilities

The position duties and responsibilities listed below describe the general nature and scope of work. Other responsibilities, duties and skills may be required and assigned, as needed.

The HCV Data Analyst is responsible for:

• Submitting PIC/HIP date to HUD
• Assigning and tracking caseloads for Housing Specialists
• Purging and maintaining waitlist for assistance
• Acquire, clean, and validate large datasets from multiple sources.
• Develop dashboards, reports, and visualizations using Excel and Power BI to track KPIs and operational trends.
• Build automated reporting pipelines for recurring business needs.
• Collaborate with cross-functional teams to define data requirements and interpret results.
• Present findings in a clear, structured manner to technical and non-technical stakeholders.
• Maintain data documentation, metadata, and data quality procedures.
• Ensure data accuracy, integrity, and security.
• Support special projects.
• Any other duties assigned by HCV Director

The HCV Data Analyst must be able to:

• Understand, follow, and track HCV Regulations
• Perform descriptive and diagnostic analyses to identify patterns, anomalies, and root causes
• Answer phone calls & emails in a timely manner
• Demonstrate strong organizational & leadership skills
• Provide support and feedback to supervisor
• Successfully work within a team
• Work within HACFM’s and HUD’s timelines and guidelines
• Follow Federal, State, and Local regulations

Behavioral Competencies

This position requires the incumbent to exhibit the following behavioral skills:

Job Knowledge: Exhibits requisite knowledge, skills, and abilities to perform the position effectively. Demonstrates knowledge of policies, procedures, goals, objectives, operational entities, requirements, and activities as they apply to the assigned organizational entity of the Authority; uses appropriate judgment & decision making in accordance with level of responsibility.

Initiative: Proactively seeks solutions to resolve unexpected challenges. Actively assists others without formal/informal direction. Possesses the capacity to learn and actively seeks developmental feedback. Applies feedback for continued growth by mastering concepts needed to perform work.

Safety Awareness: Employee is cognizant of his/her surroundings. Follows proper safety procedures and considers the safety of self and others. Identifies, communicates, and assists in the correction of any safety concerns where appropriate.

Customer Service: Meets/exceeds the expectations and requirements of internal and external customers; identifies, understands, monitors, and measures the needs of both internal and external customers; talks and acts with customers in mind; and recognizes working colleagues as customers.

Teamwork: Balances team and individual responsibilities; exhibits objectivity and openness to others' views; gives and welcomes feedback; contributes to building a positive team spirit; puts success of team above own interests; supports everyone's efforts to succeed.

Reliability: Employee demonstrates sound reasoning and critical thinking by making decisions in line with established Authority expectations. Performs work in a reliable manner that is both accurate and timely. Ensures a positive record of attendance.

Responsiveness and Accountability: Demonstrates a high level of conscientiousness. Holds oneself personally responsible for one's own work and does fair share of work.

Education and/or Experience

• Bachelor’s degree in data Analytics, Computer Science, Statistics, Business, Economics, or related field.
• 1–3 years of experience in data analysis or a related field (optional depending on your needs).
• Strong proficiency in Excel and SQL.
• Experience with BI tools (Power BI, Tableau, Looker).
• Knowledge of statistical methods and data modeling.
• Ability to interpret complex datasets and present insights clearly.
• Strong attention to detail and problem-solving abilities.
• Excellent communication and time-management skills.

Must obtain an HCV Specialist Certification within one year of starting position.

Must possess a valid driver’s license and be insurable under the Authority’s plan.

Technical Skills

• Data Analysis Tools: Excel (advanced formulas, PivotTables, Power Query)
• Business Intelligence Platforms: Power BI, Tableau, Looker, or similar BI tools
• Databases & Querying: SQL (joins, subqueries, data manipulation), familiarity with relational databases
• Programming Languages
• Data Modeling: Ability to design and maintain data models, star/snowflake schema understanding
• ETL Processes: Experience with data extraction, transformation, and loading workflows
• Data Visualization: Ability to create dashboards, reports, and visual presentations of complex data
• Reporting Tools: Power BI Service, SSRS, or other automated reporting systems
• Data Quality & Validation: Experience with data cleansing, de-duplication, and integrity checks
• Statistical Analysis: Basic statistical methods
• Cloud Platforms (if needed): Azure, AWS, or Google Cloud analytics tools
• CRM/ERP Systems: Experience pulling and analyzing data from enterprise systems (Salesforce, Dynamics, SACS, Yardi, etc.)

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

To perform this job successfully, the employee is frequently required to remain in a stationary position. Daily movements include sitting; standing; operating computers and other office equipment; moving about the office; and attending onsite and offsite meetings. The employee must be able to communicate via email and verbally via telephone. The employee must occasionally transport up to 25 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Office environment. The noise level in the work environment is usually moderate.