Cloud Data Architect - AWS & Snowflake at Scale

ETHOS - Talent & Advisory; Maryland; On-site; USD 120,000 - 180,000; Full time

Job summary

ETHOS - Talent & Advisory is seeking a Database Architect in Maryland to design secure, high-performance data platforms on AWS and Snowflake. You will own schema design, data warehouse management, EMR clustering, and robust disaster recovery, while integrating with Lambda, S3, and Glue for cohesive pipelines.

The role emphasizes experienced SQL optimization, IAM and encryption, and mentoring engineers. A hands-on, strategic contributor who can translate complex tech to stakeholders is ideal.

Qualifications

• Bachelor’s degree in Computer Science, Mathematics, Engineering, or equivalent field.
• 7+ years of hands-on experience as a Database Architect.
• Deep AWS expertise: RDS, Aurora, DynamoDB, Redshift, ElastiCache, EMR, Neptune.
• Proven track record troubleshooting complex AWS infrastructure issues.
• Strong SQL skills - query optimization, indexing, caching, and execution plan analysis.
• Experience with Infrastructure as Code - Terraform, CloudFormation, or AWS CLI.
• Scripting proficiency - Python, Bash, or PowerShell.

Responsibilities

• Architect and optimize scalable, secure, high-performance database solutions across AWS's full data ecosystem.
• Design schema, micro-partitioning strategies, and manage virtual data warehouses in Snowflake.
• Configure, optimize, and cost-manage EMR clusters for diverse data sources and integration patterns.
• Build and maintain backup, disaster recovery, and high-availability solutions (Multi-AZ, read replicas, failover automation).
• Integrate databases with AWS services (Lambda, S3, EC2, Glue) to create cohesive data pipelines.
• Write and optimize complex SQL for analysis, transformation, and reporting at scale.
• Lead security architecture - implementing IAM policies, encryption, VPC design, and compliance best practices.
• Mentor junior/mid-level engineers and communicate technical strategy to non-technical stakeholders.

Skills

AWS Expertise

SQL Proficiency

Data Modeling

IAM & Security

Mentorship

Terraform

CloudFormation

Python Scripting

Bash

PowerShell

Education

Bachelor’s Degree

Tools

Terraform

CloudFormation

AWS CLI

Job description

ETHOS - Talent & Advisory is seeking a Database Architect in Maryland to design secure, high-performance data platforms on AWS and Snowflake. You will own schema design, data warehouse management, EMR clustering, and robust disaster recovery, while integrating with Lambda, S3, and Glue for cohesive pipelines.

The role emphasizes experienced SQL optimization, IAM and encryption, and mentoring engineers. A hands-on, strategic contributor who can translate complex tech to stakeholders is ideal.