Solution Architect II

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. Learn more at www.confiemx.com About the role 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 projects independently, and contributing to enterprise standards. Lead the architecture, design, development and maintenance of end-to-end reporting and analytics solutions, from data ingestion to visualization. Design, write and optimize complex ETL/ELT procedures and data pipelines across SQL Server, Coalesce, Snowflake and other platforms, ensuring data quality, reliability and recoverability. Define data models (dimensional and relational), integration patterns and data flows for new solutions; document technical designs and present them to stakeholders for approval. Lead data platform migration and modernization initiatives (e.g., SQL Server to Snowflake, WhereScape to Coalesce), including planning, data validation and reconciliation 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 code reviews and validate production deployments. Define, document and enforce design and development standards and best practices for the analytics and reporting environment (coding standards, error handling, version control, CI/CD and deployment processes). Provide technical leadership, mentoring and guidance to Solution Architect I and other developers; estimate, distribute and review technical work. Partner with business leaders to translate requirements into scalable solutions, estimate effort and help prioritize the project roadmap. Collaborate with IT Security and Information Governance to ensure data security, access controls and regulatory compliance. Evaluate new technologies and propose investments to expand the solution footprint (Snowflake, WhereScape, Coalesce and others); outline and enforce best practice implementation and incorporate solutions into Confie's overall IT stack. Requirements Data warehouse architecture and dimensional modeling; ETL/ELT design patterns; cloud data platforms (Coalesce and Snowflake); query performance tuning; data governance, data quality and 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 Data Engineering, Software Development, or Infrastructure roles. At least 3 to 5 years of direct experience in designing and architecting large-scale data solutions Benefits Legal benefits Christmas bonus Savings fund Profit sharing (PTU) Vacation days Vacation premium Extra paid days off Private medical insurance and preventative care Dental Insurance Life Insurance Friendly work environment