Member of Technical Staff

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 Mandatory and Required Skills for All ThoughtSpot Roles Spotters are expected to demonstrate AI literacy and workflow integration to include to ability to: Comfortably and confidently integrate artificial intelligence into their daily workflow to increase productivity and quality. Hands-on experience to leverage AI tools (industry-leading LLMs) to increase productivity, automate routine tasks, and improve work quality. Speak to the experience of using AI for research, content creation, and document summarization while maintaining ownership of judgment and final decisions. Write effective prompts to get the most accurate and creative results from AI tools. Spotters are expected to exemplify these key traits and AI Mindset: Curiosity in exploring new AI tools Adaptability to quickly learn and implement new, emerging AI technologies Critical thinking to know when to identify when AI should be used versus when human judgement is necessary This combination of curiosity, adaptability, and discernment defines the AI mindset, and it’s required for every role at ThoughtSpot. AI Mindset for All Spotters At ThoughtSpot, we believe AI is a necessary and essential part of how we work. Every role, across every team, is expected to be fluent and comfortable with using AI to do their best work. All Spotters are expected to experiment with ThoughtSpot’s AI tools (like Spotter and SpotterViz) and leading industry LLMs to streamline workflows, enhance output, and uncover new insights. Whether drafting content, analyzing data, or summarizing documents, AI is a d ... (truncated, view full listing at source)