Lead Semantic Layer Engineer at Oracle

Job description

Oracle Health is seeking a Lead Semantic Layer Engineer to build the governed semantic and knowledge foundation that enables AI agents and end users to work from consistent business definitions, trusted metrics, and reusable analytics logic. This role will own the design and governance of a semantic layer that captures business entities, relationships, metrics, dimensions, hierarchies, glossary terms, lineage, and validation rules across priority analytics domains. This semantic foundation will power AI-driven analytics use cases such as metric design, natural-language search, self-service reporting, dashboard generation, and executive narrative creation. The ideal candidate combines strong analytics engineering and data modeling experience with a deep understanding of metric governance, business semantics, and how trusted definitions support both human and AI consumers. This role is central to ensuring that AI outputs are accurate, explainable, and aligned with Oracle Health business meaning. Key Responsibilities Design and implement a governed semantic layer for key analytics domains, including entities, relationships, dimensions, metrics, hierarchies, and business rules. Define certification and validation workflows for business metrics and semantic definitions. Build and maintain business glossary content, synonyms, reference logic, and reusable definitions that support AI search and natural-language interaction. Partner with analytics, reporting, and data teams to reconcile metric definitions and reduce duplicate or conflicting business logic. Enable AI and self-service reporting use cases by exposing trusted semantic definitions in machine-usable formats. Support AI workflows such as metric design, report generation, dashboard scaffolding, and narrative generation through high-quality semantic metadata. Establish documentation, lineage, versioning, and change-management practices for semantic assets. Help create the governed knowledge foundation required for accurate, explainable, enterprise-safe AI outputs. Required skills Semantic layer design Data modeling and analytics engineering Metric governance Business glossary and semantic definition management SQL and data warehouse concepts BI and reporting systems Metadata, lineage, and documentation practices Self-service analytics design Natural language analytics enablement Cross-functional collaboration Strong written communication Versioning and governance of analytical assets Disclaimer: Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements. Range and benefit information provided in this posting are specific to the stated locations only US: Hiring Range in USD from: $99,600 to $209,500 per annum. May be eligible for bonus and equity. Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. Oracle US offers a comprehensive benefits package which includes the following: 1. Medical, dental, and vision insurance, including expert medical opinion 2. Short term disability and long term disability 3. Life insurance and AD&D 4. Supplemental life insurance (Employee/Spouse/Child) 5. Health care and dependent care Flexible Spending Accounts 6. Pre-tax commuter and parking benefits 7. 401(k) Savings and Investment Plan with company match 8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the fir