You are viewing a preview of this job. Log in or register to view more details about this job.

Data Analyst II

Fairfax County Government
Email

Job Announcement

 

This is a reannouncement. Applicants who wish to revise their original application are encouraged to reapply with a revised application.  Otherwise, all applicants who previously applied do not need to reapply to be considered.

 


Provides analytical support to the Fire and Rescue Department through creation and extraction of datasets, modeling data, and creating reports. Works with a variety of data sources in a SQL and Microsoft Power Platform environment, performing queries, integrating disparate datasets, automating reports, and visualizing 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 department. Participates in data wrangling, defining reporting objectives, identifying areas for improvement, and thoroughly documenting methodology. 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, data dictionaries, and indices. May participate in the development of metrics and measures. Serves as lead on complex analyses, business process improvement initiatives, and special projects. Designs and delivers training to civilian and uniformed staff. Collaborates with DIT Public Safety division, e-Government and GIS divisions to ensure data analytic solutions meet county standards. 

 

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:   
Any combination of education, experience, and training equivalent to the following: 
(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: 

  • Demonstrated ability to develop logical research methods, conduct data analysis, and produce detailed reports and methodology documents.
  • Experience conducting descriptive and inferential statistical analysis.
  • Experience conducting data wrangling, data analysis, or advanced analytical reporting.
  • Experience working within a public safety or first responder agency (fire department, police department, emergency communications (911), etc.).
  • Experience working directly with electronic medical records or other protected health information and in compliance with the Health Insurance Portability and Accountability Act.
  • Experience scripting queries and designing objects using relational database software such as Microsoft SQL Server Management Studio or Oracle.
  • Experience designing reports with business intelligence software such as Power BI or Tableau.
  • Experience designing automation processes with Microsoft Power Automate.
  • Experience designing applications with Microsoft Power Apps.
  • Experience designing data collection and reporting tools using Esri’s Survey 1-2-3.
  • Experience designing and delivering in-person and virtual technical training and developing original supplemental materials.
  • Proven ability to work in a collaborative environment, remaining flexible to changing priorities and objectives.
  • Knowledge of the National Fire Incident Reporting System (NFIRS), National Fire Protection Association (NFPA) standards, and National Emergency Management Services Information System (NEMSIS).

CERTIFICATES AND LICENSES REQUIRED: 
None.

NECESSARY SPECIAL REQUIREMENTS:
The appointee to the 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 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 (Spanish, Asian/Pacific Islander, Indo-European, and others) 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. DHREmployment@fairfaxcounty.gov  EEO/AA/TTY.