Sr. Data Engineer

We are Farmers – where ambition meets opportunity. At Farmers, we’re not just known for an unforgettable jingle – we’re a team with a passion for purpose and making a real difference in people’s lives. We deliver peace of mind when it matters most. Our results‑driven, high‑performance culture thrives on creativity, accountability and bold solutions. Here, growth isn’t just a goal – it’s a way of life for both the organization and every individual on our team. We tackle challenges head‑on, learn from every experience and measure our impact on the customers who trust us. Join an award‑winning, equal opportunity employer, where you’ll find more than a job – you’ll find a supportive community. Enjoy competitive benefits, take part in meaningful volunteer projects, and help shape the future alongside talented colleagues across all backgrounds. At Farmers, helping others is at the heart of what we do. Farmers believes in a culture of collaboration, creativity, and innovation, which thrives when we have the ability to work flexibly in a virtual setting as well as the opportunity to be together in person. Our hybrid work environment combines the best of both worlds with at least three (3) days in office and up to two (2) days virtual for employees who live within fifty (50) miles of a Farmers corporate office. Applicants beyond fifty (50) miles may still be considered. Job Summary Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for moderate scenarios. Ensures the data is in a ready‑to‑use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works independently with various technologies from big data, relational and non‑relational databases, cloud environments, different programming languages and various reporting tools. Is beginning to provide coaching to junior associates. Essential Job Functions Consults 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 products. Practices code management and integration with current architectural and data governance guidelines with minimal oversight. Produces 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 independently. Creates business user access methods to structured and unstructured data. Utilizes 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 content. Translates business data stories into a technical story breakdown structure and work estimate for a schedule or planned agile sprint. Projects are advanced with interaction across multiple dependencies. Coaching and assistance required on an as needed basis. Develops 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 complexity. Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with coaching and assistance as requested. Applies extensive knowledge of data governance concepts and applies them across multiple scenarios. Delivers on complex projects with some vague timelines. Develops data project plans and executes independently. Performs other duties as assigned. Education Requirements High School Diploma or equivalent required. Bachelor's degree preferred. Experience Requirements 5-7 years of related experience required. Additional Qualifications Possesses strong technical aptitude. Advanced experience in SQL, Spark (Scala or Python), Spark SQ or equivalent. Advanced experience in dimensional modeling – Snowflake database technology. Advanced experience building data pipelines to transform data as business logic. Advanced knowledge and understanding with pipeline orchestration – dBT, AWS, SSIS. Advanced understanding of cloud computing environments. Advanced experience with BI visualizations such as Power BI, Tableau etc. Strong verbal communication and listening skills. Demonstrated experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization. Physical Actions This role, whether performed virtually or in an office setting, will include normal and customary distractions, noise, and interruptions. Sits or stands for extended periods of time, up to a full work shift. Occasionally reaches overhead and below the knees, including bending, twisting, pulling, and stooping. Occasionally moves, lifts, carries, and places objects and supplies weighing 0-10 pounds without assistance. Listens to, interprets, and differentiates auditory information (example others speaking) at normal speaking levels with or without correction. Visually verifies and reads information. Visually locates material, resources and other objects. Ability to continuously operate a computer for extended periods of time, up to a full work shift. Physical dexterity sufficient to use hands, arms, and shoulders repetitively to operate keyboard and other office equipment up to a full work shift. Farmers offers a competitive salary commensurate with experience, qualifications and location. o CA Only: $115,275 - $196,130 o CO Only: $108,375 - $169,070 o HI/IL/MN/VT Only: $108,375 - $181,060 o MA Only: $108,375 - $181,060 o MD Only: $108,375 - $181,060 o DC/NJ/NY/OH Only: $108,375 - $196,130 o Albany County, NY/Cleveland, OH: $115,275 - $169,070 o WA Only: $108,375 - $205,750 Bonus Opportunity (based on Company and Individual Performance) 401(k) Medical Vision Health Savings and Flexible Spending Accounts Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions, we encourage you to submit your application promptly. Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race, color, religion, gender, sexual orientation, gender expression, genetic information, national origin, age, disability, marital status, military and veteran's status, or any other basis protected by applicable discrimination laws. Spokane, WA only: Residents who prefer not to provide their address click here to submit your resume via email:View email address on click.appcast.io #J-18808-Ljbffr