Share this Job
Apply now »

Data Solution Advisor I


We are Farmers!

Join a team of diverse professionals at Farmers to acquire skills on the job and apply your learned knowledge to future roles at Farmers. Farmers Insurance also offers extensive training opportunities through the award winning University of Farmers named by Training magazine amongst top 10 corporate training units in the world.

Job Summary

Farmer’s industry leading workforce is passionate about creating data solutions that are secure, reliable, and efficient in support and under the guidance of our Farmers Strategic Objectives. Farmers is evolving into an agile work environment with collaboration in mind and a continuous improvement culture through the understanding of business processes, relationships, and requirements of data analysis, data modeling, data quality, data governance, data engineering, automation, and AI/ML. 

A Data Designer plays an integral part of the Enterprise Data Office by providing thought leadership and performing a variety of tasks that guide and position data-intensive projects/programs for success.  This is accomplished by understanding data requirements, coordinating work across IT, ensuring resources are following appropriate practices and enterprise standards. This role may also be tasked to present experience and learning from various projects to/from the current, future, and past to enable a continuous improvement mindset within the data space. 

Essential Job Functions

•    Subject matter expertise with the knowledge of Farmer’s data assets, IT applications processes, tools, and techniques. 
•    Provides recommendations, reconciles conflicts, aligns needed resources, identifies, and resolves deviations in practices. 
•    Maps the flow of data and the business processes and/or technical interfaces which would be created or impacted and recommends solutions/adaptations. 
•    Documents the source to target mappings for data integration and web services. 
•    Ensures alignment with data quality and transformation rules and develops infrastructure and/or other tools to communicate mapping to relevant groups. 
•    Works with enterprise partners to conduct complex data profiling using enterprise standard technologies. 
•    Key contributor in the creation and review of conceptual, logical, and physical data models and determines the most appropriate method to represent the data for business consumption. 
•    Proactively consults and provides recommendations and direction on data needs to satisfy business requirements, intent, and objectives.
•    Ensures Compliance with Enterprise Data Governance policies and standards on information risk and data protection guidelines. 

Physical Actions

Physical Environment

This position operates in an open office working environment which 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 (e.g. others speaking) at normal speaking levels with or without correction. Visually verifies and reads information. Visually locates material, resources and other objects. Ability to 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.

Education Requirements

Bachelor’s degree preferred or equivalent, relevant experience. High school diploma or equivalent required.

Experience Requirements

•    Two to Five years’ experience working in a data related role, preferably within the financial services industry
•    Strong interpersonal communication and problem-solving skills
•    Ability to identify big picture developments and succinctly communicate them to others
•    Experience with Microsoft Excel, various databases, ETL, data modeling, cloud, and querying tools. 
•    Understanding of data entity relationships and data modeling
•    Broad knowledge base with a strong understanding of end-to-end solution delivery
•    Ability to work in Multiple environments with differing personalities to achieve desired results

Additional Qualification

Reports directly to strategy and Transformation Leader


  • Farmers offers a competitive salary commensurate with experience, qualifications and location
  • CO Only: The pay range for this job being performed in Colorado would be $102,400 – 136,500
  • 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


Job Location(s): R_US - RW - Remote Work, US - MI - Grand Rapids, US - MI - Caledonia KM1, US - CA - WdlndHills-6303, US - OH - Indpdc-4500, US - CA - WdlndHills-6301, US - KS - Kansas City, US - OK - OklaCty-Memrl


Candidate qualifications may be reviewed against the requirements for the associated levels of this positions core function


Want to learn more about our culture & opportunities? Check out and be sure to follow us on Instagram and LinkedIn!

Apply now »