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.