[Remote] Sr. Data Engineer

Note: The job is a remote job and is open to candidates in USA. Farmers Insurance is a company dedicated to delivering peace of mind and making a real difference in people's lives. They are seeking a Senior Data Engineer responsible for acquiring, curating, and publishing data for analytical or operational uses, ensuring data is ready for consumption by various users. The role involves consulting on data projects, developing data pipelines, and coaching junior associates while working independently with various technologies.ResponsibilitiesConsults on data projects of varying complexity, with minimal coaching and guidance, to understand design requirement and existing business processes to lead in the design, development, and implementation of data productsPractices code management and integration with current architectural and data governance guidelines with minimal oversightProduces advanced data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research exploration independentlyCreates business user access methods to structured and unstructured dataUtilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation of data contentTranslates business data stories into a technical story breakdown structure and work estimate for a schedule or planned agile sprintProjects are advanced with interaction across multiple dependenciesCoaching and assistance required on an as needed basisDevelops and maintains advanced to complex scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexityPreps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with coaching and assistance as requestedApplies extensive knowledge of data governance concepts and applies them across multiple scenariosDelivers on complex projects with some vague timelinesDevelops data project plans and executes independentlyPerforms other duties as assignedSkillsHigh School Diploma or equivalent required5-7 years of related experience requiredPossesses strong technical aptitudeAdvanced experience in SQL, Spark (Scala or Python), Spark SQ or equivalentAdvanced experience in dimensional modeling- – Snowflake database technologyAdvanced Experience building data pipelines to transform data as business logicAdvanced knowledge and understanding with pipeline orchestration– dBT, AWS, SSISAdvanced understanding of cloud computing environmentsAdvanced experience with BI visualizations such as Power BI, Tableau etcStrong verbal communication and listening skillsDemonstrated experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardizationBachelor's degree preferredBenefitsBonus Opportunity (based on Company and Individual Performance)401(k)MedicalDentalVisionHealth Savings and Flexible Spending AccountsLife InsurancePaid Time OffPaid Parental LeaveTuition AssistanceCompany OverviewThe companies comprising the Farmers Insurance Group of Companies® currently make up one of the country's largest insurers of vehicles, homes and small businesses, and provide a wide range of other specialty insurance and financial services products. It was founded in 1928, and is headquartered in Woodland Hills, California, USA, with a workforce of 10001+ employees. Its website is http://www.farmers.com/careers/corporate.Company H1B SponsorshipFarmers Insurance has a track record of offering H1B sponsorships, with 21 in 2026, 105 in 2025, 76 in 2024, 86 in 2023, 129 in 2022, 106 in 2021, 90 in 2020. Please note that this does not guarantee sponsorship for this specific role.