The Senior Data Warehouse Architect will lead the
design, development, and optimization of enterprise data warehouse solutions
that support critical business intelligence and analytics needs. This role
requires deep technical expertise in modern cloud data platforms and the
ability to architect scalable, performant data solutions that serve diverse
analytical requirements across the organization. The adecuado candidate will
combine technical excellence with strong collaboration skills and a commitment
to delivering high-quality, reliable data solutions.

Job Responsibilities
- Data
Warehouse Architecture: Design and implement dimensional models, data vault
structures, and other architectural patterns optimized for analytical
workloads. Define data integration patterns, data flow architectures, and
transformation strategies that balance performance, maintainability, and
flexibility. Lead the architectural evolution of the enterprise data warehouse
on Snowflake.
- ETL/ELT
Development and Optimization: Architect and optimize ETL/ELT pipelines using




modern tools like Coalesce and Wherescape. Design efficient data transformation
logic including complex recursive CTEs, hierarchical data structures, and
performance-critical queries. Establish patterns for handling slowly changing
dimensions, data historization, and temporal data.
- Performance Optimization: Analyze and optimize
query performance, implement appropriate clustering strategies, and design
efficient data structures. Monitor warehouse performance metrics and implement
solutions for query optimization, resource management, and cost efficiency.
Establish best practices for performance tuning across the analytics stack
- Data
Integration: Lead integration efforts across source systems including policy
management systems (Atlas, AMS360), CRM platforms, quoting applications, call
center systems, and financial systems. Design robust data pipelines that handle
various data formats, frequencies, and quality challenges. Arc

📌 Sr Data Warehouse Architect (Tijuana)
🏢 Confie TA Admin
📍 Tijuana