Sr. Engineer, Semantic Layer Analytics

Independent Purchasing Cooperative•Pinecrest, FL

8d•Onsite

About The Position

At Independent Purchasing Cooperative (IPC), we are more than just a supply chain services provider—we're the strategic sourcing partner behind one of the world’s most recognized brands: Subway®. As a member-owned organization, we are driven by our commitment to serve the franchisees who own and operate Subway® restaurants across North America, Canada, Puerto Rico, and the U.S. Virgin Islands. Headquartered in Miami, FL, we were founded in 1996 with a mission to help franchisees be more profitable and competitive by delivering exceptional value through supply chain solutions, contract negotiation, technology initiatives, and industry expertise. At IPC, you'll find a supportive and inclusive environment that fosters personal growth, professional development, and a healthy work-life balance. Whether you're a seasoned supply chain professional or just beginning your career journey, IPC offers opportunities to make a meaningful impact! IPC is seeking a highly motivated Sr. Semantic Layer Analytics Engineer to be responsible for transforming curated data into trusted, business-ready analytical and operational models that support reporting, self-service analytics, business workflows, and AI-enabled solutions. This role bridges data engineering and business analytics by designing semantic models, dimensional models, business metrics, Power BI datasets, and operational data structures. The Analytics Engineer ensures that users across the organization consume consistent, governed, and well-defined data while serving as a key partner to business stakeholders, Data Product Engineers, BI developers, and platform teams. The ideal candidate combines strong data modeling expertise with a deep understanding of business processes, metrics, and analytical requirements.

Requirements

Experience with Microsoft Fabric, OneLake, 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.
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field, or equivalent experience.
Experience with data modeling, dimensional modeling, star schemas, and analytical data structures.
Strong SQL skills and experience developing semantic models and reusable datasets.
Experience with Power BI, including semantic models, DAX, relationships, and performance optimization.
Understanding of data warehousing, Lakehouse architecture, and modern analytics platforms.
Ability to translate business requirements and KPIs into scalable analytical solutions.
Strong analytical, problem-solving, communication, and documentation skills.

Responsibilities

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.
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.
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.
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.