About the role:

As part of the Query Generation team at ThoughtSpot, you'll help shape the future of how data teams transform raw information into actionable intelligence.

In this role, you'll contribute to building and scaling SQL generation pipelines, improving query accuracy and performance, and pushing the boundaries of what's possible when natural language meets structured data.

What you'll do:

Development of complex projects in Java, PostgreSQL, SQS, DynamoDB

Design and implement scalable backend systems that process and manage large volumes of customer data

Build and improve SQL generation pipelines that translate user intent into accurate, optimised queries across diverse data sources

Analyse and improve the efficiency, scalability, and reliability of our backend stack

Write robust code and write functional, performance, and system test suites

Utilise AWS services to build robust cloud-based solutions

Work as a member of a team, helping the team respond quickly and effectively to business needs

Collaborate with cross-functional teams, including product, design, and QA, to deliver high-quality products

Proactively identify and resolve technical challenges

Stay current with AI/ML and LLM trends and incorporate them into query generation solutions

What you bring:

4+ years of professional experience in software engineering

Strong background in data science, analytics engineering, or a related quantitative discipline

Proficiency in Java and object-oriented programming principles

Deep understanding of SQL — query construction, optimisation, and execution across relational databases

Hands-on experience building or working with analytics tools, BI platforms, or query engines

Experience building distributed and scalable systems

Awareness of message queuing systems

Strong grasp of software engineering best practices

Excellent problem-solving skills and ability to troubleshoot complex issues

Ability to work independently and as part of a team