Senior Data Warehouse Architect

To support business and team collaboration needs, only candidates residing in Tijuana or Mexico City will be considered for this role.

Confie is the largest independent personal lines insurance agency and broker in the United States—serving customers nationwide. In 2010, we established our Shared Services Center in Tijuana, Baja California, creating a world-class operation built to efficiently support our customers, drive innovation, and develop exceptional talent. Since then, our Mexico operation has become a vital extension of our organization, strengthening the work that powers our U.S. business and elevating the experience of customers across all 50 states. Today, more than 1,800 team members—both on-site and remote—help fuel our success with a focus on quality, consistency, and operational excellence.

Our growth reflects a deep investment in technology, continuous improvement, and—most importantly—our people. We foster an inclusive, fast-paced, and collaborative culture where employees are encouraged to grow and build long-term careers with a company shaping the future of insurance.

Learn more at

Sr. Data Warehouse Architect

We are seeking an experienced Lead Data Warehouse Architect to help drive the evolution of our enterprise data and analytics platform. This role is ideal for a hands-on data professional who combines strong data architecture expertise with a passion for modern cloud technologies, data engineering, and business enablement.

You will play a key role in designing scalable data solutions, modernizing legacy platforms, and enabling data-driven decision-making across the organization. Working closely with business and technical stakeholders, you will help shape our data strategy while establishing best practices in data modeling, data integration, performance optimization, and governance.

This is an excellent opportunity for someone who enjoys solving complex data challenges, mentoring technical teams, and building high-impact analytical solutions using Snowflake and modern data technologies.

Requirements

• 5+ years of experience in data warehousing, data engineering, analytics platforms, or related disciplines.
  
• Experience designing and implementing enterprise-scale data warehouse or analytics solutions.
  
• Experience working with cloud-based data platforms such as Snowflake, Redshift, BigQuery, Databricks, or similar technologies.
  
• Experience supporting or participating in data migration and platform modernization initiatives.
  
• Strong understanding of analytical data modeling concepts and implementation approaches.
  
• Experience working with cross-functional business and technical stakeholders.
  
• Proven ability to lead technical initiatives and influence architectural decisions.
  
• Experience within the insurance industry (preferred).
  

Key Responsibilities

1. Lead the design, implementation, and evolution of enterprise data warehouse and analytics solutions using Snowflake and modern cloud data technologies.
   
2. Define and maintain scalable data architecture, data modeling standards (Dimensional Modeling, Data Vault, and related approaches), and integration patterns.
   
3. Architect, optimize, and oversee ETL/ELT pipelines to ensure reliable, efficient, and scalable data processing.
   
4. Drive data platform modernization, migration initiatives, and continuous improvement of the data ecosystem.
   
5. Design solutions that integrate data from multiple business systems, including operational, financial, CRM, and customer-related platforms.
   
6. Establish best practices for performance tuning, workload optimization, data quality, governance, and cloud cost management.
   
7. Collaborate with business and technical stakeholders to translate analytical and reporting requirements into scalable data solutions.
   
8. Provide technical leadership, mentorship, and architectural guidance to data engineers and analytics teams.
   
9. Evaluate emerging technologies and recommend innovative approaches that improve analytics capabilities and business outcomes.
   
10. Ensure data solutions support enterprise reporting, self-service analytics, and strategic decision-making across the organization.
    

Benefits

• Competitive weekly salary
  
• Legal benefits
  
• Christmas bonus
  
• Savings fund
  
• Profit sharing (PTU)
  
• Vacation days
  
• Vacation premium
  
• Extra paid days off
  
• Private medical insurance and preventative care
  
• Life Insurance
  
• Growth opportunities