Semantic Layer Engineer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
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.
RESPONSIBILITIES: Define canonical entities, relationships, metrics, and hierarchies
Model join paths, grain, and aggregation rules 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 SQLSupport systems where users ask questions in natural language Ensure responses are grounded in semantic layer definitions and deterministic execution paths Control how queries are constructed: enforce valid joins and filters, prevent ambiguity and incorrect aggregations Inspect and optimize generated SQLMaintain traceability from source ? semantic model ? output Implement validation tests and metric checks Optimize queries, materializations, and caching Ensure low-latency responses for interactive useREQUIREMENTS5–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 accessPREFERREDExperience enabling natural language ? data query systems Familiarity with controlled use of LLMs in data applications Familiarity with query planning or rule-based systemsWHAT WE ARE NOT LOOKING FORDirect AI/LLM access to raw databases Ad-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.
BENEFITS: 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 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.