FBS (Mexico) - Senior Analytics Engineer
Farmers Insurance3 days ago
Remote, MexicoSenior
Responsibilities
- Lead the design, development, deployment, monitoring, and troubleshooting of scalable data pipelines and data architectures.
- Build and maintain ETL/ELT pipelines, reusable transformation frameworks, libraries, and data products using diverse data sources.
- Develop advanced SQL transformations and optimize queries and large-scale data processing in Snowflake.
- Implement analytics engineering best practices covering coding standards, governance, performance optimization, automation, testing, documentation, and deployment.
- Define semantic data layers, star schemas, conformed dimensions, historical tracking, KPI frameworks, and analytical data models.
- Support data quality, lineage, metadata management, observability, and model lifecycle management.
- Implement CI/CD workflows for deployment, testing, and maintenance of analytics engineering processes.
- Participate in code reviews and collaborate with data scientists, engineers, analysts, product managers, and business stakeholders.
- Translate business requirements into technical specifications and communicate complex technical concepts to non-technical stakeholders.
Requirements
- At least 5 years of experience working as an Analytics Engineer or in an equivalent role.
- Hands-on experience with SQL, SQL Server, Python, dbt, and Snowflake.
- Experience with Git and Airflow.
- Proven experience designing and building scalable data pipelines and architectures.
- Strong understanding of data governance, data quality assurance, and performance optimization in data engineering.
- Expertise in ETL/ELT processes, data modeling, and integrating multiple data sources into a data warehouse.
- Experience with CI/CD workflows and tools for data engineering.
- Strong problem-solving, analytical, and collaborative communication skills.
- Experience delivering data products within Agile product teams and modern cloud environments.
Benefits
- Competitive compensation and benefits package, with offerings that generally include competitive salary opportunities, performance-based bonuses, comprehensive benefits, and ongoing training and development resources.
- Employment is based in Mexico and requires valid local legal authorization to work at the time of hire.
- FBS does not sponsor or obtain work authorization unless explicitly stated.
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.