What are the responsibilities and job description for the Data Analyst I position at Fairfax County, VA?
Salary : $67,425.90 - $112,377.41 Annually
Location : FAIRFAX (EJ28), VA
Job Type : FT Salary W BN
Job Number : 25-00118
Department : Fire & Rescue
Opening Date : 01 / 11 / 2025
Closing Date : 1 / 24 / 2025 11 : 59 PM Eastern
Pay Grade : S24
Posting Type : Open to General Public
Job Announcement
Provides analytical support to the Fire and Rescue Department through extraction of datasets, running database queries, and creating reports. Works with a variety of data sources in a SQL environment, performing queries, creating, and automating reports, and exporting data to support analysis. Uses a variety of proprietary and open-source data sources to prepare comprehensive analysis and reports utilizing business intelligence / visual analytics tools to support the needs of the Fire and Rescue Department. Participates in the analysis of available data, assessing data integrity, defining reporting objectives, and identifying areas for improvement. Collaborates with other analysts to perform reoccurring and special studies of operations data. Supports new application development efforts for data needs. Assists with creating and maintaining metadata, reporting objects, data repositories, and data dictionaries. May participate in the development of metrics and measures.
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.)
- Assists with the development of data sets and extracts, data standards, and data models to ensure complete, correct, accessible and shareable data for information technology development projects;
- Assists with gathering and documenting business data and information requirements;
- Assists with analyzing business forms, reports, processes, practices, and procedures;
- Assists with the development of logical data models, including the identification of data subject areas, data entities, attributes, relationships, information types, domains, and constraints;
- Assists with the development of 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, referential integrity, and screen / script mapping;
- Assists with the development of logical data standards, definition standards, domain, and type standards;
- Assists with creating and maintaining metadata, reporting objects, data repositories, and data dictionaries;
- Assists with the implementation and training of data administration practices
- and data access tools;
- Designs and runs basic database queries to assess or validate data;
- Performs basic data cleansing and transformations to assess data quality;
- Supports data testing and analysis for initiatives of higher complexity;
- Prepares for physical database design and consolidation, standardization, cleansing,
- migration, or upload of data;
- Maintains data repositories and facilitates data access for users;
- Attends training workshops, product demonstrations, conferences, and technical briefings;
- 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.)
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, one year classification, use, or analysis of data experience in an academic, data administration, or analytics environment.
PREFERRED QUALIFICATIONS :
CERTIFICATES AND LICENSES REQUIRED :
None.
NECESSARY SPECIAL REQUIREMENTS :
The appointee to this position will be required to complete a criminal background check and sanctions screening to the satisfaction of the employer. PHYSICAL REQUIREMENTS : Ability to input, access, and retrieve information from a computer. All duties may be performed with or without reasonable accommodations. SELECTION PROCEDURE : Panel interview; may include exercise.
The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at homeand 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.
LI-SP1
Merit Positions
Fairfax County is proud to offer employees an attractive and comprehensive benefits program, including the following :
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
Medical / Vision / Dental Insurance Coverage
No benefits
What is the highest level of education that you have completed?
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.
Please indicate the major(s) or minor(s) for your completed degree(s). Check all that apply.
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".
Have you completed college level coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and / or marketing?
How many years of full-time equivalent classification, use, or analysis of data experience do you have in an academic, data administration, or analytics environment?
Do you have experience working within a public safety or first responder agency (fire department, police department, emergency communications (911), etc.)?
Do you have experience working directly with electronic medical records or other protected health information and in compliance with the Health Insurance Portability and Accountability Act?
How many years of full-time equivalent professional experience do you have conducting descriptive and inferential statistical analysis?
How many years of full-time equivalent professional experience do you have conducting data wrangling, data analysis, or advanced analytical reporting?
How many years of full-time equivalent professional experience do you have scripting queries and designing objects using relational database software such as Microsoft SQL Server Management Studio?
How many years of full-time equivalent professional experience do you have designing reports with business intelligence or data visualization software such as Power BI or Tableau?
Required Question
Salary : $67,426 - $112,377