What are the responsibilities and job description for the Data Analyst II position at Fairfax County, VA?

Salary : $77,640.16 - $129,399.50 Annually

Location : VA 22030 (FJ46), VA

Job Type : FT Salary W BN

Job Number : 25-00055

Department : Sheriff

Opening Date : 01 / 11 / 2025

Closing Date : 1 / 24 / 2025 11 : 59 PM Eastern

Pay Grade : S27

Posting Type : Open to General Public

Job Announcement

This position manages the collection of data and provides analytical expertise to the organization, four divisions and outside agencies. Coordinates, plans, and develops Sheriff's Office data analysis workloads and preparation functions and oversees the performance of all statistical analysis performed in the organization. Reports to the supervisor of the Policy & Planning section in the field of data analytics and works with all divisions in the development of business requirements and associated data, and information needs, metrics, and forecasting. Collaborates with DIT to ensure data analytic solutions meet county standards. Oversees and performs statistical analysis to identify patterns based on aggregate data to find risks or opportunities, as well as make performance change recommendations. Assures timely response to requests for reports, data, and information. Supports and / or serves on special committees, commissions, panels, and fulfills BOS, executive and other requests for analysis as assigned by Command Staff. Participates in requirements development for ensuring data elements and reporting alignment. Stays abreast of data analytics trends, particularly in the correctional, court security, civil process service, medical and mental health arena.

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

Develops data sets and extracts, data standards, and data models to ensure complete, correct, accessible and shareable data for information technology development projects;
Gathers and documents business data, information and analytics requirements;
Assists with and / or develops logical business models;
Prepares physical database design and consolidation, standardization, cleansing, migration, or upload of data;
Assists with planning and facilitating user requirement sessions for data analysis, data standardization, and data ownership;
Analyzes business forms, reports, processes, practices, and procedures;
Identifies data subject areas, data entities, attributes, relationships, information types, domains, and constraints;
Develops structured diagrams, including data flow, entity life cycle, hierarchy, entity / relationships, conceptual schemas, and association matrix diagrams;
Assists with identifying physical implementation requirements such as denormalization, data types, defaults, keys, transformations, referential integrity, and screen / script mapping;
Assists with coordinating the development of logical data standards, definition standards, domain, and type standards, and with the resolution of related conflicts;
Assists with the development of the corporate information architecture and policies;
Maintains metadata, reporting objects, data repositories, and data dictionaries;
Assists with the selection, implementation, and training of data administration practices and data access and CASE tools;
Designs and runs database queries to assess or validate data;
Performs data cleansing and transformations to assess data quality;
Supports data testing and analysis for initiatives of higher complexity;
Attends training workshops, product demonstrations, conferences, technical briefings, and conventions;
Serves on committees and task forces;
Undertakes special projects;
Stays abreast of technology changes;
Provides assistance to other staff, as needed.

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 information systems and the components that process data;

Knowledge of the principles, practices, and methods related to information architecture;

Knowledge of data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control;

Knowledge of data concepts such as syntax, taxonomy, and hierarchy;

Knowledge of relational databases (such as Oracle or DB2) and CASE tools;

Skill in brainstorming, presenting, sharing, discussing, and defending ideas;

Skill in problem-solving, with appreciation and respect for diversity of differing professional views;

Skill working with data modeling tools and relational databases;

Ability to establish and maintain effective business relationships;

Ability to help stakeholders effectively resolve issues related to cross-agency data sharing, usage conflicts, and data inconsistencies;

Ability to follow special formatting requirements and conventions in work products;

Ability to establish and maintain appropriate version control over work products;

Ability to communicate effectively, both orally and in writing;

Ability to make use of provided resources and seek guidance as needed;

Ability to analyze and evaluate administrative processes and procedures for data analysis purposes;

Ability to conduct research into new information technology;

Ability to prepare user manuals and systems documentation;

Ability to translate technical terminology into simple language and concepts;

Ability to train employees in the use of data access tools.

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 four-year college or university with a degree in Information Technology, Information Systems, Computer Science, Business Administration, or related field AND coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and / or marketing; Plus three years of data analysis and information experience in an academic, data administration, or analytics environment that involves using data modeling, ad hoc query, or business intelligence tools, relational databases, metadata and / or taxonomy.

