FBS Sr Data Engineer (SQL, Informatica)

Select how often (in days) to receive an alert:

36371

Farmers– where ambition meets opportunity.

Farmers is known for more than its unforgettable jingle – it’s a team with a passion for purpose and making a real difference in people’s lives. Farmers employees deliver peace of mind when it matters most. The organization’s 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 the team. Farmers employees tackle challenges head‑on, learn from every experience and measure their impact on the customers who trust them.

Join usand help power the success of Farmers. As a team member, you’ll collaborate with Farmers’ award‑winning workforce, benefit from a culture of innovation and support and contribute to their mission of delivering protection and peace of mind to millions of U.S. customers.

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.