Senior Cloud Data Warehouse Architect – Top Secret

Xpect Solutions; Washington (District of Columbia); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401(k) Retirement Plan

Life Insurance

AD&D Insurance

Disability Insurance

Paid Time Off

Holidays

Performance Awards

Referral Bonus up to $5k

Education Reimbursement

Job summary

XPECT Solutions, LLC seeks a senior database engineer to support health, performance, security, and scalability of data warehouse ecosystems (AWS Redshift, PostgreSQL/Aurora). You will lead data architecture modernization, optimize analytic queries for BI engines, and enforce security posture.

Responsibilities include provisioning cloud data stores, tuning performance, migrating data assets, and automating schema deployments using IaC tools like Terraform/CloudFormation.

Qualifications

• 8+ years of progressive database development/administration experience.
• Strong expertise with cloud DB platforms (AWS preferred) for high-volume warehouses/BI.
• Advanced SQL, query plan analysis, tuning, and schema optimization.

Responsibilities

• Lead engineering, provisioning, and lifecycle management of cloud-native analytical data stores (Redshift, Aurora PostgreSQL, RDS).
• Tune performance, optimize DB parameters, design indexing/partitioning/distribution strategies, and refactor stored procedures for BI tools like WebFOCUS.

Skills

SQL

Cloud databases

Data warehousing

Performance tuning

Tools

Airflow

AWS DMS

Terraform

CloudFormation

Job description

XPECT Solutions, LLC seeks a senior database engineer to support health, performance, security, and scalability of data warehouse ecosystems (AWS Redshift, PostgreSQL/Aurora). You will lead data architecture modernization, optimize analytic queries for BI engines, and enforce security posture.

Responsibilities include provisioning cloud data stores, tuning performance, migrating data assets, and automating schema deployments using IaC tools like Terraform/CloudFormation.