Data Analytics Business Analyst - Technical (Business Analyst III

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.

Read about Fairfax County Department of Housing and Community Development, . Review the Fairfax County Redevelopment and Housing Authority reports, .

We are committed to the One Fairfax Policy by intentionally considering equity when making policies, delivering programs and services, considering diverse ideas and perspectives, and communicating with transparency in the decision‑making processes.  to learn more about the One Fairfax policy.

Fairfax County Government offers a thriving career and workplace culture. Watch these videos to learn more:

to watch a video on Working for Fairfax County Government.

to watch a video on benefits offered by Fairfax County Government.

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

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.

Driver's license (required at the time of application)

The appointee to the position must satisfactorily complete a criminal background check and a driving record check.

• 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 in .NET 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…