Data Architect (Data Modeling & Optimization) at Applaudo Studios

Guatemala City, Guatemala Department, Guatemala -

Full Time

Start Date

Immediate

Expiry Date

07 May, 26

Salary

0.0

Posted On

06 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Architecture, Performance Optimization, Data Modeling, AWS RDS, Aurora, SQL Optimization, Query Optimization, Execution Plan Analysis, Indexing Strategies, High Availability, Scalability, GitHub, Analytical Skills, Problem-Solving, Communication Skills, Data Quality

Industry

IT Services and IT Consulting

Description

Job Description About You You are a Data Architect with a strong focus on designing, optimizing, and scaling high-performance data solutions. You enjoy working close to the database layer and understanding how architectural decisions directly impact performance, scalability, and reliability. You are comfortable owning data architecture decisions end to end and thrive in environments where deep technical expertise, autonomy, and collaboration with engineering teams are essential. You Bring to Applaudo the Following Competencies: 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. You Will Be Accountable for the Following 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. Additional Information Here at Applaudo values as trust, communication, respect, excellence and team work are our keys to success. We know we are working with the best and thus treat each other with respect and admiration without asking. Submit your application today, and don't miss this opportunity to join the Best Digital team in the Region! We truly appreciate all the hard and outstanding work our team makes every day at Applaudo Studios, and that's why the perks that we offer, are deeply thought and designed as a way to thank them for their commitment and excellence. Some of our perks and benefits: Celebrations Special discounts* Entertainment area* Modern Work Spaces* Great work environment Private medical insurance* *Benefits may vary according to your location and/or availability. Request further information when applying.

Responsibilities

The role is accountable for designing, evolving, and maintaining high-performance, scalable, and reliable data architectures primarily on AWS RDS and Aurora. Responsibilities include analyzing and optimizing database workloads through SQL tuning, identifying infrastructure bottlenecks, and defining data modeling standards across teams.