- Department Name BUSINESS INTEL. & ANALYTICS
- Job Type Full time
- Service Now Ticket RITM0011238
- Modality On Site
- Work Experience 5+ years
- 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.

About our company

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.

The main objectives for a Solution Architect II, position revolve around designing, standardizing,and leading the implementation of scalable data platforms that align with specific business needs.The Solution Architect II level often implies proficiency,



the ability to handle complex projectsindependently, and contributing to enterprise standards.

- Lead the architecture, design, development and maintenance of end-to-end reportingand analytics solutions, from data ingestion to visualization.
- Design, write and optimize complex ETL/ELT procedures and data pipelines across SQLServer, Coalesce, Snowflake and other platforms, ensuring data quality, reliability andrecoverability.
- Define data models (dimensional and relational), integration patterns and data flows fornew solutions; document technical designs and present them to stakeholders forapproval.
- Lead data platform migration and modernization initiatives (e.g., SQL Server toSnowflake, WhereScape to Coalesce), including planning, data validation andreconciliation between source and target systems.
- Optimize performance and cost of complex solutions leveraging SQL execution plans,SQL Profiler, Snowflake Query Profile, indexing strategies and warehouse monitoring.
- Act as SME and technical owner for code and subject areas in the DW; perform codereviews and validate production deployments.
- Define,



document and enforce design and development standards and best practicesfor the analytics and reporting environment (coding standards, error handling, versioncontrol, CI/CD and deployment processes).
- Provide technical leadership, mentoring and guidance to Solution Architect I and otherdevelopers; estimate, distribute and review technical work.
- Partner with business leaders to translate requirements into scalable solutions, estimateeffort and help prioritize the project roadmap.
- Collaborate with IT Security and Information Governance to ensure data security, accesscontrols and regulatory compliance.
- Evaluate new technologies and propose investments to expand the solution footprint(Snowflake, WhereScape, Coalesce and others); outline and enforce best practiceimplementation and incorporate solutions into Confie's overall IT stack.

Requirements

- Data warehouse architecture and dimensionalmodeling; ETL/ELT design patterns; cloud dataplatforms (Coalesce and Snowflake); queryperformance tuning; data governance, data qualityand data security best practices.
- English level: advanced (B2-C1)
- Advanced: SQL (T-SQL, Snowflake SQL), SQL Server,Snowflake, WhereScape, Coalesce,BigQuery, Tableau, Sigma.
- 5 to 8 years of progressive experience in DataEngineering, Software Development, or Infrastructureroles.
- At least 3 to 5 years of direct experience in designingand architecting large-scale data solutions
- Christmas bonus
- Savings fund
- Profit sharing (PTU)
- Extra paid days off
- Private medical insurance and preventative care

📌 Solution Architect II (Tijuana)
🏢 Confie
📍 Tijuana