Descripción del puesto

We are seeking a Database Architect to design, manage, and optimize both our application data architecture and data warehousing environment. This role will define database schemas, ensure data consistency, and maintain performance across transactional and analytical systems.

In our organization, this role plays a key part in ensuring our data layer supports scalable application development and reliable reporting. The Database Architect works closely with Engineering, Product, and leadership to align data design with business workflows, analytics, and system performance.

This role requires strong technical expertise across relational databases and modern data platforms such as Snowflake.

This is a bilingual position; therefore, an advanced level of English proficiency is required.

KEY RESPONSIBILITIES

Data Architecture & Schema Design

• Design and maintain database schemas aligned to business workflows and product requirements
• Define standards for data modeling, naming conventions, and structure across systems
• Ensure consistency between transactional systems and analytics platforms
• Review and approve schema changes to maintain integrity and scalability

Data Warehousing & Analytics Architecture

• Design and manage data models within Snowflake or similar platforms
• Define data pipelines and structures to support reporting and analytics
• Ensure data is structured for efficient querying and business intelligence use
• Partner with stakeholders to support reporting, dashboards, and data access needs

Database Performance & Optimization

• Monitor and optimize performance across both application databases and data warehouse environments
• Improve query performance, indexing strategies, and data access patterns
• Identify and resolve bottlenecks across transactional and analytical workloads
• Ensure systems operate efficiently under expected load and growth

Data Integrity & Governance

• Ensure accuracy, consistency, and reliability of data across systems
• Define rules for data validation, relationships, and constraints
• Implement governance practices for data quality, lineage, and usage
• Establish standards for managing schema changes and data access

Scalability & Reliability

• Design systems to support growth in data volume and system usage
• Define strategies for partitioning, replication, and scaling
• Ensure high availability and disaster recovery planning
• Support backup, restore, and failover processes

Cross-Functional Collaboration

• Partner with Engineering to align database design with application architecture
• Work with Product and Business Analysts to translate workflows into data models
• Support analytics and reporting teams with well-structured data models
• Provide guidance on data-related decisions across teams

Standards & Best Practices

• Define and enforce database and data platform standards across the organization
• Guide teams on proper data access, modeling, and performance practices
• Review implementations to ensure alignment with architecture standards
• Continuously improve how data is structured and used across systems

Documentation & Visibility

• Maintain clear documentation of schemas, data models, and data flows
• Ensure data structures are understandable and accessible across teams
• Track changes to database and warehouse structures over time
• Provide visibility into data health, performance, and risks

Requisitos

QUALIFICATIONS

Required

• 5–10 years of experience in database architecture, data engineering, or related roles
• Strong experience with relational databases (SQL Server, PostgreSQL, or similar)
• Experience designing and working with Snowflake or similar data warehouse platforms
• Deep understanding of data modeling for both transactional and analytical systems
• Experience optimizing database and warehouse performance
• Strong problem-solving skills and attention to detail
• Advanced English proficiency (bilingual position)

Preferred

• Experience with data pipelines and ETL/ELT processes
• Experience with cloud platforms such as AWS
• Familiarity with data governance, lineage, and auditing practices
• Experience in compliance-driven or regulated environments

TOOLS & PLATFORMS

• SQL Server, PostgreSQL, or similar relational databases
• Snowflake or similar data warehouse platforms (Redshift, BigQuery)
• AWS RDS, Aurora, or equivalent cloud database services
• Data pipeline or orchestration tools
• Database monitoring and performance tools
• Jira
• Confluence
• Power BI or other BI/reporting platforms
• Collaboration tools such as Zoom and chat platforms
• Familiarity with EOS / Ninety or similar operating frameworks is helpful but not required

Beneficios

• Sueldo base: a Negociar de acuerdo a perfil.

• Prestaciones de ley.

• Vales de despensa.

• Seguro de vida.

• CONTRATO POR TIEMPO DEFINIDO / Proyecto de 6 meses con posibilidad de extensión.

• REMOTO.