Azure Data Warehouse Architect

Job ID: VA-764065

Remote/Local Azure Data Warehouse Architect (DP-203/12+) with SQL Managed Instance/Cosmos DB, IaC, ARM, Bicep/Terraform, Data Factory/ADF/Synapse, T-SQL, CI/CD, DevSecOps, Agile/Scrum experience

Location: Richmond, VA (ELECT)
Duration: 6 Months
Position: 1(2)

Skills:
Experience architecting and administering enterprise-grade database systems, with at least 2 years focused on cloud-native database services in Azure Required 5 Years
Demonstrated experience designing and implementing solutions using Azure SQL Database, Azure SQL Managed Instance, and Azure Cosmos DB. Required 5 Years
Strong understanding of cloud-native design patterns, including statelessness, elasticity, and infrastructure-as-code (IaC). Required 5 Years
Hands-on experience with Infrastructure as Code tools such as ARM templates, Bicep, or Terraform to provision and manage database infrastructure. Required 5 Years
Familiarity with Azure Data Factory, Azure Synapse, and Azure Monitor for integrating, orchestrating, and monitoring database workflows Required 5 Years
Deep understanding of data classification, masking, encryption, and role-based access control (RBAC) in Azure environments. Required 5 Years
Experience supporting highly scrutinized, public-facing datasets (e.g., elections-related data or open data portals), including audit trail design. Required 5 Years
Proven ability to implement and manage disaster recovery, high availability, and geo-replication strategies within Azure. Required 5 Years
Experience developing logical and physical data models that meet performance and transparency requirements while preserving data provenance. Required 5 Years
Proficiency with T-SQL for scripting, automation, and diagnostics, with a focus on automation of repeatable processes. Required 5 Years
Demonstrated ability to evaluate data storage tradeoffs (e.g., performance vs cost vs governance constraints) in a pay-as-you-go cloud environment. Required 5 Years
Experience participating in design reviews, security assessments, and data governance audits, especially where data is subject to oversight Required 5 Years
Familiarity with DevSecOps practices, including versioned schemas and the integration of database change management into CI/CD pipelines. Required 5 Years
Strong written and verbal communication skills, including experience preparing technical documentation for public consumption or legal review. Required 5 Years
Experience in Agile/Scrum environments and modern DevOps workflows. Required 5 Years
Microsoft Certified: Azure Database Administrator Associate, Azure Solutions Architect Expert, or DP-203 (Azure Data Engineer Associate) Highly desired 5 Years
Bachelor s degree in Computer Science, Information Systems, or related field is a plus. Required 5 Years

Description:
The Virginia Department of Elections is seeking a skilled database architect with a minimum of 5 years experience to work with an existing software development team on an ongoing project.

This position will support the organization s modernization efforts by designing and implementing cloud-native database solutions in Microsoft Azure to meet the demands of highly available, transparent, and auditable public-facing data systems. The candidate will collaborate with engineering, analytics, and governance teams to architect resilient, scalable, and secure data platforms in compliance with regulatory and public accountability requirements. The role requires expertise in Azure data services, modern database lifecycle practices, and a deep appreciation for the challenges associated with high-profile, publicly scrutinized data sets.