NCS Data Coordinator (Statistical and Data Specialist II)
Apply NowCompany: Fairfax County, VA
Location: Fairfax, VA 22030
Description:
Salary : $73,994.34 - $123,324.03 Annually
Location : FAIRFAX (EJ27), VA
Job Type: FT Salary W BN
Job Number: 25-00619
Department: Neighborhood & Community Svcs
Opening Date: 03/08/2025
Closing Date: 3/21/2025 11:59 PM Eastern
Pay Grade: S26
Posting Type: Open to General Public
Job Announcement
This position helps coordinate the data and evaluation activities of the department. Reporting to the NCS Data Manager, supports data collection, analysis, reporting and visualization activities for NCS. As a member of the central Data Analytics Team, you will perform agency-level data analysis while developing the agency's capacity for internal and external reporting through collaboration with program areas across the agency.
To learn more about our agency, and the great work we do on behalf of Fairfax County, visit Neighborhood and Community Services.
Illustrative Duties
(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)
Utilizes large, complex relational databases and statistical techniques to perform data analysis and program evaluation;
Works collaboratively with leadership, staff, and partner agencies to assure a system-wide, coordinated approach to data collection and reporting;
Develops data sets, extractions, data standards, and data models to ensure complete, correct, accessible, and shareable data for analytics projects;
Identifies data errors and gaps that impact accurate reporting;
Recommends, and implements improvements, such as changes to business practices, data collection and related processes and procedures;
Ensures compliance with all local, state, and federal regulatory reporting requirements;
Uses statistical packages, reporting programs and tools, and business intelligence software, including, but not limited to, agency Electronic Health Record reporting platform, GIS, SPSS, SQL, and PowerBI;
Synthesizes data, creates reporting tools, and develops data visualizations, published reports and business intelligence dashboards for all levels of the organization, providing data to support agency initiatives;
Works with program staff across the service continuum to develop capacity for data collection, internal and external reporting, and to develop data quality reports to assist staff with monitoring and resolving data errors;
Designs and runs database queries to assess or validate data;
Synthesizes data from various systems and databases; performs data cleansing and transformations to assess data quality; loads data and refreshes reports and dashboards, ensuring data consistency, accuracy, and completeness;
Verifies data accuracy and resolves data that is incorrect, incomplete, improperly formatted, or duplicated;
Provides technical assistance to staff on data collection, measurement and monitoring as needed;
Develops presentations, narratives, tables, and graphs in a variety of formats that are appropriate and understandable to a range to audiences
Health and Human ServicesAnalyzes, and interprets large volumes of healthcare and demographic data from a variety of sources to provide insights for data-driven decision making and quality improvement efforts for agency initiatives, including local, state, and federal reporting mandates;
Participates in all stages of the analytics lifecycle to measure the impact of healthcare services, assess fidelity of evidence-based treatment, assess progress for state and county initiatives, track compliance with value-based healthcare strategies, demonstrate efficiency and effectiveness of healthcare service system, ensure data quality, identify gaps, and improve patient outcomes;
Defines reporting objectives, research methodologies, and assists with development of metrics and measures for the CSB healthcare service delivery system to assess program performance and ensure compliance with all regulatory reporting requirements;
Participates in user requirement sessions for healthcare system data analysis and standardization; Gathers and documents business data and analytics requirements;
Conducts research on behavioral healthcare industry standards, trends, and clinical best practices to facilitate program evaluation efforts and makes recommendations for performance targets.
Required Knowledge Skills and Abilities
(The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)
Knowledge of the principles, practices and methods related to the data analytics life cycle;
Knowledge of relational databases, query language, statistical software, and business intelligence solutions;
Knowledge of effective processes, methods, and techniques to analyze data and assess program performance;
Knowledge of data architecture, modeling, mapping, extraction, transformation, exchange, manipulation, and load techniques;
Knowledge of data management and process improvement;
Ability to analyze and evaluate business processes and procedures for data analysis and process improvement purposes;
Ability to establish and maintain professional relationships;
Ability to translate technical terminology into simple language and concepts;
Ability to evaluate data completeness, accuracy, and inconsistencies;
Ability to provide technical assistance to non-technical staff;
Ability to effectively communicate with a wide variety of audiences;
Skills in data management, analysis, research techniques and development of reporting solutions.
Skills in statistical analysis techniques;
Skills in effectively utilizing a variety of software and reporting solutions, such as agency electronic health record, SAS, SPSS, SQL, ArcGIS, and MS PowerBI, to analyze and present data.
Employment Standards
MINIMUM QUALIFICATIONS:
(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.
NECESSARY SPECIAL REQUIREMENTS:
The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.
PREFERRED QUALIFICATIONS:
PHYSICAL REQUIREMENTS:
Ability to use personal computer, conduct presentations and group facilitation activities. Sustained sedentary work required, primarily at PC, when conducting analysis and writing reports and presentations. All duties performed with or without reasonable accommodations.
SELECTION PROCEDURE:
Panel interview and may include a practical exercise.
The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home () and we encourage candidates bilingual in English and a foreign language to apply to 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.
Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. TTY 703-222-7314. EEO/AA/TTY.
#LI-LD1
NA
01
What is the highest level of education that you have completed?
02
If you answered "Some college" for the highest level of education completed, please indicate the number of quarter or semester hours you have completed towards a degree.
03
Please indicate all major(s) or minor(s) for your completed degree(s). Check all that apply.
04
If you answered "Other (related field)" or "Other (non-related field)" for the previous question, please list the discipline of your degree. If this question does not pertain to you or you do not possess a degree, enter "N/A".
05
How many years of full-time equivalent professional work experience do you have in data research, quantitative analysis, statistics, data science, or data analytics?
06
How many years of full-time equivalent professional experience do you have in modeling and forecasting or public administration?
07
How many years of experience do you have evaluating human service programs and services?
08
How many years of experience do you have developing and analyzing performance metrics?
09
How many years of experience do you have leading and/or participating in cross-functional work groups?
10
How many years of experience do you have building surveys to assess customer satisfaction?
11
Which of the following are included in your professional work experience? Check all that apply.
12
If you indicated "Other" in the previous question. Please specify. If not applicable, please enter N/A.
13
Are you proficient in any of the following? Check all that apply.
14
If you indicated "Other" in the previous question. Please specify. If not applicable, please enter N/A.
Required Question
Location : FAIRFAX (EJ27), VA
Job Type: FT Salary W BN
Job Number: 25-00619
Department: Neighborhood & Community Svcs
Opening Date: 03/08/2025
Closing Date: 3/21/2025 11:59 PM Eastern
Pay Grade: S26
Posting Type: Open to General Public
Job Announcement
This position helps coordinate the data and evaluation activities of the department. Reporting to the NCS Data Manager, supports data collection, analysis, reporting and visualization activities for NCS. As a member of the central Data Analytics Team, you will perform agency-level data analysis while developing the agency's capacity for internal and external reporting through collaboration with program areas across the agency.
To learn more about our agency, and the great work we do on behalf of Fairfax County, visit Neighborhood and Community Services.
Illustrative Duties
(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)
Utilizes large, complex relational databases and statistical techniques to perform data analysis and program evaluation;
Works collaboratively with leadership, staff, and partner agencies to assure a system-wide, coordinated approach to data collection and reporting;
Develops data sets, extractions, data standards, and data models to ensure complete, correct, accessible, and shareable data for analytics projects;
Identifies data errors and gaps that impact accurate reporting;
Recommends, and implements improvements, such as changes to business practices, data collection and related processes and procedures;
Ensures compliance with all local, state, and federal regulatory reporting requirements;
Uses statistical packages, reporting programs and tools, and business intelligence software, including, but not limited to, agency Electronic Health Record reporting platform, GIS, SPSS, SQL, and PowerBI;
Synthesizes data, creates reporting tools, and develops data visualizations, published reports and business intelligence dashboards for all levels of the organization, providing data to support agency initiatives;
Works with program staff across the service continuum to develop capacity for data collection, internal and external reporting, and to develop data quality reports to assist staff with monitoring and resolving data errors;
Designs and runs database queries to assess or validate data;
Synthesizes data from various systems and databases; performs data cleansing and transformations to assess data quality; loads data and refreshes reports and dashboards, ensuring data consistency, accuracy, and completeness;
Verifies data accuracy and resolves data that is incorrect, incomplete, improperly formatted, or duplicated;
Provides technical assistance to staff on data collection, measurement and monitoring as needed;
Develops presentations, narratives, tables, and graphs in a variety of formats that are appropriate and understandable to a range to audiences
Health and Human ServicesAnalyzes, and interprets large volumes of healthcare and demographic data from a variety of sources to provide insights for data-driven decision making and quality improvement efforts for agency initiatives, including local, state, and federal reporting mandates;
Participates in all stages of the analytics lifecycle to measure the impact of healthcare services, assess fidelity of evidence-based treatment, assess progress for state and county initiatives, track compliance with value-based healthcare strategies, demonstrate efficiency and effectiveness of healthcare service system, ensure data quality, identify gaps, and improve patient outcomes;
Defines reporting objectives, research methodologies, and assists with development of metrics and measures for the CSB healthcare service delivery system to assess program performance and ensure compliance with all regulatory reporting requirements;
Participates in user requirement sessions for healthcare system data analysis and standardization; Gathers and documents business data and analytics requirements;
Conducts research on behavioral healthcare industry standards, trends, and clinical best practices to facilitate program evaluation efforts and makes recommendations for performance targets.
Required Knowledge Skills and Abilities
(The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)
Knowledge of the principles, practices and methods related to the data analytics life cycle;
Knowledge of relational databases, query language, statistical software, and business intelligence solutions;
Knowledge of effective processes, methods, and techniques to analyze data and assess program performance;
Knowledge of data architecture, modeling, mapping, extraction, transformation, exchange, manipulation, and load techniques;
Knowledge of data management and process improvement;
Ability to analyze and evaluate business processes and procedures for data analysis and process improvement purposes;
Ability to establish and maintain professional relationships;
Ability to translate technical terminology into simple language and concepts;
Ability to evaluate data completeness, accuracy, and inconsistencies;
Ability to provide technical assistance to non-technical staff;
Ability to effectively communicate with a wide variety of audiences;
Skills in data management, analysis, research techniques and development of reporting solutions.
Skills in statistical analysis techniques;
Skills in effectively utilizing a variety of software and reporting solutions, such as agency electronic health record, SAS, SPSS, SQL, ArcGIS, and MS PowerBI, to analyze and present data.
Employment Standards
MINIMUM QUALIFICATIONS:
(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.
NECESSARY SPECIAL REQUIREMENTS:
The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.
PREFERRED QUALIFICATIONS:
- Experience developing surveys using a variety of survey tools (Public Input, Microsoft Forms, Survey Monkey, Opinio, etc.)
- Experience analyzing survey results and drawing sound conclusions
- Experience presenting data and complex analytical findings to senior leadership, staff, and community members in a clear, concise manner
- Experience developing presentations, narratives, tables, and graphs in a variety of formats that can be easily understood by a variety of audiences
- Experience with a wide variety of software and reporting tools to create infographics and data visualizations including Microsoft PowerBI, Tableau, ArcGIS, and other graphic software packages
- Experience evaluating human service programs and services
- Experience leading and/or participating in cross-functional work groups
- Strong analytical skills with the ability to collect, analyze and disseminate significant amounts of information with attention to detail and accuracy
PHYSICAL REQUIREMENTS:
Ability to use personal computer, conduct presentations and group facilitation activities. Sustained sedentary work required, primarily at PC, when conducting analysis and writing reports and presentations. All duties performed with or without reasonable accommodations.
SELECTION PROCEDURE:
Panel interview and may include a practical exercise.
The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home () and we encourage candidates bilingual in English and a foreign language to apply to 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.
Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. TTY 703-222-7314. EEO/AA/TTY.
#LI-LD1
NA
01
What is the highest level of education that you have completed?
- Less than 12th grade
- High school diploma or GED
- Some college
- Associate's degree
- Bachelor's degree
- Master's degree
- Doctorate degree
02
If you answered "Some college" for the highest level of education completed, please indicate the number of quarter or semester hours you have completed towards a degree.
- Less than 45 quarter hours
- 45 to less than 90 quarter hours
- 90 to less than 135 quarter hours
- 135 to less than 180 quarter hours
- 180 or more quarter hours
- Less than 30 semester hours
- 30 to less than 60 semester hours
- 60 to less than 90 semester hours
- 90 to less than 120 semester hours
- 120 or more semester hours
- Not applicable
03
Please indicate all major(s) or minor(s) for your completed degree(s). Check all that apply.
- Data analytics and management
- Informatics
- Mathematics
- Survey design
- Statistics
- Data science
- Computer science
- Healthcare administration
- Other (related field)
- Other (non-related field)
- Not applicable
04
If you answered "Other (related field)" or "Other (non-related field)" for the previous question, please list the discipline of your degree. If this question does not pertain to you or you do not possess a degree, enter "N/A".
05
How many years of full-time equivalent professional work experience do you have in data research, quantitative analysis, statistics, data science, or data analytics?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five to less than six years
- Six to less than seven years
- Seven to less than eight years
- Eight or more years
06
How many years of full-time equivalent professional experience do you have in modeling and forecasting or public administration?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five to less than six years
- Six to less than seven years
- Seven to less than eight years
- Eight or more years
07
How many years of experience do you have evaluating human service programs and services?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five or more years
08
How many years of experience do you have developing and analyzing performance metrics?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five or more years
09
How many years of experience do you have leading and/or participating in cross-functional work groups?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five or more years
10
How many years of experience do you have building surveys to assess customer satisfaction?
- None
- Less than one year
- One to less than two years
- Two to less than three years
- Three to less than four years
- Four to less than five years
- Five or more years
11
Which of the following are included in your professional work experience? Check all that apply.
- Microsoft Power BI
- Structured Query Language (SQL)
- ArcGIS
- Microsoft Excel
- Microsoft Access
- SPSS, R, or equivalent
- Other
- None of the above
12
If you indicated "Other" in the previous question. Please specify. If not applicable, please enter N/A.
13
Are you proficient in any of the following? Check all that apply.
- Microsoft Forms
- Opinio
- Public Input
- Survey Monkey
- SmartSheets
- Other
- None of the above
14
If you indicated "Other" in the previous question. Please specify. If not applicable, please enter N/A.
Required Question