Data Analytics Business Analyst - Technical (Business Analyst III)

Fairfax County•Fairfax (Fh22), VA

2d•Onsite

About The Position

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 using .NET (C#, VB.NET, .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.

Requirements

Bachelor's degree in business, computer science or a field related to the department where the IT services are being used.
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).
Satisfactorily complete a criminal background check and a driving record check.

Nice To Haves

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#, VB.NET, 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.
Bilingual in English and another language.

Responsibilities

Provide HCD end user support, systems operations, training, and administration of core housing systems including Yardi and MITAS.
Support upcoming major system expansions, including HCD’s transition to cloud-based platforms and the rollout of new modules.
Perform advanced technical duties across HCD’s enterprise applications.
Conduct requirements analysis, application troubleshooting, and workflow improvements.
Coordinate with DIT and vendors on system configurations.
Develop and customize applications using .NET (C#, VB.NET, .NET Core).
Design and optimize SQL queries and stored procedures.
Build Power BI dashboards using DAX.
Support SharePoint customization.
Assist with ETL processes through SQL Server and SSIS.
Maintain data integrity.
Support reporting needs.
Contribute to analytics and automation enhancements.