Senior Cloud Data Architect — Federal BI/DWH (Top Secret)

SMX; Washington; On-site; USD 96,000 - 161,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX in Washington, DC seeks a Senior Cloud Database Developer to lead architecture and modernization of the enterprise data platform, focusing on AWS Redshift, PostgreSQL/Aurora, and high-availability.

You will optimize BI query performance, collaborate with Data Engineers and Analysts, and implement DevSecOps automation using Python, Terraform, and Airflow; an active Top Secret clearance is required.

This on-site role offers competitive compensation and benefits.

Qualifications

• 8+ years of progressive experience in database development and administration, with at least 4+ years on cloud database platforms (AWS preferred).
• Advanced expertise in Redshift and PostgreSQL/Aurora administration.
• ETL & orchestration experience with Apache Airflow or similar platforms.
• SQL mastery with deep query tuning and schema optimization.
• Scripting skills in Python or Bash for automation.
• Backup, security, and HA/DR knowledge for cloud databases.
• Active Top Secret clearance.

Responsibilities

• Lead architecture, provisioning, performance tuning, and lifecycle management of cloud-native analytical data stores.
• Monitor performance, optimize parameters, indexing/partitioning, and refactor SQL for BI tools like WebFOCUS.
• Oversee migration, replication, and synchronization of data using AWS DMS and Airflow.
• Write automation scripts and IaC for deployments, health checks, and maintenance tasks.
• Collaborate with Data Engineers, Analysts, and Architects to review schemas and data modeling.

Skills

Redshift

PostgreSQL

Aurora

SQL

Python

Bash

Airflow

Terraform

CloudFormation

Security

HA/DR

Query tuning

Tools

Airflow

AWS DMS

WebFOCUS

Job description

SMX in Washington, DC seeks a Senior Cloud Database Developer to lead architecture and modernization of the enterprise data platform, focusing on AWS Redshift, PostgreSQL/Aurora, and high-availability.

You will optimize BI query performance, collaborate with Data Engineers and Analysts, and implement DevSecOps automation using Python, Terraform, and Airflow; an active Top Secret clearance is required.

This on-site role offers competitive compensation and benefits.