**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**Incentivos**:- 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.

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