Data and Reporting Analyst

TITLE: Data and Reporting Analyst

Pay Type: Salary

FLSA: Exempt

COMPENSATION:

 Min $63,000

Max $87,000

REPORTS TO: Senior Business Analyst

ORGANIZATION SUMMARY

Housing Forward is the backbone organization leading one of the nation's most innovative and successful homeless response systems. Through the All Neighbors Coalition, Housing Forward aligns more than 150 public, private, and nonprofit partners to build a coordinated, data-driven system that resolves homelessness across Dallas and Collin Counties. Since 2021, the community has achieved five consecutive years of reductions in homelessness while Housing Forward has grown into a high-performing lead agency with more than 45 employees driving system strategy, performance management, and cross-sector collaboration.    

Housing Forward is entering its next chapter by implementing bold strategies to ensure no one is forced to sleep outside. The organization seeks strategic leaders who thrive in complex environments, build alignment across diverse stakeholders, and embrace a culture of continuous learning, collaboration, and innovation to drive system improvement.  

POSITION SUMMARY:

The Data Analyst and Reporting Specialist is responsible for the production, analysis, and continuous improvement of performance reporting that supports Housing Forward's programs and system initiatives. This position plays a critical role in ensuring timely, accurate, and actionable reporting for federal, state, and local grants. The Data Analyst and Reporting Specialist transforms complex data into meaningful insights, identifies trends and performance drivers, supports forecasting and projections, and develops scalable reporting processes that improve efficiency as organizational reporting needs grow.

Working closely with the Senior Business Analyst, Grant Management Team, and program teams, this position supports data-informed decision making through routine reporting, data quality management, process improvement, and the development of reporting infrastructure and automation solutions.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:

Manage Grant Performance Reporting and Analysis

· Produce recurring monthly, quarterly, and annual performance reports for organizational programs.

· Monitor key performance indicators and identify emerging trends, risks, opportunities, and areas requiring corrective action.

· Analyze program performance data and prepare summaries, visualizations, and recommendations for leadership and program staff.

· Collaborate with internal teams to investigate data anomalies and resolve reporting discrepancies.

Develop and Scale Reporting Infrastructure

· Design, document, and maintain scalable reporting processes, workflows, and standard operating procedures.

· Identify opportunities to automate manual reporting processes and improve reporting efficiency.

· Support continuous improvement initiatives related to data management, reporting operations, and performance measurement.

· Create and maintain documentation related to report specifications, business rules, and reporting methodologies.

Support Performance Management and Decision Making

· Create dashboards and data visualizations that enable ongoing monitoring of grant and program performance.

· Translate technical findings into clear, actionable insights for non-technical audiences.

· Provide analytical support for program planning, performance management, and operational decision making.

· Assist with ad hoc analyses and special projects related to organizational priorities.

· Support program staff in understanding and utilizing performance data to improve outcomes.

· Present findings and recommendations to internal stakeholders as needed.

Data Quality and Continuous Improvement

· Develop tools and processes to monitor key data quality indicators.

· Partner with program staff and system users to address data issues and improve data collection practices.

· Support testing and validation of reports, dashboards, and reporting enhancements.

Other Duties

· Perform other duties as assigned.

SKILLS AND CAPABILITIES:

· Data Analysis and Interpretation: Strong ability to analyze complex datasets, identify trends, monitor performance, and translate findings into actionable recommendations for program and organizational decision-making.

· Reporting and Performance Management: Experience producing recurring performance reports, developing key metrics, monitoring outcomes, and supporting performance improvement through data-informed insights.

· Forecasting and Strategic Thinking: Ability to evaluate historical and current performance data, identify emerging risks and opportunities, and support forecasting and projection efforts.

· Data Visualization and Communication: Ability to present data in a clear, accessible manner through dashboards, reports, and visualizations that support understanding and action among technical and non-technical audiences.

· Process Improvement and Automation: Demonstrated ability to assess reporting workflows, identify inefficiencies, and develop scalable, repeatable processes that improve reporting accuracy, consistency, and efficiency.

· Technical Skills and Data Management: Proficiency working with large datasets using tools such as Excel, SQL, Power BI, Tableau, or similar business intelligence and reporting platforms.

· Quality Assurance and Attention to Detail: Strong commitment to data accuracy and integrity, including the ability to validate reports, identify discrepancies, troubleshoot issues, and maintain consistent reporting methodologies.

· Project Management and Organization: Ability to manage multiple reporting deadlines, prioritize competing demands, and coordinate tasks across stakeholders while maintaining high-quality deliverables.

· Communication and Collaboration: Strong written and verbal communication skills, including the ability to gather business requirements, explain analytical findings, and collaborate effectively with program staff, leadership, and external partners.

· Independence and Adaptability: Ability to work independently, manage recurring responsibilities with minimal supervision, and adapt to evolving reporting needs in a fast-paced environment.

· Relevant Knowledge: Familiarity with grant-funded programs, performance measurement, government reporting requirements, homelessness response systems, HMIS data, or related human-service environments preferred.

REQUIREMENTS:

· Must have reliable transportation, valid state issued driver’s license and car insurance. Please note that travel is required on a limited basis.

· Must be flexible to work at different sites as scheduled.

· Limited requirements, must be able to maintain files and lift objects that weigh up to 25 lbs.

WORK SCHEDULE:

· Housing Forward considers normal hours of operation Monday – Friday from 8:00am-5:00pm. Some nights and weekend meetings might be required to meet the needs of partner agencies or to represent Housing Forward at community meetings.

· Successful applicant may reside anywhere in the United States and work remotely. Employee must be able to travel to Dallas, TX once a quarter.

COMPENSATION:

· Housing Forward has a flexible PTO policy for all full-time employees. The office is officially closed on New Year's Day, Memorial Day, Independence Day, Labor Day, Thanksgiving, Day after Thanksgiving, Christmas Eve, & Christmas Day. Housing Forward has MLK Jr., Juneteenth, and Election Day as Days of Service.

· This position is eligible for employer-provided benefits:

· Housing Forward pays 90% of employee Medical, Dental, and Vision insurance and 50% of Family Medical, Dental, and Vision insurance.

· Housing Forward provides Basic Life Insurance as well as Short- and Long-Term Disability Insurance.

· Housing Forward will provide a laptop. We will additionally provide the applicant with a phone and/or hot spot if needed.

For additional questions about the position, please contact Daielle Wireman, Senior Business Analyst, at danielle.wireman@housingforwardntx.org