Data Analyst III

Fairfax County Government is hiring a senior data professional to lead data warehouse and business intelligence development and administration under limited supervision.

Responsibilities

• Manage database and data architecture by designing, implementing, and optimizing storage, including schemas, partitioning, indexing, and data modeling for transactional and analytical workloads
• Define requirements and design, develop, test, debug, and maintain the agency’s data warehouse and associated system interfaces to data sources
• Design, build, and maintain ETL pipelines using orchestration tools (Apache Airflow, Azure Data Factory, FME Form) and big data frameworks (Spark, Hadoop) to move data into a centralized warehouse
• Collaborate with business analysts, data analysts, GIS analysts, and subject matter experts to deliver optimized datasets that support agency decision-making
• Create and maintain data governance policies and best practices in line with Department of Information Technology (DIT) expectations
• Write policy and best practice documentation covering data design, data quality, data transformation, data retention, data sharing, and data security aligned to enterprise standards set by DIT
• Ensure data quality and compliance with governance and security policies using validation rules, monitoring, and database design
• Support compliance with regulatory frameworks including GDPR and HIPAA
• Serve in mentorship and provide work counseling, guidance, and training for lower-level data analysis work as needed
• Develop data standards, analytic schemas, and complex data models to support complete, correct, accessible, and shareable data for technology development projects
• Gather and document business data and information requirements, including logical business modeling and physical design tasks (consolidation, standardization, cleansing, migration, or upload)
• Analyze forms, reports, processes, practices, and procedures; design reporting schemas and data models of moderate to advanced scope
• Identify and document subject areas, entities, attributes, relationships, information types, domains, and constraints
• Create structured diagrams such as data flow and entity life cycle diagrams, conceptual schemas, and association matrix diagrams
• Assess disparate databases for streamlining, standardization, and consolidation opportunities; support modernization and optimization through schema design
• Maintain metadata, schemas, data repositories, and data dictionaries
• Design and run database queries to assess and validate data; support data cleansing, transformations, and data testing for complex initiatives
• Perform other duties as required to support business intelligence and data efforts

Requirements

• Graduation from an accredited four-year college or university with a degree in Information Technology, Information Systems, Computer Science, Business Administration, or related field, with coursework in analytics and related areas (including statistics and demographics)
• Plus five years of analysis of data and information experience in an academic, data administration, or business data analytics environment involving data modeling, database consolidation, ad hoc query, or business intelligence tools
• Experience with relational databases, metadata, and related design work such as XML schema design and/or taxonomy
• 3–5+ years working in data warehousing or database development and maintenance
• Strong experience with ETL tools and building/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, including query optimization and dataset preparation
• Excellent technical communication, problem-solving, and organizational skills
• Experience in public sector or large-scale data environments
• Driver’s License (Required)
• Criminal background check and driving record check to the satisfaction of the employer

Technologies

• Apache Airflow
• Azure Data Factory
• FME Form
• Spark
• Hadoop
• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• AWS Redshift
• Azure Synapse
• Google BigQuery
• ETL (Extract, Transform, Load)
• XML schema design
• metadata
• data modeling
• data governance frameworks

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