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.

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.

Fairfax County Government offers a thriving career and workplace culture.

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

• Ability to drive a motor vehicle and maintain a valid driver s license.
• Ability to read information on a computer monitor; effectively communicate; operate keyboard-driven equipment and computer.
• Ability to stand, stoop, bend, stretch, walk, climb, sit, kneel, crouch, reach, crawl, lift and handle materials with manual dexterity.
• May occasionally work in outdoor weather conditions.
• Work is generally active in nature; incumbent must be sufficiently mobile and frequently move about to perform essential job duties; may be required to move items up to 25 pounds in weight.
• All duties performed with or without reasonable…