PREFERRED QUALIFICATIONS :

4 year / bachelor's degree

Graduation from an accredited four-year college or university with a degree in Analytics, Informatics, mathematics, survey design, data science, or computer science.

Two years of professional work experience in data research, quantitative analysis, statistics, data science or data analytics.

Two or more years of professional work experience with Law Enforcement, Corrections, or public service agency.

Two or more years of experience cataloging and organizing large datasets, developing reports, and providing practical statistical analysis for a business or agency that previously did not have these processes in place.

Two or more years of utilizing and navigating various software such as Jail Management Systems, ILEADS, Blueteam, ASIS, IA Pro, SMART Communication, PowerDMS or electronic health records.

Two or more years of experience using a reporting tool such as SQL, SSRS, and MS Power BI.

CERTIFICATES AND LICENSES REQUIRED :

None.

NECESSARY SPECIAL REQUIREMENTS :

The appointee to the position will be required to complete a criminal background check, and polygraph exam to the satisfaction of the employer.

PHYSICAL REQUIREMENTS :

Ability to input, access, and retrieve information from a computer. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE : Panel interview and may include 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. Contact 703-324-4900 for assistance. TTY 703-222-7314. EEO / AA / TTY.

Merit Positions

Fairfax County is proud to offer employees an attractive and comprehensive benefits program, including the following :

Medical / Vision / Dental Insurance Coverage

Group Term Life Insurance

Long Term Disability

LiveWell Program

Flexible Spending Programs

Paid Leave (annual, sick, parental, volunteer activity, and more!)

Paid Holidays

Contributory Retirement Plan

Deferred Compensation

Employee Assistance Program

Employees' Child Care Center

Commuter Benefit Program

Continuous Learning Opportunities

NOTE : Fairfax County Government is a qualifying employer under the Public Service Loan Forgiveness program. For more information about the PSLF program :

For additional details please visit the

Non-Merit Positions

Non-Merit Benefit Eligible : scheduled to work a minimum 1,040 hours and no more than a maximum of 1,560 hours in a calendar year.

Medical / Vision / Dental Insurance Coverage

Flexible Spending Program

Deferred Compensation

Temporary : scheduled to work a maximum of 900 hours in a calendar year.

No benefits

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

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

Please indicate the major(s) or minor(s) for your completed degree(s). Check all that apply.

Information technology

Computer science

Business administration

Analytics

Informatics

Mathematics

Survey design

Other (related field)

Other (non-related field)

Not applicable

If you answered "Other (related field)" or "Other (non-related field)" for the previous question, please list all of your majors and minors. If this question does not pertain to you, or you do not have a degree, enter "Not applicable".

Do you currently possess a valid driver's license?

Have you completed coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and / or marketing?

How many years of full-time equivalent experience do you possess in data analysis and information experience in an academic, data administration, or analytics environment that involves using data modeling, ad hoc query, or business intelligence tools, relational databases, metadata and / or taxonomy?

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 or more years

How many years of full-time equivalent 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 or more years

How many years of full-time equivalent professional work experience do you have with Law Enforcement, Corrections, or a public service agency?

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

How many years of full-time equivalent experience do you have cataloging and organizing large datasets, developing reports, and providing practical statistical analysis for a business or agency that previously did not have these processes in place?

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

How many years of full-time equivalent experience do you have utilizing and navigating various software such as Jail Management Systems, ILEADS, Blueteam, ASIS, IA Pro, SMART Communication, PowerDMS or electronic health records?

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

How many years of full-time equivalent experience do you have using a reporting tool such as SQL, SSRS, and MS Power BI?

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

Required Question

Salary : $77,640 - $129,400

Apply for this job

Receive alerts for other Data Analyst II job openings

Data Analyst II

What are the responsibilities and job description for the Data Analyst II position at Fairfax County, VA?

What is the career path for a Data Analyst II?

Job openings at Fairfax County, VA

Not the job you're looking for? Here are some other Data Analyst II jobs in the Virginia, VA area that may be a better fit.

We don't have any other Data Analyst II jobs in the Virginia, VA area right now.

AI Assistant is available now!