Data Analyst III

Data Analyst III

Salary

$88,765.46 - $155,339.60 Annually

Location

HERRITY BUILDING (B-2), 12055 GOVERNMENT CENTER PKWY, FAIRFAX (EJ26), VA

Job Type

FT Salary W BN

Job Number

26-01152

Department

Park Authority

Opening Date

08/01/2026

Closing Date

8/14/2026 11:59 PM Eastern

Pay Grade

S29

Posting Type

Open to General Public

• Description
• Benefits
• Questions

Job Announcement

Join the Fairfax County Park Authority (FCPA) and our nationally recognized team of professionals! We are seeking an experienced data warehouse administrator to be a part of one of the most highly regarded park systems in the country. With more than 25,000 acres of parkland, nine Rec Centers, eight golf courses, three lakefront parks, and more, FCPA is an exciting organization to be a part of and there are many opportunities for staff to make a difference at every level. Under limited supervision of the IT Program Manager, serves as the senior developer and administrator for the Park Authority's data warehouse. Defines requirements, designs, develops, tests, debugs, and maintains the agency's data warehouse, associated system interfaces, and business intelligence solutions. Ensures data integrity, availability, security, and reliable backups are performed. Facilitates data sharing with remote systems and agency transactional systems. Plans, evaluates, and implements new database systems or upgrades to existing solutions that enhance operational and administrative functionality for the agency. Meets with customers to determine system needs during implementations, system upgrades, or enhancements. Ensures data within the data warehouse is structured appropriately for use in agency business intelligence tools and reports. Maintains database technology refresh schedule for the agency. Creates and maintains data governance policies and best practices for the agency. Maintains appropriate access to sensitive or legally protected data. Organizes, prepares, and maintains system documentation. Provides technical support to users and responds to ad hoc data requests.

Key Responsibilities

• Manages database and data architecture by designing, implementing, and optimizing storage solutions, including schemas, partitioning, indexing, and data modeling to balance performance, scalability, and cost for transactional and analytical workloads.
• Defines requirements, designs, develops, tests, debugs, and maintains the agency's data warehouse and associated system interfaces to data sources.
• Designs, builds, and maintains ETL (Extract, Transform, Load) pipelines using orchestration tools (e.g., Apache Airflow, Azure Data Factory, FME Form) and big data frameworks (e.g., Spark, Hadoop) to transport raw data from multiple sources into a centralized data warehouse.
• Collaborates with business analysts, data analysts, GIS analysts, and subject matter experts to design and provide optimized datasets to meet agency business needs and enable data-informed decision making.
• Creates and maintains data governance policies and best practices in accordance with the Department of Information Technology (DIT) to ensure consistency across agencies. Writes agency policy and best practice documentation that determines data design, data quality, data transformation, data retention, data sharing and data security standards, in alignment with enterprise standards set by DIT.
• Ensures data quality and adherence to data governance and security policies through validation rules, monitoring, and database design. Ensures compliance with all regulatory frameworks such as GDPR and HIPAA.
• Performs other duties as required to support business intelligence and data efforts.

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

• Mentors the work of lower-level data analysis, providing work counseling, guidance, and training as needed;
• Develops data standards, analytic schemas, and complex data models to ensure complete, correct, accessible and shareable data for information technology development projects;
• Gathers and documents business data, information, physical, and analytics requirements;
• 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;
• Designs reporting schemas and data models of moderate to advanced scope and complexity Identifies and documents 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;
• Assesses disparate databases for streamlining, standardization, and consolidation opportunities, designing appropriate schemas to enable modernization or optimization;
• 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 shared information assets including logical data standards, definition standards, domain, and type standards, and with the resolution of related conflicts;
• Provides key input to the development of the corporate information architecture, policies, and methodologies;
• Maintains metadata, schemas, data repositories, and data dictionaries;
• Assists with the selection, implementation, guidance and training of data administration practices, 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 high 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.)

