Senior Cloud Data Architect (AWS & Snowflake) On-Site MD

The Amatriot Group

Woodlawn (MD)

On-site

USD 134,000 - 175,000

Full time

2 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

The Amatriot Group is seeking an experienced Database Architect to design, implement, and optimize scalable database solutions using AWS services and Snowflake. You will manage SQL development, automation, security, and data availability while collaborating with developers and stakeholders.

Responsibilities include EMR cluster management, data integration, performance tuning, and ensuring disaster recovery and high availability.

Qualifications

Bachelor's degree in Computer Science, Mathematics, Engineering, or a related field.
7+ years of experience as a Database Architect.
Experience with AWS database and data processing services (RDS, Aurora, DynamoDB, Redshift, ElastiCache, EMR, Neptune).
Experience designing Snowflake data warehouses and micro-partitions.
Snowflake schema design, normalization, and data structures.
Snowflake-integrated data pipelines with BI tools (Tableau/Power BI) and Python.
Knowledge of AWS security best practices (IAM, encryption, VPC, security groups).
Ability to architect secure, scalable, high-performance databases and perform optimizations.

Responsibilities

Architect scalable, high-performance, secure database solutions on AWS and Snowflake.
Configure, manage, and optimize EMR clusters and integrate with data sources.
Ensure backup, DR, HA, failover and compliance per SSA guidelines.
Write complex SQL queries for analysis, transformation, and reporting.
Provide guidance to junior- and mid-level developers and communicate with stakeholders.