Semantic Data Modeler

Position Overview:

The Semantic Data Modeler develops and maintains the enterprise data platform’s semantic layer, ensuring business data is consistent, discoverable, and reusable across enterprise analytics and AI applications. Working with data architecture, engineering, governance, and business teams, this role translates business concepts into standardized data models, relationships, and metadata that support business requirements, generative AI, retrieval-augmented generation (RAG), natural language querying, and AI-powered applications.

Responsibilities:

• Design, develop, and maintain conceptual, logical, physical, dimensional, and semantic data models aligned with enterprise architecture standards and business requirements.
• Translate business concepts into reusable models that define entities, attributes, relationships, business rules, KPIs, and standardized definitions.
• Map business concepts to underlying data assets and maintain semantic metadata to support analytics, generative AI, RAG, natural language querying, and AI agents.
• Collaborate with Enterprise Architecture, data engineering, governance, analytics, AI teams, and business stakeholders to validate definitions and align models with enterprise standards.
• Improve semantic consistency, metadata completeness, and contextual relevance to enhance data quality and AI application outcomes.
• Incorporate data quality, lineage, privacy, security, and access controls into modeling practices to support trusted and responsible data use.
• Establish reusable modeling patterns, naming conventions, and design standards to minimize duplicated business logic and conflicting definitions across data domains.
• Facilitate modeling workshops and design reviews, document key decisions, and promote consistent semantic modeling practices across the organization.
• Understand AWS-based data pipelines and data flows, including how data is ingested, transformed, and delivered across the enterprise data platform, to ensure semantic models align with source systems, data transformations, and downstream analytics and AI applications.

Essential Functions:

Essential Job Function

% of Time on Function

Design, develop, and maintain conceptual, logical, physical, dimensional, and semantic data models aligned with enterprise architecture standards and business requirements.

40%

Translate business requirements into reusable models, defining entities, attributes, relationships, business rules, KPIs, and standardized business definitions. Map business concepts to underlying data assets.

30%

Prepare and enhance semantic models and metadata to support generative AI, RAG, natural language querying, AI agents, and enterprise AI applications.

15%

Understand AWS-based data pipelines, ingestion, transformation, orchestration, and data flows to ensure semantic models align with source systems and downstream analytics and AI applications.

15%

Total

100%

Job Requirements:

• Bachelor’s degree in Computer Science, Information Systems, Data Management, or a related discipline, or equivalent practical experience.
• 7+ years of experience in data modeling, semantic modeling, data architecture, or enterprise data management.
• Demonstrated experience designing and maintaining conceptual, logical, physical, dimensional, or semantic data models, translating business requirements into reusable models and standardized definitions.
• Strong SQL skills and understanding of relational databases, data structures, entity relationships, and data integration concepts.
• Experience with metadata management, data governance, data quality, and data lineage practices.
• Understanding of AWS-based data pipelines, including data ingestion, transformation, orchestration, and data flows across enterprise data platforms.
• Willingness for travel as required.

Minimum Physical Requirements:

The physical demands described represent those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions of the position for which they work. While performing the duties of this position, the employee is regularly required to listen, talk and hear. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls while executing tasks like working on a computer or talking on the telephone. The employee is occasionally required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 15 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually moderate to low.

This job description is intended to provide guidelines for job expectations and the employee's ability to perform the position described. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Salary Range (Norwalk, CT): $101,150.69 - $134,867.58

Annual Bonus Potential: 10%

HomeServe USA is an equal opportunity employer.

#HUSA