Semantic Layer Engineer

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 hierarchiesModel join paths, grain, and aggregation rulesResolve 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 SQLSupport systems where users ask questions in natural languageEnsure responses are grounded in semantic layer definitions and deterministic execution pathsControl how queries are constructed: enforce valid joins and filters, prevent 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 applicationsFamiliarity with query planning or rule-based systemsWHAT WE ARE NOT LOOKING FORDirect AI/LLM access to raw databasesAd-hoc or conflicting metric definitionsPHYSICAL DEMANDS AND WORKING CONDITIONSSome 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.BENEFITSCompetitive compensationSchedule flexibilityFitness clubs (you get paid to have fun and be active!)Company parties and employee recognition programsWellness programsMuch, 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 MCTalent@MasterControl.com or call (801) 942-4000 and ask to speak with a member of Human Resources. Equal Opportunity Employer, including disability and protected veteran status.J-18808-Ljbffr