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 .RoleDesign 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.ResponsibilitiesDefine canonical entities, relationships, metrics, and hierarchiesEnforce consistent business definitions across systemsModel join paths, grain, and aggregation rulesCreate versioned, reusable metric definitionsResolve conflicting logic across teamsEnsure correctness across all query combinationsDesign APIs for filtering, aggregation, grouping, and joinsEnable agents to operate via predefined semantic procedures, not raw SQLMap intent → validated query plansSupport systems where users ask questions in natural languageEnsure responses are grounded in:Semantic layer definitionsDeterministic execution pathsControl how queries are constructed:Enforce valid joins and filtersPrevent ambiguity and incorrect aggregationsInspect and optimize generated SQLMaintain traceability from source → semantic model → outputImplement validation tests and metric checksOptimize queries, materializations, and cachingEnsure low-latency responses for interactive useRequirements5–7 years of experience in large-scale enterprise data modeling for AI/ML applicationsStrong proficiency in Java or Python, with a preference for Java for production service development and Python for NLP workflowsDeep understanding of joins, grain, aggregations, and window functionsStrong 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 accessPreferredExperience enabling natural language → data query systemsFamiliarity with:Controlled use of LLMs in data applicationsQuery planning or rule-based systemsWhat We Are Not Looking ForDirect AI/LLM access to raw databasesAd-hoc or conflicting metric definitionsOpaque 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.

Apply Now