Senior Data Warehouse Architect

- 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-classo

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

WeareseekinganexperiencedLeadDataWarehouseArchitecttohelpdrivetheevolutionofourenterprisedataandanalyticsplatform.Thisroleisidealforahands-ondataprofessionalwhocombinesstrongdataarchitectureexpertisew

Youwillplayakeyroleindesigningscalabledatasolutions,modernizinglegacyplatforms,andenablingdata-drivendecision-makingacrosstheorganization.Workingcloselywithbusinessandtechnicalstakeholders,youwillhelp

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

#J-18808-Ljbffr