• Considerable knowledge of information systems and the components that process data; Considerable knowledge of the principles, practices, and methods related to information architecture;
• Considerable knowledge of data administration areas such as policies and standards, data definition, modeling and logical design, database design, and quality control; Considerable knowledge of data concepts such as syntax, taxonomy, and hierarchy; Considerable knowledge of relational databases (such as Oracle or DB2) Knowledge of business intelligence solutions or data-related CASE and modeling tools;
• Knowledge of data modeling mapping, cleansing, extraction, exchange, manipulation, and load principles;
• Extensive knowledge of business process analysis and redesign;
• Some knowledge of business intelligence and information system design principles;
• Some knowledge of services-oriented architecture, object-oriented application development, data integration, data exchange protocols, or XML schema design;
• Skill in brainstorming, presenting, sharing, discussing, and defending ideas;
• Skill in problem-solving, with appreciation and respect for diversity of differing professional views;
• Skill in leading meeting participants toward consensus;
• Skill in designing and presenting conforming, efficient, and unambiguous models and diagrams of complex reporting and information systems;
• Skill in applying work and ideas to advance enterprise architecture goals and objectives: 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 essential task deliverable and 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 five years analysis of data and information experience in an academic, data administration, or business data analytics environment that involves using data modeling, database consolidation, ad hoc query, or business intelligence tools, relational databases, metadata, XML schema design, and/or taxonomy.

CERTIFICATES AND LICENSES REQUIRED:

Drivers License (Required)

NECESSARY SPECIAL REQUIREMENT:

The appointee to the position will be required to complete a criminal background check and driving record check to the satisfaction of the employer.

PREFERRED QUALIFICATIONS:

• 3-5+ years working in data warehousing or database development and maintenance.
• Strong experience with ETL tools and experience building and optimizing data pipelines.
• Experience with transactional database platforms (SQL Server, Oracle, PostgreSQL)
• Experience with cloud data warehousing platforms (e.g., Snowflake, AWS Redshift, Azure Synapse, Google BigQuery).
• Experience with governance frameworks, lineage, and metadata management.
• Proven collaboration skills with analytics/AI teams, including query optimization and dataset preparation.
• Excellent technical communication, problem-solving, and organizational skills.
• Experience in public sector or large-scale data environments.

PHYSICAL REQUIREMENTS:

Mostly sedentary with walking and lifting up to 10 lbs. All duties may be performed with or without reasonable accommodations.

SELECTION PROCEDURE:

Panel interview; may include exercise.

Fairfax County is home to a highly diverse population, with a significant number of residents speaking languages other than English at home (including Spanish, Asian/Pacific Islander, Indo-European, and many others.) We encourage candidates who are bilingual in English and another language to apply for 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. TTY 703-222-7314.DHREmployment@fairfaxcounty.govEEO/AA/TTY.

#LI-SP1

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
• Continuous Learning Opportunities

Please click here for a summary of our benefits.

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

For additional details please visit the Countys benefits webpage.

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

01

What is the highest level of education that you have completed?

• Less than 12th grade
• High school diploma or GED
• Some college
• Associates degree
• Bachelors degree
• Masters degree
• Doctorate degree

02

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

03

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

• Information Technology
• Information Systems
• Computer Science
• Business Administration
• Other (related field)
• Other (non-related field)
• Not applicable

04

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

05

Do you have any college-level course work in coursework in analytics, biosystematics, biology, information architecture, engineering, library science, statistics, sociology, demographics, and/or marketing?

• Yes
• No

06

Do you currently possess a valid drivers license?

• Yes
• No

07

How many years of full-time equivalent data and information analysis experience do you have in an academic, data administration, or business data analytics environment that involves using data modeling, database consolidation, ad hoc query, or business intelligence tools, relational databases, metadata, XML schema design, 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 to less than eight years
• Eight to less than nine years
• Nine or more years

08

How many years of full-time equivalent experience do you have designing, implementing, and supporting complex database environments?

• 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

09

How many years of experience do you have designing and maintaining ETL pipelines using tools such as Apache Airflow, Azure Data Factory or FME Form?

• 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

10

How many years of full-time professional experience do you have managing cloud data warehouse platforms (e.g., Azure, Google BigQuery, Snowflake)?

• 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

11

How many years of experience do you have designing, implementing, and optimizing data sets to support data-informed decision making?

• 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

12

How many years of full-time experience do have creating data governance policies and writing technical data documentation?

• 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

13

How many years of full-time equivalent experience do you have with data compliance frameworks such as GDPR and HIPAA?

• 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

14

How many years of full-time equivalent experience do you have implementing data validation rules and anomaly detection to ensure data quality in production pipelines?

• 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

15

How many years of full-time equivalent experience do you have in public sector or large-scale data environments?

• 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

Employer Fairfax County

Address 12000 Government Center Pkwy. Suite 270

Fairfax, Virginia, 22035

Phone 703-324-3311

Website http://agency.governmentjobs.com/fairfaxcounty/default.cfm