FBS (Mexico) - Analytics Engineer (USFITFV)
Farmers Insurance3 days ago
Remote, MexicoMid Level
Responsibilities
- Lead the design, development, deployment, and maintenance of scalable data pipelines and data integration solutions.
- Build and maintain ETL/ELT pipelines, reusable transformation frameworks, libraries, and business logic using data from diverse sources.
- Develop semantic data layers, analytical data models, star schemas, conformed dimensions, historical tracking, and KPI frameworks.
- Establish data engineering best practices covering coding standards, governance, performance optimization, automation, testing, documentation, and observability.
- Implement CI/CD workflows for deploying, testing, and maintaining analytics engineering processes.
- Optimize advanced SQL queries and large-scale data processing, including Snowflake performance tuning, data sharing, tasks, and streams.
- Participate in code reviews and continuously improve engineering practices and methodologies.
- Collaborate with data scientists, engineers, analysts, product managers, and business stakeholders to define and deliver data products.
- Communicate complex technical concepts to non-technical stakeholders and align teams around data initiatives.
Requirements
- At least 3 years of experience as an Analytics Engineer or equivalent.
- Hands-on experience with SQL, SQL Server, Python, Snowflake, and dbt.
- Experience with Git and workflow management tools such as Airflow.
- Proven ability to design and build scalable data pipelines and enterprise-scale data solutions.
- Expertise in ETL/ELT processes, data modeling, data integration, and data warehouse development.
- Experience with CI/CD workflows and tools for data engineering.
- Knowledge of data quality, lineage, metadata management, testing, observability, and model lifecycle management.
- Strong problem-solving and analytical skills with the ability to work collaboratively.
- Valid local legal authorization to work in the country where the role is based.
Benefits
- Competitive salary opportunities and performance-based bonuses.
- Comprehensive benefits that may vary by country and employee level.
- Ongoing training and development resources.
- The role is based in Mexico and requires local work authorization; FBS does not sponsor or obtain work authorization unless explicitly stated.
- Employment is exclusive and does not permit parallel employment or paid professional activities for other entities.
About Farmers Insurance
Farmers Insurance sells auto, home, renters, life, and small-business coverage to U.S. consumers and businesses, primarily through a network of exclusive and independent agents. Revenue comes from insurance premiums and related financial services across the Farmers Exchanges. Founded in 1928 and headquartered in Woodland Hills, California, it serves customers in all 50 states and ranks among the country’s largest personal lines insurers.