Business Analyst Ii

Fairfax, Virginia
$72,543.54 - $120,905.82 Annually
Sep 02, 2023
Sep 22, 2023
Full Time
Job Announcement

The Fairfax County Health Department is the largest public health department in Virginia, serving 1.2 million residents from diverse ethnic, cultural, and economic backgrounds throughout Fairfax County, as well as the cities of Fairfax and Falls Church and the towns of Herndon, Vienna, and Clifton. With more than 100 years of leadership in the public health field, we are committed to protecting, promoting, and improving the health and quality of life for all in our community. We invite you to apply to become a member of our thriving workforce, together making a difference in the health of our community!

The Fairfax County Health Department is seeking a mid to senior-level Business Analyst to provide data and business analytics support to the department through extraction of datasets, running database queries, and creating reports. This role will work with a variety of data sources in a SQL environment, performing queries, creating, and automating reports, and exporting data to support analysis. Under direction from the Health Department lead Analyst and Informatics and IT manager, the position will provide technical support and duties in the following areas:

  • 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. including 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 creating and maintaining metadata, reporting objects, data repositories, and data dictionaries.
  • Stays abreast of technology changes and assists with the implementation and training of data administration practices and data access tools.
  • Provide assistance to other staff or/and customers, as needed.

Required Knowledge Skills and Abilities

Knowledge of departmental operations, processes, and procedures;
Knowledge of capabilities of information technology software, hardware, and network
communication technology;
Knowledge of the capabilities of various computer platforms functioning in centralized,
distributed, client server, and stand alone environments;
Knowledge of effective processes, methods, techniques to analyze and evaluate business operations;
Ability to analyze and evaluate administrative processes and procedures for automation purposes;
Ability to conduct research into new information technology;
Ability to train employees in the use of hardware and software;
Ability to prepare user manuals;
Ability to translate technical terminology into terms understandable to management and employees;
Ability to establish and maintain effective business relationships.

Employment Standards

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")
Bachelor's degree in business, computer science or a field related to the department where the information technology services are being used; plus two years of experience analyzing business processes and/or developing/maintaining the main business system, technical platform or a related system.

The appointee to this position will be required to complete a criminal background check, a child protective services check, and a driving records check to the satisfaction of the employer.

  • Strong Knowledge and skills around data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control.
  • Two years of experience conducting descriptive and inferential statistical analysis, data wrangling, data analysis, or advanced analytical reporting.
  • Two years of Experience working directly with electronic medical records or other protected health information and in compliance with the Health Insurance Portability and Accountability Act (HIPAA) and or other regulations.
  • Two years of experience designing reports with business intelligence software such as Power BI or Tableau
  • Demonstrated experience scripting queries and designing objects using relational database software such as Microsoft SQL Server Management Studio or Oracle
  • Proven ability to work in a collaborative environment, remaining flexible to changing priorities and objectives.

Job is generally sedentary in nature, and job requires walking, standing, sitting (for long periods of time), and kneeling, reaching, bending, climbing stairs; uses hands to grasp, handle, or feel. Employee may be required to lift or carry up to 25 lbs. occasionally. Visual acuity is required to read data on a computer monitor. Ability to operate keyboard driven equipment and computer. Ability to drive a motor vehicle. Position frequently communicates and must be able to exchange accurate information with others verbally and in writing. Generally, works in an office environment yet may occasionally be required to perform job duties outside of the typical office setting. All duties performed with or without reasonable accommodations.

Panel interview.

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. EEO/AA/TTY.