Job Board
LogoLogo

Get Jobs Tailored to Your Resume

Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

Farmers Insurance Logo

Semantic Modeler

Farmers Insurance

$99,620 - $178,125
Oct 1, 2025
Washington, DC, US
Apply Now

Farmers is looking to design and develop a robust semantic layer and underlying data model to bridge the gap between technical data and business language, facilitating intuitive self-serve access to data for easy exploration and analysis by users across the organization.

Requirements

  • 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.
  • 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.

Responsibilities

  • 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.
  • Analyzes data sources from multiple systems to understand their structure, content, and relationships.
  • Applies in-depth knowledge and practical expertise in data virtualization to access, integrate, and analyze diverse datasets

Other

  • High School Diploma or equivalent required.
  • Bachelors degree preferred, with focus in computer science, information systems, or related field preferred.
  • 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.
  • Ability to work independently with minimal supervision.