Data Analytics Business Analyst - Technical (Business Analyst III

Job Announcement

Make a difference – join our team to empower communities and build futures! The Fairfax County Department of Housing and Community Development (HCD) works in partnership with the Redevelopment and Housing Authority (FCRHA) to serve the people of Fairfax County by creating housing opportunities to promote inclusive and thriving communities. Help make our vision of a community everyone can afford to call home a reality!

This position works within the Central Services – IT team for HCD and the FCRHA, providing critical support for software and information systems. The role focuses on HCD end user support, systems operations, training, and administration of core housing systems including Yardi and MITAS. Also supports upcoming major system expansions, including HCD's transition to cloud-based platforms and the rollout of new modules that improve agency wide efficiency and stakeholder interfaces.

In addition to day-to-day system support, performs advanced technical duties across HCD's enterprise applications. Responsibilities include requirements analysis, application troubleshooting, workflow improvements, and coordinating with DIT and vendors on system configurations. Technical responsibilities include developing and customizing applications  (C#, , .NET Core); designing and optimizing SQL queries and stored procedures; building Power BI dashboards using DAX; supporting SharePoint customization; and assisting with ETL processes through SQL Server and SSIS.

Helps maintain data integrity, supports reporting needs, and contributes to analytics and automation enhancements.

Note:

The interview process will include an in-person interview and practical exercise at our location in Fairfax, Virginia.

MINIMUM QUALIFICATIONS:

Any combination of education, experience, and training equivalent to the following: (Click on the aforementioned link to learn how Fairfax County interprets equivalencies) Bachelor's degree in business, computer science or a field related to the department where the IT services are being used: plus four years of experience analyzing business processes and/or developing/maintaining the main business system, technical platform, or a related system.

CERTIFICATIONS AND LICENSES Driver's license (required at the time of application) NECESSARY SPECIAL REQUIREMENTS:
The appointee to the position must satisfactorily complete a criminal background check and a driving record check. PREFERRED QUALIFICATIONS :

• Direct work experience for a local government entity, public housing or financing authority, or HUD regulated housing programs
• Recent hands-on experience developing technical solutions to meet business requirements, including coordinating with vendors and stakeholders on system functionality and issue resolution.
• Strong programming skills with demonstrated experience  Core, C#, , SQL Server, and application-level development. Skilled in building workflows, automation routines, and custom integrations across enterprise systems.
• Advanced SQL proficiency, including query optimization, stored procedure development, and data modeling. Experience supporting enterprise data warehouses with ETL processes (SQL Server/SSIS) and adherence to data governance best practices.
• Experience creating advanced analytics and automation, including predictive modeling and generating executive-level dashboards using Power BI (DAX) or similar visualization platforms.
• Ability to translate complex technical concepts into clear guidance for non-technical users and leadership, with strong written and verbal communication skills.
• Experience supporting Yardi housing software, MITAS, or similar enterprise housing platforms, with knowledge public housing business processes.
• Understanding of enterprise infrastructure, including network topology, server environments, and system integrations that impact application performance.
• Hands-on experience in IT operations, including help desk support, hardware imaging/configuration, asset management, and endpoint administration.

PHYSICAL REQUIREMENTS :

• Ability to drive a motor vehicle and maintain a valid driver’s license.
• Ability to read information on a…