To support business and team collaboration needs, only candidates residing in Tijuana or Mexico City will be considered for this role.
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
- 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
Skills Required
- Advanced English proficiency at B2-C1 level
- Data warehouse architecture and dimensional modeling experience
- ETL/ELT design patterns experience
- Experience with cloud data platforms, including Coalesce and Snowflake
- Query performance tuning experience
- Knowledge of data governance, data quality, and data security best practices
- Advanced SQL, including T-SQL and Snowflake SQL
- Experience with SQL Server, Snowflake, WhereScape, Coalesce, BigQuery, Tableau, and Sigma
- 5 to 8 years of progressive experience in data engineering, software development, or infrastructure roles
- 3 to 5 years of direct experience designing and architecting large-scale data solutions
What We Do
Confie is the largest independent personal lines insurance agency and broker in the United States, operating as a leading call center in Tijuana that provides customer service, back office support, and sales for US insurance companies.
