Loading...
Data Architect (Data Modeling & Optimization) at ApplaudoStudios
ApplaudoStudiosGuatemala City, Guatemala Department, gt·2d ago
SeniorFull-timeAWSGit
Salary Range
$59,670 - $80,730 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
We are looking for a Data Architect to join our team at Applaudo. This role focuses on designing, optimizing, and scaling high-performance data solutions on AWS.
Key Responsibilities
- →Design, evolve, and maintain data architectures that prioritize performance, scalability, and reliability on AWS RDS and Aurora
- →Analyze and optimize database workloads through SQL performance tuning, query refactoring, and advanced indexing strategies
- →Identify architectural and infrastructure-level bottlenecks related to CPU, memory, storage, and I/O, proposing scalable solutions
- →Define and enforce data modeling and architectural standards for high-performance transactional and analytical workloads
- →Collaborate closely with software engineers and technical teams to ensure strong alignment between application and data layers
- →Establish and promote best practices for database performance monitoring, optimization, and reliability across environments
- →Review and optimize stored procedures and complex SQL logic from an architectural and performance perspective
- →Document data architecture decisions, performance guidelines, and optimization strategies
- →Act as a technical reference and advisor for data architecture and performance topics across teams
- →Support technical discussions with stakeholders by providing clear recommendations and trade-off analyses
Requirements
- ✓Bachelor’s Degree in Computer Science, Software Engineering, Data Engineering, or a related field (preferred), or equivalent professional experience
- ✓5+ years of experience in data architecture, database architecture, or similar roles with a strong focus on performance optimization
- ✓Hands-on experience designing and operating data solutions on AWS, with strong preference for RDS and Aurora
- ✓Advanced expertise in SQL, including complex query optimization, execution plan analysis, indexing strategies, and stored procedure development
- ✓Deep understanding of how CPU, memory, storage, and I/O constraints impact database and data architecture performance
- ✓Experience defining and applying architectural best practices for high availability, scalability, and performance
- ✓Strong proficiency using GitHub for version control, collaboration, and documentation
- ✓Ability to work independently, take ownership of architectural decisions, and drive improvements end to end
- ✓Strong analytical, problem-solving, and communication skills
- ✓High attention to detail and a strong commitment to data quality and system performance
- ✓Advanced English proficiency, as you will collaborate with distributed and US-based teams
