Sr. Engineer, Semantic Layer Analytics

Sr. Semantic Layer Analytics Engineer

Independent Purchasing Cooperative (IPC), a strategic sourcing partner for Subway® restaurants across North America, Canada, Puerto Rico, and the U.S. Virgin Islands, is seeking a highly motivated Sr. Semantic Layer Analytics Engineer. This role transforms curated data into trusted, business-ready analytical and operational models that support reporting, self-service analytics, business workflows, and AI-enabled solutions.

The ideal candidate combines strong data modeling expertise with a deep understanding of business processes, metrics, and analytical requirements.

The essential duties and responsibilities, knowledge, skills, and abilities listed below are required to be successful in this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties and responsibilities.

• Semantic Modeling & Data Design
• Design and maintain reusable analytical models, dimensional models, and semantic layers that support enterprise reporting and analytics.
• Develop and optimize Power BI semantic models, including relationships, hierarchies, measures, and performance tuning.
• Define and maintain governed business metrics, KPIs, calculations, and data definitions.
• Build and support reusable datasets that promote consistency across reporting, analytics, and operational use cases.
• Ensure analytical models align with established data architecture and governance standards.

• Ontology & Business Modeling
• Partner with business stakeholders and technical teams to model business entities, relationships, processes, and operational concepts.
• Support the design and maintenance of ontology structures within Palantir Foundry and related platforms.
• Align operational models with curated datasets and approved business definitions.
• Translate business requirements into scalable data structures that support workflow automation, decision-making, and AI-enabled solutions.

• Analytics Enablement
• Develop certified semantic models and reusable datasets that enable self-service analytics and reporting.
• Create and maintain reusable measures, calculations, and business logic.
• Collaborate with BI developers and analysts to ensure reporting solutions leverage governed data assets.
• Improve model usability, performance, adoption, and documentation.
• Support users in understanding data definitions, KPIs, and analytical capabilities.

• Data Quality & Business Collaboration
• Validate analytical models against business rules, source systems, and reconciliation requirements.
• Partner with Data Product Engineers to ensure data products are accurate, complete, and ready for consumption.
• Document metric definitions, business rules, lineage, assumptions, and known limitations.
• Work closely with business stakeholders to define KPIs, dimensions, reporting requirements, and operational metrics.
• Identify opportunities to standardize reporting logic and reduce duplicate calculations across the organization.
• All other duties as reasonably assigned.

• Experience with Microsoft Fabric, One Lake, Lakehouse, Warehouse, Direct Lake, and Power BI governance.
• Experience with Palantir Foundry, Ontology, operational workflows, or AI-enabled data solutions.
• Experience designing certified datasets, governed metric frameworks, and self-service analytics environments.
• Knowledge of data quality validation, reconciliation processes, and data governance practices.
• Experience supporting supply chain, finance, operations, procurement, inventory, or customer analytics.
• Familiarity with business intelligence, reporting, and enterprise analytics solutions.

• Proactive:
  Anticipate potential issues, questions from leadership or the brand; utilizing data and insight to plan ahead
• Action Oriented:
  Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm while maintaining humble professionalism
• Customer Focus:
  Building strong franchisee experience through customer and vendor relationships that delivers franchisee-centric solutions
• Ensures Accountability:
  Holds self and others accountable to meet commitments,…