> Markdown version of [/jobs/ext/2965117-sr-analytics-engineer-cx](https://www.wearedevelopers.com/jobs/ext/2965117-sr-analytics-engineer-cx). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr. Analytics Engineer- CX

- **Company:** Farmers Insurance
- **Location:** Cleveland, United States (Remote available)
- **Experience:** Expert
- **Salary:** $115,275.0 - $196,130.0
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Airflow, Amazon Web Services, Data Analysis, Business Logic, Microsoft Azure, BigQuery, Cloud Computing, Databases, Data Auditing, Data Validation, Data Cleansing, Information Engineering, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Data Transformation, Data Structures, Data Visualization, Dimensional Modeling, Python (Programming Language), Machine Learning, Raw Data, Power BI, SQL Databases, Tableau (Software), Google Cloud, Data Storage Technologies, Cloud Platform System, Data Ingestion, Snowflake, Data Build Tool (dbt), Information Technology, Data Lineage, Data Management, Data Pipelines, Service Stack
- **Published:** September 17, 2026
- **Apply:** https://jobs.farmersinsurance.com/talentcommunity/apply/1372365057/?locale=en_US

## About the Role

* High School Diploma or equivalent required.
 * Bachelor's degree Bachelor's or Master's degree preferred in computer science, data science, engineering, or a related field.
 * Certification in analytics or data engineering preferred.
 * 5-7 years of related work experience required.
 * Experience with cloud-based data platforms (AWS, Azure, GCP).
 * Proficiency with SQL or similar, dimensional modeling, pipeline orchestration, building data pipelines to transform data, and BI visualizations.
 * Knowledge of data visualization tools (example Tableau, Power BI).
 * Acts as translation layer for and conduit to technology for all aspects of the work.
 * Understanding of machine learning concepts and tools.

Physical Actions

Job is performed in-person at a Farmers office or virtually at an approved alternative work location. The physical work environment is indoors and climate-controlled with adequate lighting and ventilation. Normal and customary distractions include background noise produced by office equipment and chatter among people, as well as interruptions. Frequently sits for prolonged periods of time, up to a full shift. Occasionally moves about the workplace including, navigating stairs, ramps, and level or uneven surfaces. Occasionally moves, pushes, pulls, lifts, carries, and/or places objects or materials weighing up to 25 pounds without assistance. Frequently uses shoulders, arms, hands, and fingers to manipulate equipment, tools, and objects necessary to perform job duties. Frequently performs fine motor tasks such as typing, mousing, or writing, up to a full shift. Rarely performs movements such as bending, stooping, crouching, kneeling, twisting, and reaching
overhead or below the knees. Possesses clear vision, with or without correction, to visually read and verify information. Relies on depth perception and peripheral vision to navigate the work environment visually by identifying barriers, changes in terrain and locating objects. Possesses adequate hearing, with or without correction, to communicate with co-workers, respond promptly to auditory signals or alarms, and discern sounds essential for maintaining safety and productivity in the workplace. Jobs in this category require rare, if any, travel.

## Description

This position plays a crucial role in the data ecosystem by iteratively transforming raw data into structured, high-quality datasets that are ready for analysis in partnership with Customer Experience data analysts/decision scientists. The role primarily focuses on moderately complex to complex business problems while receiving limited coaching and guidance from data leadership. It may assist less experienced analytics engineers/data analysts in solving moderately complex business problems. The role combines the technical skills of a data engineer, the analytical mindset of a data analyst, and strong business acumen to ensure data is not only collected and stored efficiently but also made accessible and insightful for end users. In partnership with data/decision scientists, the position is responsible for end-to end data workflow including data ingestion, transformation, modeling, and validation to enable data-driven decision-making across the organization. This position
requires deep understanding of data engineering, business processes, and analytics principles as well as a proactive approach to solving complex data challenges.

Essential Tasks & Leadership Philosophy

 * Professional data infrastructure development with limited coaching while providing some coaching and guidance: Pipeline Design and Development - Architects and builds scalable data pipelines using modern ETL (Extract, Load, Transform) tools and frameworks such as dbt (Data Build Tool), Apache Airflow, or similar. Automates data ingestion processes from various sources including databases, APIs, and third-party services. Data Storage and Management - Designs and implements data warehousing solutions using platforms like Snowflake, Redshift, or BigQuery. Optimizes storage solutions for performance, cost-efficiency, and scalability.
 * Professional data modeling and transformation with limited coaching while providing some coaching and guidance: Data Modeling - Develops and maintains logical and physical data models to support business analytics. Creates and manages dimensional models, star/snowflake schemas, and other data structures. Data Transformation - Transforms raw data into clean, organized, and analytics-ready datasets using SQL, Python, or other relevant languages. Implements data transformation workflows to handle data cleansing, normalization, and enrichment. Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data. Implements data quality monitoring and alerting mechanisms. Professional collaboration and stakeholder management with limited coaching while providing some coaching and guidance: Cross-Functional Collaboration - Works closely with data analysts, data scientists, and business stakeholders to gather requirements and
understand their data needs. Acts as a liaison between technical teams and business units to translate business requirements into technical specifications. Technical Communication - Clearly communicates complex technical concepts and data insights to non-technical stakeholders. Provides training and support to team members on data tools, best practices, and methodologies.

 * Professional data governance and security knowledge with limited coaching while providing some coaching and guidance: Governance Policies - Implements and enforces data governance policies to ensure data privacy, security, and compliance with relevant regulations. Defines and manages data access controls, permissions, and audit trails. Security Measures - Monitors and enforces data security measures to protect sensitive information from unauthorized access and breaches. Ensures compliance with industry standards and regulations such as GDPR, CCPA, or HIPAA, as applicable.
 * Professional tool and technology utilization with limited coaching while providing some coaching and guidance: Technology Stack - Utilizes modern data tools and technologies such as SQL, Python, dbt, Airflow, and cloud platforms like AWS, Azure, or GCP. Evaluates and integrates new tools and technologies to improve data infrastructure and processes. Continuous Learning - Stays updated with the latest trends, best practices, and advancements in data engineering and analytics. Participates in professional development opportunities to enhance technical and analytical skills. Provides code as requirements for hardening and operationalization by technology with little to no coaching.
 * The ability to query data quickly and provide for important and time sensitive ad hoc requests when needed.
 * Performs other duties as assigned.

First Year Success Factors

 * Build Trusted Data Pipelines: Design and maintain scalable ETL/ELT pipelines. Improve pipeline reliability, monitoring, and automation. Reduce manual data preparation through repeatable workflows.
 * Deliver Analytics-Ready Data Models: Create and maintain logical and physical data models. Build dimensional models and star/snowflake schemas that support reporting and advanced analytics. Standardize data definitions and business logic.
 * Improve Data Quality and Governance: Implement validation, monitoring, and alerting processes. Establish strong documentation and data lineage practices. Ensure compliance with governance, privacy, and security requirements.
 * Partner Effectively with Stakeholders: Translate business requirements into technical solutions. Build strong relationships with analysts, data scientists, business leaders, and technology teams. Act as a trusted advisor regarding data capabilities and limitations.
 * Influence Through Technical Leadership: Provide mentoring and guidance to less experienced analytics engineers. Promote coding standards, testing, documentation, and best practices. Contribute to architectural decisions and technology improvements.
 * Drive Continuous Improvement: Identify opportunities to optimize cost, performance, and scalability. Introduce new tools, frameworks, or methodologies when appropriate. Champion automation and operational excellence.
 * Develop a Customer Experience Journey Measurement Ecosystem for all CX metrics and KPIs.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies)
- [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)