Apply now »

Semantic Modeler

30764

We are Farmers!

We are… more than just your favorite commercials.  At Farmers, we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions, own our actions, and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers. 

 

Farmers is an award winning, equal opportunity employer, committed to the strength of an inclusive workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn’t just our business – it’s our culture!  To learn more about our high-performance culture and open opportunities, check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok. 

 

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 Summary

This position designs and develops a robust semantic layer and underlying data model to bridge the gap between technical data and business language. The primary objective is to facilitate intuitive self-serve access to data in simple business language for easy exploration and analysis by users across the organization. The role develops the semantic layer by applying data virtualization principles on a cloud environment. The position collaborates with business and technical partners to define and refine a comprehensive data model and ensure semantic consistency across platforms. The role contributes to continuously improving data quality and accessibility standards. Performs work within functional guidelines and works independently while receiving minimal guidance from a supervisor.

What You'll Do

  • Collaborates with data architect to understand the overall data strategy and requirements for the semantic layer. Designs and develops a comprehensive semantic data model that accurately reflects the business meaning of data entities and their relationships. Participates in testing and validating the semantic data model to ensure it meets performance and usability requirements. Defines data quality checks, transformations, and cleansing rules and works with data engineers to implement them within the semantic layer. Documents the semantic data model including detailed entity definitions, relationships, and data lineage information.
  • Engages business and technical partners to translate technical data terminology into clear and simple business language. Consults with stakeholders to understand business needs, identify key concepts, and learn preferred terminology. Uses in-depth knowledge of data modeling, database management systems, and semantic methodologies combined with working knowledge of the business to create easy-to-understand business glossaries. Facilitates a shared understanding of business data across the organization.
  • Analyzes data sources from multiple systems to understand their structure, content, and relationships. Collaborates with data source owners to enable data access through the semantic layer. Uses semantic modeling best practices to ensure semantic model is optimized for self-service data access and analysis.
  • Applies in-depth knowledge and practical expertise in data virtualization to access, integrate, and analyze diverse datasets to create data and semantic models that equip business partners across the organization with valuable, data-driven insights.
  • Works closely with internal IT and technical partners to define and implement security provisioning measures for accessing and connecting to data sources, ensuring adherence to the established policies and procedures and standards of the organization.
  • Stays updated on best practices, trends, and advancements in data modeling and semantic modeling methodologies. Acts as a knowledgeable resource to lead, guide, and support the implementation of a robust semantic layer and underlying data model. Performs other duties as assigned.

What You'll Bring

  • Minimum five years of experience required in data modeling with a focus on semantic layers.
  • Experience preferred in working with data modeling tools and methodologies.
  • Experience with ETL  (Extract, Transform, Load) tools, APIs, Python or Java.
  • Experience with data virtualization tools, a plus.

Education Requirements

  • High School Diploma or equivalent required.
  • Bachelors degree preferred, with focus in computer science, information systems, or related field preferred.

Additional Qualifications

  • Strong verbal communication and listening skills with ability to convey complex technical data to others in a simple and clear manner.
  • Demonstrated written communication skills. Able to translate complex technical data into clear business language.
  • Demonstrated analytical skills. Demonstrated problem solving skills.
  • Effective interpersonal skills.
  • Possesses strong technical aptitude. Strong understanding of data virtualization principles, concepts, and technologies and their performance characteristics. Strong understanding of cloud-based data management and analytics technologies and tools. Proficiency in SQL and relational databases. Demonstrates excellent judgment and decision making skills.
  • Performs work independently with minimal supervision. 
  • Possesses a high degree of initiative.
  • Seeks to acquire knowledge in area of specialty. Strong understanding of data quality, data governance, security, and data classification principles and practices. 

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.

Benefits

  • Farmers offers a competitive salary commensurate with experience, qualifications and location.
    o CA Only: $95,040 - $151,140
    o CO Only: $89,280 - $130,680 
    o HI/IL/MN/VT Only: $89,280 - $140,030
    o MA Only: $89,280 - $140,030 
  • o MD Only: $89,280 - $140,030
    o DC/NJ/NY/OH Only: $89,280 - $151,140 
             o Albany County, NY/Cleveland, OH: $95,040 - $130,680 
    o WA Only:  $89,280 - $159,125 
  • 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

 

Job Location(s): R_US - United States

 

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. 

 

Want to learn more about our culture & opportunities? Check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.

 

Spokane, WA only:  Residents who prefer not to provide their address click here to submit your resume via email: careers@farmers.com

Apply now »