Sr. Engineer, Semantic Layer Analytics

Independent Purchasing Cooperative Inc; Miami (FL); On-site; USD 120,000 - 160,000; Full time

Job summary

Independent Purchasing Cooperative (IPC), a Miami-based member-owned sourcing partner for Subway® franchisees, seeks a Sr. Semantic Layer Analytics Engineer to transform curated data into trusted analytical models and governance-ready assets.

You will design semantic and dimensional models, build Power BI datasets, and enable self-service analytics and AI-enabled solutions across the enterprise. The role requires strong data modeling, SQL, and Power BI expertise, with collaboration across Data

Qualifications

• 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.
• Translate business requirements into scalable data structures that support workflow automation, decision-making, and AI-enabled solutions.
• Create and maintain reusable measures, calculations, and business logic.

Skills

Power BI governance

Data modeling

Semantic modeling

SQL

Business analytics

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field

Tools

Palantir Foundry

Power BI

Job description

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

Essential Duties and Responsibilities

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.

Knowledge, Skills, and Abilities

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

Competencies

• 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, acts with a clear sense of ownership, takes personal responsibility for decisions, actions and failures
• Collaborates: Builds partnerships and works collaboratively with others to meet shared objectives while gaining trust and support of others
• Communicates Effectively: Develops and delivers a clear message in a variety of communication settings, attentively listens to others and adjusts their own style
• Decision Quality: Makes good and timely decisions that keep the organization moving forward
• Plans and Aligns: Plans and prioritizes work to meet commitments aligned with organizational goals
• Resourceful: Secures and deploys resources effectively and efficiently
• Self-Development: Actively seeking new ways to grow and be challenged using both formal and informal development channels
• Tech Savvy: Anticipates

Qualifications and Experience

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

Leadership Responsibility

No

Travel

This job does not require international travel. Occasionally, local travel within driving distance, and overnight domestic travel may be required.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets. While performing the duties of this job, the employee is regularly sitting for long periods of time. A detailed description of these physical requirements is available upon request. Compliant with the ADA, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.

This is a full-time position. Standard office hours of Monday through Friday, 8:30 AM to 5:00 PM EST. This position may require additional work hours outside these work hours, including weekends to complete job requirements.

Independent Purchasing Cooperative (IPC) provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Disclaimer

The above job description is meant to describe the general nature and level of work being performed; it is not intended to be an exhaustive list of all responsibilities, duties, and skills required for the position. Team Members may be required to perform other duties as requested by their leader(s) in compliance with Federal and State laws.