The Senior Data Warehouse Architect will lead thedesign, development, and optimization of enterprise data warehouse solutionsthat support critical business intelligence and analytics needs.
This rolerequires deep technical expertise in modern cloud data platforms and theability to architect scalable, performant data solutions that serve diverseanalytical requirements across the organization.
The adecuado candidate willcombine technical excellence with strong collaboration skills and a commitmentto delivering high -quality, reliable data solutions.Job ResponsibilitiesDataWarehouse Architecture: Design and implement dimensional models, data vaultstructures, and other architectural patterns optimized for analyticalworkloads.
Define data integration patterns, data flow architectures, andtransformation strategies that balance performance, maintainability, andflexibility.
Lead the architectural evolution of the enterprise data warehouseon Snowflake.ETL/ELTDevelopment and Optimization: Architect and optimize ETL/ELT pipelines usingmodern tools like Coalesce and Wherescape.
Design efficient data transformationlogic including complex recursive CTEs, hierarchical data structures, andperformance -critical queries.
Establish patterns for handling slowly changingdimensions, data historization, and temporal data.Performance Optimization: Analyze and optimizequery performance, implement appropriate clustering strategies, and designefficient data structures.
Monitor warehouse performance metrics and implementsolutions for query optimization, resource management, and cost efficiency.Establish best practices for performance tuning across the analytics stackDataIntegration: Lead integration efforts across source systems including policymanagement systems (Atlas, AMS360), CRM platforms, quoting applications, callcenter systems, and financial systems.
Design robust data pipelines that handlevarious data formats, frequencies, and quality challenges.
Architect solutionsfor real -time and batch data integration needs.PlatformMigration Leadership:



Lead technical aspects of platform migrations andmodernization initiatives.
Develop migration strategies that minimize businessdisruption while improving capabilities.
Conduct proof -of -value assessments fornew technologies and platforms.TechnicalLeadership: Provide technical mentorship to data engineers and analysts.Establish architectural standards, design patterns, and best practices for theBI&A; team.
Conduct design reviews and provide technical guidance on complexdata challenges.
Collaborate with stakeholders across Retail Operations andSupporting Operations Departments to understand analytical requirements andtranslate them into technical solutionsRequirementsExperience:8+ years of experience in data warehousing with at least 3 years in architectural roles.Background in data migration projects and platform modernization initiativesFamiliarity with additional data integration tools and technologiesScholarship:University/CollegeMaster's DegreeSpecialized knowledge:Proven track record of designing and implementing enterprise -scale data warehouse solutionsExperience in insurance industry with knowledge of policy systems, commission structures, and industry -specific data challengesComputer knowledge:Expert -level SQL skills including advanced optimization techniques, recursive CTEs, window functions, and performance tuningDeep experience with Snowflake or similar cloud data platforms (Redshift, BigQuery, Databricks)Experience with BI and analytics tools (Tableau, Sigma, Power BI, or similar)Strong understanding of data governance, data quality, and metadata managementExperience with Python or other programming languages for data engineeringKnowledge of DataOps practices, CI/CD for data pipelines, and infrastructure as codeUnderstanding of FinOps principles for cloud data warehouse cost optimizationExperience with customer data platforms, CRM systems, and marketing analyticsEnglish level:Advanced (C1)BenefitsPrivate Health Insurance.Life Insurance.Saving Funds and Voluntary Savings Account.Profit Sharing (PTU).
Vacation Days (above law).
Christmas bonus.Vacation premium.

📌 Sr Data Warehouse Architect (Culiacán Rosales)
🏢 Confie TA Admin
📍 Culiacán Rosales