Head of Data
Replit
BigQueryPythonSQL
Semantic Modeler, Data Scientist
Farmers Insurance
full-time
Posted on:
Location Type: Hybrid
Location: California, Colorado, District of Columbia, Hawaii, Illinois, Maryland, Massachusetts, Minnesota, New Jersey, New York, Ohio, Vermont, Washington • 🇺🇸 United States
Visit company websiteSalary
💰 $89,280 - $151,140 per year
Job Level
Mid-LevelSenior
Tech Stack
CloudETLJavaPythonSQL
About the role
- 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.
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 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.
Benefits
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data modelingsemantic layersETLAPIsPythonJavadata virtualizationSQLrelational databasesdata quality checks
Soft skills
verbal communicationlistening skillswritten communicationanalytical skillsproblem solvinginterpersonal skillstechnical aptitudeability to translate technical data
