Semantic Layer Engineer

About MasterControl: MasterControl Inc. is a leading provider of cloud-based quality and compliance software for life sciences and other regulated industries. Our mission is the same as that of our customers to bring life-changing products to more people sooner. The MasterControl Platform helps organizations digitize, automate and connect quality and compliance processes across the regulated product development life cycle. Over 1,000 companies worldwide rely on MasterControl solutions to achieve new levels of operational excellence across product development, clinical trials, regulatory affairs, quality management, supply chain, manufacturing and postmarket surveillance. For more information, visit www.mastercontrol.com . Role Design and own a governed semantic layer and procedural query system that enables AI agents to reliably converse with enterprise data. Build the bridge between user intent → structured queries → reproducible results, ensuring all interactions are accurate, explainable, and deterministic. Responsibilities Define canonical entities, relationships, metrics, and hierarchies Enforce consistent business definitions across systems Model join paths, grain, and aggregation rules Create versioned, reusable metric definitions Resolve conflicting logic across teams Ensure correctness across all query combinations Design APIs for filtering, aggregation, grouping, and joins Enable agents to operate via predefined semantic procedures, not raw SQL Map intent → validated query plans Support systems where users ask questions in natural language Ensure responses are grounded in: Semantic layer definitions Deterministic execution paths Control how queries are constructed: Enforce valid joins and filters Prevent ambiguity and incorrect aggregations Inspect and optimize generated SQL Maintain traceability from source → semantic model → output Implement validation tests and metric checks Optimize queries, materializations, and caching Ensure low-latency responses for interactive use Requirements 5–7 years of experience in large-scale enterprise data modeling for AI/ML applications Strong proficiency in Java or Python, with a preference for Java for production service development and Python for NLP workflows Deep understanding of joins, grain, aggregations, and window functions Strong experience with semantic layers (e.g. Cube) and modern data warehouses (e.g. Snowflake) Experience building metric layers used across teams, and with query abstraction or API-based data access Preferred Experience enabling natural language → data query systems Familiarity with: Controlled use of LLMs in data applications Query planning or rule-based systems What We Are Not Looking For Direct AI/LLM access to raw databases Ad-hoc or conflicting metric definitions Opaque or non-traceable query generation PHYSICAL DEMANDS AND WORKING CONDITIONS: Some travel is required, typically to meet with customers, team and organizational meetings, etc. Must be able to work exceptionally well with people of varying backgrounds and personality types. Ability to operate a computer and work at a desk for extended periods of time. Ability to communicate effectively in writing, in person, over the telephone and through various collaborative tools such as Zoom, Confluence and Slack. Why Work Here? #WhyWorkAnywhereElse? MasterControl is a place where Exceptional Teams come together to do their best work. In fact, hiring Exceptional Teams is a core value of ours. MasterControl employees are surrounded by intelligent, motivated, and collaborative individuals. We like to call it #TheBestTeamOnThePlanet. We work hard to develop and challenge our employees' skillsets, recognize their contributions, encourage professional development, and offer a one-of-a-kind culture. This is why we say #WhyWorkAnywhereElse? MasterControl could be your next (and last) career move! Here are some of the benefits MasterControl employees enjoy: Competitive compensation Schedule flexibility Fitness clubs (you get paid to have fun and be active!) Company parties and employee recognition programs Wellness programs Much, much more! MasterControl is an Equal Opportunity Employer. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact [email protected] or call (801) 942-4000 and ask to speak with a member of Human Resources. Equal Opportunity Employer, including disability and protected veteran status.