Skip to main content

This job has expired

Data Analyst I

Employer
Fairfax County Government
Location
Fairfax, Virginia
Salary
$62,693.28 - $104,489.63 Annually
Closing date
Feb 18, 2023

Job Details

Job Announcement

Provides data management and analysis support. Collaborates with HR leadership, other partners, and users to recognize opportunities for improving data collection resulting in accountability and transparency while following applicable laws and regulations required by the County of Fairfax and Commonwealth of Virginia. Works u nder the general direction of the HRIS Division Director, specific duties include:

  • Works in partnership with community users to improve business processes using a range of analytical tools and methods.
  • Serves as point of contact for the PC replacement program as well as resolves printers, scanners, software and networking issues for the DHR.
  • Communicates with the Department of Information Technology to resolve and identify networking and hardware issues.
  • Serves as the liaison for the DHR to the FOCUS Business Support Group (FBSG) to identify and resolve issues with the County’s enterprise software involving the Human Capital Management (HCM) module.


Illustrative Duties

  • 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 preparing physical database design;
  • 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

  • Some knowledge of information systems and the components that process data;
  • Some knowledge of the principles, practices, and methods related to data administration;
  • Some knowledge data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control;
  • Some knowledge of data concepts such as syntax, taxonomy, and hierarchy;
  • Some 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 is sues 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 conduct research into new information technology;
  • Ability to prepare user manuals and systems documentation;
  • Ability to translate technical terminology into simple language and concepts.


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 one year classification, use, or analysis of data experience in an academic, data administration, or analytics environment.

CERTIFICATES AND LICENSES REQUIRED:
Not applicable.

PREFERRED QUALIFICATIONS:
  • Experience with Microsoft Power BI or other well-known BI tool.
  • Experience with data analysis using BI tools, advanced Microsoft Excel functions, such as v-lookup, pivot tables, charts, excel macros, etc.
  • Knowledge of relational databases, SQL, Excel, R, STATA or SAS to produce dashboard, reports, charts, graphs for data analysis trends.
  • Experience in creating and developing reports and dashboards.
  • Experience in working with data from multiple sources and in variety of formats: Excel, csv, databases, etc.
  • Excellent written and verbal skills and organizational excellence.
  • Strong analytical and problem-solving skills.
  • Strong customer service philosophy.
  • Ability to handle confidential information with discretion and integrity.
  • Strong interpersonal and communication skills and the ability to work effectively with a wide variety of constituents in a diverse community.
  • Ability to make recommendations to effectively resolve problems or issues.
NECESSARY SPECIAL REQUIREMENTS:
  • All newly hired employees are required to be fully vaccinated against COVID-19 (two weeks after the last required dose) as a condition of employment or obtain approval of a medical or religious exemption prior to their start date. Proof of an exemption or vaccination status will be required during the pre-employment onboarding process. New employees who obtain an exemption from the vaccine mandate for medical or sincerely held religious beliefs may be subject to a weekly testing requirement. Vaccinated employees and employees with a medical or religious exemption will complete the attestation online on their first day of employment or shortly thereafter.
  • The appointee to the position must satisfactorily complete a criminal background check.
PHYSICAL REQUIREMENTS:
Job is generally sedentary in nature; however, employee must be sufficiently mobile to attend meetings and make presentations. Employee may be required to lift and carry up to 15 pounds. Incumbent must be able to operate keyboard driven equipment. Visual acuity is required to read data on a computer monitor and in printed format. Must have the ability to communicate clearly and concisely, orally and in writing. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE:

Panel interview and may include a written exercise.

The population of Fairfax County is very diverse where 39.8% 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.

Company

Fairfax County, Virginia is a diverse and thriving urban county. As the most populous jurisdiction in both Virginia and the Washington metropolitan area, the County's population exceeds that of seven states. The median household income of Fairfax County is one of the highest in the nation and over half of its adult residents have four-year college degrees or more educational attainment. Fairfax County also is home to an extensive commercial office market and is a major employment center.

Fairfax County Government is a great place to work, with a variety of jobs in different fields, great benefits, and an enjoyable working environment. We serve nearly one million residents in one of the largest counties in the country. Our talented employees have established Fairfax County as a leader in nearly every facet of public service and have won national recognition as innovators in local government.The size of Fairfax County government and the diversity of services it provides to citizens allows opportunities for personal growth and development, without ever having to change employers. In addition to pay, Fairfax County Government provides an employee benefits package worth approximately 25% of your salary in additional compensation. This package of benefits consists of programs designed to protect you and your family during your employment with the county and into your retirement years.


BENEFITS INCLUDE:
Health Insurance
Dental Insurance
Group Term Life Insurance
Contributory Retirement Plan
Deferred Compensation
Flexible Spending Account Programs
Long Term Disability Insurance
Long Term Care Plan
Tuition Assistance Program
Employees' Child Care Center
Virginia College Savings Plans

Fairfax County's Application Process: Fairfax County uses an online application process called NEOGOV at www.fairfaxcounty.gov/jobsfor nearly all positions.

Applicants who need assistance with the online application process are welcome to come to the Application Center at Fairfax County's HR Central where staff will be happy to work with you to establish an account and get your resume into the system. HR Central is located in the Government Center at 12000 Government Center Parkway, Suite 270, Fairfax, VA, and is open Monday through Friday, 8:00 a.m. to 4:30 p.m. Or call 703-222-5872 for more information.

For more information on applying, please click here - https://www.governmentjobs.com/home/applicationguide.

Company info
Website
Location
12000 Government Center Parkway
Suite 270
Fairfax
VA
22035-0034
US

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert