Data Engineer (experienced)
About The Position
We are Farmers – where ambition meets opportunity. At Farmers, we’re not just known for 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. Ready to make your mark? Discover our vibrant culture and explore career opportunities at www.Farmers.com/careers/corporate. Connect with us on Instagram, LinkedIn and TikTok, and let’s build something incredible together! Workplace: Hybrid ( #LI-Hybrid ), Remote ( #LI-Remote ) 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 SummaryResponsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for basic to 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 with coaching and support. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools and is familiar with a few but requires training for some.What You'll Do
Requirements
- 3-5 years of related experience required.
- High School Diploma or equivalent required.
- Bachelor's degree preferred.
- Possesses strong technical aptitude.
- Intermediate experience in SQL, Spark (Scala or Python), Spark SQ or equivalent.
- Solid experience in dimensional modeling.
- Sound knowledge and experience building data pipelines to transform data as per business logic.
- Sound knowledge and understanding with pipeline orchestration.
- Intermediate to advanced experience with BI visualizations such as Power BI, Tableau etc.
- Strong verbal communication and listening skills.
- Proven experience interacting with executive and senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization.
Responsibilities
- Consults on data projects of intermediate complexity, with limited 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 reduced oversight required of leadership.
- Produces 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 and exploration with limited assistance and coaching.
- 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 estimates for a schedule or planned agile sprint.
- Projects are of increasing complexity but require less coaching and assistance from leadership.
- Develops and maintains moderately 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 feedback.
- Applies sound knowledge of data governance concepts with limited experience in application.
- Executes on mid size projects and large tasks within timelines.
- Develops data project plans and executes with some supervision.
- Performs other duties as assigned.
Benefits
- Farmers offers a competitive salary commensurate with experience, qualifications and location.
- Bonus Opportunity (based on Company and Individual Performance)
- 401(k)
- Medical
- Dental
- Vision
- Health Savings and Flexible Spending Accounts
- Life Insurance
- Paid Time Off
- Paid Parental Leave
- Tuition Assistance
- For more information, review “What we offer” on https://www.farmers.com/careers/corporate/#offer
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
