Statistical and Data Specialist II

Under general supervision of the Operations Manager, serves as the Statistical and Data Specialist for the Domestic and Sexual Violence Services Division (DSVS), providing statistical analysis and business intelligence support to DSVS programs, grants, and operations. Key responsibilities include statistical analysis, data cleansing, query development, dashboard and report maintenance, analytics project support, and collaboration with DSVS programs, staff, and community to advance data-informed decision-making.

• Serves as a subject matter expert in data cleansing, statistics, Power BI dashboard development, data queries, and mathematical formulas used to evaluate program performance, operational efficiency, and community impact in support of the DSVS mission.

• Cleanses data, designs, and maintains Power BI dashboards, automated reports, and data visualizations that translate complex DSVS program and DSVS grant data into clear, actionable insights for leadership, program staff, grant owners, and strategic planning.

• Provides analytical and technical support for DSVS grant and funder requirements, including metric development, outcome tracking, data validation, and reporting, ensuring accuracy, compliance, and the effective use of data to demonstrate program impact, inform evidence-based practices, and strengthen DSVS service delivery to survivors and the community.

• Supports DSVS data cleansing, preparation, statistical analysis and modeling, and deployment, monitoring, and documentation of results.

• Ensures data integrity, consistency, and standardization across DSVS data systems.

• Performs special projects and other duties as assigned., + Performs comprehensive DSVS data cleansing, transformation, and quality assurance activities, including identifying errors, troubleshooting workflows, and resolving functional issues in systems and reports.

• Develops and maintains DSVS business intelligence dashboards, automated reports, and visualizations to translate complex data into actionable insights for leadership, program staff, grant owners, and external stakeholders.

• Ensures compliance with local, state, and federal reporting and grant requirements by maintaining formulas, grant catalogs, and Power BI dashboards to support accurate, auditable reporting across the DSVS division and community wide.

• Participates in meetings, committees, and workgroups, serving as a co-lead for data-related initiatives. Contributes to process improvements, delivers presentations, and supports special projects aligned with divisional priorities.

• Provides DSVS division-wide data and statistical consultation, collaborating with leadership and program staff to coordinate data collection efforts, validate metrics, and recommend process and performance improvements.

• Develops and documents standardized data analysis and reporting procedures while strengthening data governance, quality monitoring, and outcomes aligned with strategic initiatives.

• Designs, validates, and maintains data queries, datasets, and reporting pipelines to ensure data consistency, accuracy, and reliability across DSVS operational, programmatic, and grant reporting systems.

• Knowledge of relational databases, query language, statistical software, and business intelligence solutions

• Knowledge of effective processes and techniques to clean, analyze data and assess program performance

• Knowledge of data management and process improvement

• Knowledge of the mission, goals, and objectives of Department of Family Services and Domestic & Sexual Violence Services and/or the Children Services Act

• Knowledge of equity related principles, practices, and outcomes

• Skills in effectively utilizing a variety of software and reporting solutions, such as Microsoft Excel, SPSS or SAS, Power BI or Tableau, Arc GIS, and/or survey software to analyze and present data

• Skills in data management, analysis, research techniques and development of reporting solutions

• Skills in statistical analysis techniques

• Skills in brainstorming, presenting, sharing, discussing, and defending ideas

• Skills in problem-solving, with appreciation and respect for diversity of differing professional views, Any combination of education, experience, and training equivalent to the following: (https://www.fairfaxcounty.gov/hr/equivalencies-education-and-experience) (Click on the aforementioned link to learn how Fairfax County interprets equivalencies for “Any combination, experience, and training equivalent to”)

Graduation from an accredited college or university with a bachelor’s degree in analytics, informatics, mathematics, survey design, statistics, data science, computer science, healthcare administration, or a related field;

Plus two years of professional work experience in data research, quantitative analysis, statistics, data science or data analytics., The appointee to this position will be required to complete a criminal background check and a Child Protective Services Registry check., + Experience in using effective processes and techniques to analyze data and assess program performance.

• Experience effectively utilizing a variety of software and reporting solutions, such as Microsoft Excel, SPSS or SAS, Power BI or Tableau, or ArcGIS to analyze and present data.

• Experience using SQL and/or R

• Experience with processing and integrating complex data.

• Experience with identifying possible solutions to solve problems and present ideas to staff.

• Experience working cooperatively and successfully with internal stakeholders, cross-functional groups, and community partners.

• Experience with speaking in public and giving presentations.

• Master’s degree.

PHYSICAL REQUIREMENTS:

Ability to communicate clearly and concisely, both orally and in writing.

Ability to sit for extended periods, bend, stretch, reach, and lift up to 30 pounds.

Ability to use automated technology.

All duties performed with or without reasonable accommodations.

Fairfax County is home to a highly diverse population, with a significant number of residents speaking languages other than English at home (including Spanish, Asian/Pacific Islander, Indo-European, and many others (https://www.fairfaxcounty.gov/demographics/fairfax-county-general-overview) .) We encourage candidates who are bilingual in English and another language to apply for this opportunity.

Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce.