Data Engineer
Analytics
Apache Airflow
Automation
AWS
Azure Data Factory
Big Data
Bigdata
Bigquery
Cassandra
Cloud
Cloud Platform
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Governance
Data Integration
Data Lake
Data Management
Data Pipeline
Data Platform
Data Processing
Data Security
Data Warehouse
Data Warehousing
Database
ETL
Hadoop
Microsoft Azure
MongoDB
MS SQL
Nosql Databases
PostgreSQL
Snowflake
Spark
SQL
Job Description
Fairfax County's Department of Information Technology is seeking a Data Engineer to design, build, and maintain data pipelines and database architectures while upholding data quality and governance. Based onsite in Fairfax, VA, this role collaborates with analytics and AI teams to deliver scalable, secure data solutions, drawing on at least five years of information systems experience and a bachelor’s degree in computer information systems, business administration, or a related field. The position offers a salary range of USD 87,024 to 155,120 per year.
Responsibilities
- Designs, builds, and maintains ETL pipelines using orchestration tools such as Apache Airflow or Azure Data Factory and big data frameworks like Spark and Hadoop to transport 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.
Requirements
- Bachelor's 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.
- The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.
Technologies
- Apache Airflow, Azure Data Factory, Spark, Hadoop
- PostgreSQL, SQL Server, MongoDB, Cassandra
- AWS S3, Google BigQuery
- Snowflake
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 schema 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.
Similar Jobs
