Senior Data Warehouse Architect

Confie; Tijuana; Hybrid; MXN 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Christmas bonus

Savings fund

Profit sharing (PTU)

Extra paid days off

Private medical insurance and preventi

Job summary

Confie is seeking an experienced Lead Data Warehouse Architect to drive the evolution of our enterprise data and analytics platform. This role combines data architecture expertise with modern cloud technologies, data engineering, and business enablement.

You will design scalable data solutions, modernize legacy platforms, and enable data-driven decision making across the organization. Collaboration with business and technical stakeholders is essential in this fast-paced, hybrid environment.

Qualifications

• 5+ years of experience in data warehousing and analytics platforms.
• Experience designing enterprise-scale data warehouses.
• Experience with Snowflake, Redshift, BigQuery, or Databricks.
• Experience with data migration and platform modernization initiatives.
• Strong data modeling knowledge (Dimensional Modeling, Data Vault).
• Insurance industry experience preferred.

Responsibilities

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

Skills

ETL/ELT pipelines

Data modeling

Snowflake

Cloud data platforms

Enterprise data architecture

Mentorship

Stakeholder collaboration

Architecture decisions

Tools

Snowflake

Redshift

BigQuery

Databricks

Job description

• Department Name BUSINESS INTEL. & ANALYTICS
• Job Type Full time
• Service Now Ticket INC1472074
• Modality Hybrid
• Work Experience 5+ years
• Date Opened 09/14/2026
• Country Mexico

Job Description

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

Aboutourcompany

ConfieisthelargestindependentpersonallinesinsuranceagencyandbrokerintheUnitedStates—servingcustomersnationwide.In2010,weestablishedourSharedServicesCenterinTijuana,BajaCalifornia,creatingaworld-classoperationbuilttoefficientlysupportourcustomers,driveinnovation,anddevelopexceptionaltalent.Sincethen,ourMexicooperationhasbecomeavitalextensionofourorganization,strengtheningtheworkthatpowersourU.S.businessandelevatingtheexperienceofcustomersacrossall50states.Today,morethan1,800teammembers—bothon-siteandremote—helpfueloursuccesswithafocusonquality,consistency,andoperationalexcellence.

Ourgrowthreflectsadeepinvestmentintechnology,continuousimprovement,and—mostimportantly—ourpeople.Wefosteraninclusive,fast-paced,andcollaborativeculturewhereemployeesareencouragedtogrowandbuildlong-termcareerswithacompanyshapingthefutureofinsurance.

WeareseekinganexperiencedLeadDataWarehouseArchitecttohelpdrivetheevolutionofourenterprisedataandanalyticsplatform.Thisroleisidealforahands-ondataprofessionalwhocombinesstrongdataarchitectureexpertisewithapassionformoderncloudtechnologies,dataengineering,andbusinessenablement.

Youwillplayakeyroleindesigningscalabledatasolutions,modernizinglegacyplatforms,andenablingdata-drivendecision-makingacrosstheorganization.Workingcloselywithbusinessandtechnicalstakeholders,youwillhelpshapeourdatastrategywhileestablishingbestpracticesindatamodeling,dataintegration,performanceoptimization,andgovernance.

Thisisanexcellentopportunityforsomeonewhoenjoyssolvingcomplexdatachallenges,mentoringtechnicalteams,andbuildinghigh-impactanalyticalsolutionsusingSnowflakeandmoderndatatechnologies.

Requirements

• 5+yearsofexperienceindatawarehousing,dataengineering,analyticsplatforms,orrelateddisciplines.
  
• Experiencedesigningandimplementingenterprise-scaledatawarehouseoranalyticssolutions.
  
• Experienceworkingwithcloud-baseddataplatformssuchasSnowflake,Redshift,BigQuery,Databricks,orsimilartechnologies.
  
• Experiencesupportingorparticipatingindatamigrationandplatformmodernizationinitiatives.
  
• Strongunderstandingofanalyticaldatamodelingconceptsandimplementationapproaches.
  
• Experienceworkingwithcross-functionalbusinessandtechnicalstakeholders.
  
• Provenabilitytoleadtechnicalinitiativesandinfluencearchitecturaldecisions.
  
• Experiencewithintheinsuranceindustry(preferred).
  

KeyResponsibilities

• Leadthedesign,implementation,andevolutionofenterprisedatawarehouseandanalyticssolutionsusingSnowflakeandmodernclouddatatechnologies.
  
• Defineandmaintainscalabledataarchitecture,datamodelingstandards(DimensionalModeling,DataVault,andrelatedapproaches),andintegrationpatterns.
  
• Architect,optimize,andoverseeETL/ELTpipelinestoensurereliable,efficient,andscalabledataprocessing.
  
• Drivedataplatformmodernization,migrationinitiatives,andcontinuousimprovementofthedataecosystem.
  
• Designsolutionsthatintegratedatafrommultiplebusinesssystems,includingoperational,financial,CRM,andcustomer-relatedplatforms.
  
• Establishbestpracticesforperformancetuning,workloadoptimization,dataquality,governance,andcloudcostmanagement.
  
• Collaboratewithbusinessandtechnicalstakeholderstotranslateanalyticalandreportingrequirementsintoscalabledatasolutions.
  
• Providetechnicalleadership,mentorship,andarchitecturalguidancetodataengineersandanalyticsteams.
  
• Evaluateemergingtechnologiesandrecommendinnovativeapproachesthatimproveanalyticscapabilitiesandbusinessoutcomes.
  
• Ensuredatasolutionssupportenterprisereporting,self-serviceanalytics,andstrategicdecision-makingacrosstheorganization.
  
• Christmasbonus
  
• Savingsfund
  
• Profitsharing(PTU)
  
• Extrapaiddaysoff
  
• Privatemedicalinsuranceandpreventativecare