Overview
Skills
Job Details
Elect - Data Warehouse Architect 3 (764065)
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.
Elect - Data Warehouse Architect 3 (764065) | ||||
Required / Desired Skills | ||||
Skill | Required / Desired | Response (Candidate years of experience) | Amount | of Experience |
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 |