Data Warehouse Architect

Swift Strategic Solutions Inc; Richmond (VA); On-site; USD 100,000 - 140,000; Full time

Job summary

A Public Sector client is seeking a Data Warehouse Architect for an ongoing project in Richmond, VA. The ideal candidate will have extensive experience in architecting and administering cloud-native database systems, particularly on Azure, and will be responsible for designing solutions, ensuring data governance, and implementing best practices in a collaborative environment.

Qualifications

• 5+ years of hands-on experience in architecting and administering database systems.
• Experience with cloud-native database services on Azure.
• Familiarity with DevSecOps practices and CI/CD pipelines.

Responsibilities

• Architect and administer enterprise-grade database systems.
• Design and implement solutions using Azure SQL and Cosmos DB.
• Participate in design reviews and data governance audits.

Skills

Azure SQL Database

T-SQL scripting

Infrastructure as Code

Cloud-native design patterns

Data governance

Agile/Scrum

DevSecOps practices

Communication skills

Education

Bachelor’s degree in Computer Science

Tools

Azure Data Factory

Terraform

Azure Monitor

Job description

Be among the first 25 applicants and get AI-powered advice on this job along with exclusive features.

A Public Sector client is seeking a Data Warehouse Architect for an ongoing project in Richmond, VA.

Role Details:

Required Skills:

Minimum 5+ years of hands-on experience in:

• Architecting and administering enterprise-grade database systems, with at least 2 years in cloud-native database services on Azure
• Designing and implementing solutions using Azure SQL Database, Azure SQL Managed Instance, and Azure Cosmos DB
• Understanding cloud-native design patterns such as statelessness, elasticity, and infrastructure-as-code (IaC)
• Experience with Infrastructure as Code tools like ARM templates, Bicep, or Terraform
• Familiarity with Azure Data Factory, Azure Synapse, and Azure Monitor
• Knowledge of data classification, masking, encryption, and RBAC in Azure
• Experience supporting public-facing datasets with audit trail design
• Implementing disaster recovery, high availability, and geo-replication strategies in Azure
• Developing logical and physical data models ensuring performance and data provenance
• Proficiency in T-SQL scripting and automation
• Ability to evaluate data storage trade-offs in cloud environments
• Participation in design reviews, security assessments, and data governance audits
• Familiarity with DevSecOps practices and CI/CD pipelines for databases
• Strong communication skills and experience with technical documentation
• Experience working in Agile/Scrum and DevOps workflows
• Bachelor’s degree in Computer Science, Information Systems, or related field is a plus

This role is open to W2, 1099, or C2C arrangements and is available for candidates with valid US work authorization, including H1B transfer candidates.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• Staffing and Recruiting, Technology, Information and Media

Referrals can double your chances of interviewing at Swift Strategic Solutions Inc.

Get notified about new Data Warehouse Architect jobs in Richmond, VA.