Manager, Semantic Layer Engineering

Manager, Semantic Layer Engineering

Who are we looking for? Choice Hotels, one of the world’s largest lodging franchisors, is looking for a Manager, Semantic Layer Engineering to build and maintain a semantic layer, a single source of truth for business metrics across reporting, operations, and AI. The Advanced Analytics team at Choice is the team that makes sure everyone across the company — from the franchise owners running our hotels to our commercial teams and senior leaders — is working from the same trusted numbers, whether those numbers show up in a report, an operational system, or an AI assistant.

As a key member of our Advanced Analytics team, you will build the governed, machine-readable metric definitions that consolidate logic across dashboards and spreadsheets into one certified foundation every report, system, and AI consumer can trust.
Are you a hands‑on data leader who thinks in metric definitions, holds a high bar for governance and documentation, and is energized by turning inconsistent business logic into trusted, code-based standards?

• Build and maintain the enterprise semantic layer as the default source for governed metrics consumed by dashboards, operational systems, data science, and AI agents, following established semantic layer and metrics tooling standards set by governance leadership.
• Implement metric definitions as version‑controlled, tested, reusable logic — including SQL, transforms, and joins against AWS Redshift, S3, and other systems — in alignment with established business meaning and product‑defined governance criteria.
• Execute performance, reliability, and cost optimization tasks for metric query execution, following established observability practices and escalating significant infrastructure decisions for supervisor review.
• Operate automated test coverage, SLA monitoring, lineage tracking, anomaly detection rules, and incident response processes for enterprise‑certified metrics, following documented quality standards.
• Review proposed changes to enterprise‑certified metric definitions and support technical change approvals in coordination with the defining product manager, ensuring all updates follow established change management protocols and propagate through the semantic layer.

• Execute the metric certification lifecycle, administering promotion gates through which metrics graduate from exploration to product‑scoped use to enterprise certification based on usage, quality, and cross‑team impact.
• Work with product managers under a shared ownership model — product defines the metric need, meaning, quality thresholds, and freshness expectations — and execute implementation, monitoring, and enforcement activities.
• Identify metric inconsistencies within assigned functional areas, consolidating duplicate and conflicting metric logic into shared, governed definitions (e.g., a single enterprise definition of RevPAR), and escalating cross‑team conflicts that cannot be resolved at the team level to the Senior Director for governance review.
• Document workflows, build processes, and approval paths for metric proposal, validation, certification, and consumption.
• Maintain accurate records of metric lifecycle status, quality results, and open issues, providing regular and ad‑hoc status updates to the Senior Director to support governance oversight.

• Expose governed metrics and business context to BI platforms (Tableau), operational systems, data science, and AI agents, following established integration patterns so that new products, reports, and AI consumers inherit trusted definitions automatically.
• Maintain governed business context within the supporting data catalog so that generative AI applications operate on certified business metadata as well as semantic logic, in alignment with catalog standards set by the Manager, Governance & Stewardship.
• Operate monitoring and alerting workflows for metric quality, freshness, and usage in the analytics platform, in partnership with the Manager, Governance & Stewardship, providing regular reports…