**Descripción del puesto**:
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**
- 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**
- 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.
- Protegido de vida.
- CONTRATO POR TIEMPO DEFINIDO / Proyecto de 6 meses con posibilidad de extensión.
- REMOTO.

📌 Database Architect / Bilingüe (Ciudad Apodaca)
🏢 Northware
📍 Ciudad Apodaca