Data Engineer (Business Analyst IV)

Data Engineer (Business Analyst IV)

Salary

$93,072.72 - $155,120.58 Annually

Location

FX. CTY. GOVERNMENT CENTER, 12000 GOVERNMENT CENTER PKWY., FAIRFAX (EJ32), VA

Job Type

FT Salary W BN

Job Number

26-00959

Department

Information Technology

Opening Date

06/27/2026

Closing Date

7/3/2026 11:59 PM Eastern

Pay Grade

S31

Posting Type

Open to General Public

• Description
• Benefits
• Questions

Job Announcement

Join our innovation team as a data engineer with the Department of Information Technology! Under the leadership of Chief Director of Innovation, youll drive county-wide data-informed decision making, boost organizational transparency, and enhance operational efficiency by building robust data pipelines, managing advanced database architectures, ensuring top-tier data quality, governance, and security, and partnering closely with analytics/AI teams to deliver scalable, reliable data solutions.

Key Responsibilities

• Designs, builds, and maintains ETL (Extract, Transform, Load) pipelines using orchestration tools (e.g., Apache Airflow, Azure Data Factory) and big data frameworks (e.g., Spark, Hadoop) to transport raw data from multiple sources into centralized repositories like data warehouses and data lakes.
• Manages database and data architecture by designing, implementing, and optimizing storage solutions (e.g., PostgreSQL, SQL Server, MongoDB, Cassandra, AWS S3, Google BigQuery), including schemas, partitioning, indexing, and data modeling to balance performance, scalability, and cost for transactional and analytical workloads.
• Ensures data quality, governance, and security through validation rules, anomaly monitoring, metadata/lineage management, compliance frameworks (e.g., GDPR, HIPAA), encryption, access controls, and auditing in partnership with security teams.
• Collaborates with business analysts, data scientists, and developers to provide optimized datasets, improve query performance, integrate APIs, and support data projects for decision-making and innovation.
• Builds and manages Snowflake data environments, including initial environment setup, warehouse configuration, role-based access controls, data ingestion pipelines, and performance optimization to support scalable, secure, and cost-efficient analytics.
• Manages cross functional teams supporting data initiatives.
• Performs other duties as required to support business intelligence and data efforts.

NOTE: This position may be filled as an underfill at the Business Analyst III or Business Analyst II level. Underfill requirements are noted below in the Employment Standards section.

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

Bachelors degree in computer information systems, business administration, or related field; plus five years of experience in information systems and process redesign, managing and implementing all phases of the systems development life cycle, including at least one year of supervisory experience.

UNDERFILL REQUIREMENTS:

This position may be underfilled at the Business Analyst III (Grade S29; $87,024.91 - $145,041.94 annually) or Business Analyst II (Grade S26; $75,474.26 - $125,790.50 annually) level.

• Business Analyst III Minimum Qualifications are: Any combination of education, experience, and training equivalent to the following: Bachelors degree in business, computer science or a field related to the department where the IT services are being used: plus four years of experience analyzing business processes and/or developing/maintaining the main business system, technical platform or a related system

NOTE: Candidates appointed to these positions at the Business Analyst III grade level will be eligible for a non-competitive promotion to the Business Analyst IV grade level upon successful completion of the underfill agreement. Underfill candidates must be able to meet the minimum qualifications of the Business Analyst IV within 1 year of the job announcements closing date.

• Business Analyst II Minimum Qualifications are: Any combination of education, experience, and training equivalent to the following: Bachelors 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.

NOTE: Candidates appointed to these positions at the Business Analyst II grade level will be eligible for a non-competitive promotion to the Business Analyst III grade level upon successful completion of the underfill agreement. Underfill candidates must be able to meet the minimum qualifications of the Business Analyst III within 2 years of the job announcements closing date.

NECESSARY SPECIAL REQUIREMENTS:

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

PREFERRED QUALIFICATIONS:

• Experience designing/maintaining ETL pipelines utilizing tools such as Apache Airflow or Azure Data factory.
• Strong experience with big data frameworks (e.g., Spark, Hadoop), and cloud storage (e.g., AWS S3, Google BigQuery).
• Experience integrating external data sources via APIs or streaming frameworks into centralized repositories.
• Experience building or optimizing data lakes or data warehouses, including scheme design and partitioning strategies.
• Experience implementing data validation rules and anomaly detection to ensure data quality in production pipelines.
• Experience managing metadata and data lineage to support governance.
• Expertise in relational/NoSQL databases, data modeling, governance, and security best practices.
• Proven collaboration skills with analytics/AI teams, including query optimization and dataset preparation.
• Excellent technical communication, problem-solving, and organizational skills.
• Experience in working in the public sector.
• Experience working in large-scale data environments.

PHYSICAL REQUIREMENTS:

Work is generally sedentary, performed in a normal office environment. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE:

Panel interview and 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.gov EEO/AA/TTY.

#LI-JY1

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 your area(s) of study or major(s)/minor(s) towards a degree. Check all that apply.

• Information systems
• Business administration
• Computer science
• Information technology
• 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

How many years of full-time equivalent professional experience do you have in information systems and process redesign, managing and implementing all phases of the systems development life cycle?

• 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 years or more

06

From your experience in information systems and process redesign, managing and implementing all phases of the systems development life cycle, how many years of full-time equivalent supervisory experience do you have?

• 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 years or more

07

How many years of full-time equivalent professional experience do you have designing/maintaining ETL pipelines utilizing tools such as Apache Airflow or Azure Data factory?

• 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 years or more

08

How many years of full-time equivalent professional experience do you have with big data frameworks (e.g., Spark, Hadoop)?

• 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 years or more

09

How many years of full-time equivalent professional experience do you have with cloud storage (e.g., AWS S3, Google BigQuery)?

• 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 years or more

10

How many years of full-time equivalent professional experience do you have integrating external data sources via APIs or streaming frameworks into centralized repositories?

• 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 years or more

11

How many years of full-time equivalent professional experience do you have building or optimizing data lakes or data warehouses, including scheme design and partitioning strategies?

• 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 years or more

12

How many years of full-time equivalent professional 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 to less than six years
• Six to less than seven years
• Seven to less than eight years
• Eight to less than nine years
• Nine years or more

13

How many years of full-time equivalent professional experience do you have managing metadata and data lineage to support governance?

• 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 years or more

14

How many years of full-time equivalent professional experience do you have working in the public sector?

• 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 years or more

15

How many years of full-time equivalent professional experience working in a large-scale data environment?

• 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 years or more

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