Senior Data Warehouse Engineer & BI Lead

Fairfax County Government; Fairfax (VA); On-site; USD 100,000 - 140,000; Full time

Job summary

Fairfax County Government is seeking an experienced Data Warehouse Administrator to lead the development and maintenance of the agency's data warehouse and BI solutions. Under supervision, you will ensure data integrity, security, and availability while supporting data sharing with remote systems and transactional platforms.

The role requires strong ETL, data modeling, and governance expertise, with experience in SQL Server/Oracle/PostgreSQL and cloud data warehousing technologies.

Qualifications

• Graduation from an accredited four-year college or university with a degree in Information Technology, Information Systems, Computer Science, Business Administration, or related field.
• 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.
• 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 (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.

Responsibilities

• Manages database and data architecture by designing, implementing, and optimizing storage solutions for transactional and analytical workloads.
• Defines requirements, designs, develops, tests, debugs, and maintains the agency's data warehouse and interfaces to data sources.
• Designs, builds, and maintains ETL pipelines using orchestration tools (Airflow, Azure Data Factory, FME) and big data frameworks (Spark, Hadoop).
• Collaborates with analysts and SMEs to design optimized datasets meeting business needs and enable data-informed decisions.
• Creates and maintains data governance policies and documentation per agency standards, ensuring data quality and security.
• Ensures data quality and adherence to governance and security policies; ensures regulatory compliance (GDPR, HIPAA).
• Performs other duties to support BI and data efforts.

Skills

Data warehousing

ETL tooling

SQL

Data governance

Cloud data warehousing

Data modeling

Analytics collaboration

Problem solving

Technical communication

Education

Four-year degree in IT/CS

Tools

Apache Airflow

Azure Data Factory

FME Form

Spark

Hadoop

Snowflake

AWS Redshift

Azure Synapse

Google BigQuery

SQL Server

Oracle

PostgreSQL

Job description

Fairfax County Government is seeking an experienced Data Warehouse Administrator to lead the development and maintenance of the agency's data warehouse and BI solutions. Under supervision, you will ensure data integrity, security, and availability while supporting data sharing with remote systems and transactional platforms.

The role requires strong ETL, data modeling, and governance expertise, with experience in SQL Server/Oracle/PostgreSQL and cloud data warehousing technologies.