FBS (Mexico) - Associate Analytics Engineer (USFITFU)
Farmers Insurance3 days ago
Remote, MexicoMid Level
Responsibilities
- Develop and deploy scalable data pipelines for data integration and processing across diverse systems.
- Design, build, and maintain ETL/ELT pipelines, reusable frameworks, and libraries for transforming data from multiple sources.
- Develop SQL queries, optimize performance, perform complex transformations, and support large-scale data processing.
- Design and implement enterprise-scale Snowflake data solutions, including performance tuning, data sharing, tasks, and streams.
- Build transformation frameworks, reusable business logic, testing, documentation, and deployment pipelines with dbt.
- Develop semantic data layers, star schemas, conformed dimensions, historical tracking, KPI frameworks, and analytical data models.
- Implement data quality, lineage, metadata management, testing, observability, and model lifecycle management practices.
- Implement CI/CD pipelines for deployment, testing, and maintenance of analytics engineering processes.
- Participate in code reviews and contribute to improvements in coding practices and methodologies.
- Collaborate with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements and deliver data products.
Requirements
- At least 2 years of experience working as an Analytics Engineer or in an equivalent role.
- Hands-on experience with SQL, SQL Server, and Python.
- Proven experience designing and building scalable data pipelines.
- Expertise in ETL/ELT processes, data modeling, and integrating data from multiple sources into a data warehouse.
- Hands-on experience with Snowflake and dbt.
- Knowledge of orchestration tools such as Airflow.
- Strong problem-solving and analytical skills with the ability to work effectively in a collaborative environment.
- Experience delivering data products within Agile product teams and modern cloud environments.
Benefits
- Competitive salary opportunities and performance-based bonuses.
- Comprehensive benefits package designed to support wellbeing and work-life balance, with offerings varying by country and employee level.
- Ongoing training and development resources.
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.