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
Preferred Qualifications
- Experience with NLP, LLMs, or AI-driven query generation systems
- Familiarity with query plan analysis and database internals
- Prior exposure to semantic layers, data modelling, or metadata management
- Experience working on cloud platforms like AWS
- Knowledge of agile development methodologies
- Experience with Dropwizard for building RESTful APIs
- Familiarity with DuckDB for analytical queries
