Semantic Layer Engineer

Department Icon IT / Software Development & Related
Posted: 6 months ago
5-7 years
Hyderabad / Secunderabad, Telangana, Telangana
IT / Software Development & Related
work from office
Full Time

Posted: 6 months ago

This job is no longer accepting applications

It closed on 17 Jun 2026. Here are 6 live jobs like it - apply in one step.

See all live IT / Software Development & Related jobs
Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

Job Description

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 [HIDDEN TEXT] or call (801) 942-4000 and ask to speak with a member of Human Resources.

Equal Opportunity Employer, including disability and protected veteran status.

Skills

PythonData ModelingQuality ManagementSnowflakeAi/mlAiMlSql

If a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.

About Company

MasterControl provides software solutions for life sciences companies. More specific details require access to their website.

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New IT / Software Development & Related roles in Hyderabad / Secunderabad.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.