A Public Sector client of ours is looking for a Data Warehouse Architect to work on their ongoing project in the Richmond, VA office.

Below are the additional details of this role:

Required Skills:

We need a minimum of 5+ years of hands-on experience in the following.

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

This role can be W2 or 1099/C2C and is open for anyone with valid work authorization in the US. H1B transfer candidates are more than welcome to apply for this role.