Lead - AI Data Intelligence (ETL,Azure, SQL, Python, Spark, Data Lakehouse) 7 - 11 years exp from SaaS companies
ZenotiHyderabad, Telangana, IndiaOn-Site
Needs a free Superjobs account. You'll finish on Zenoti's Greenhouse page.
Skill score
Summary
The Lead for AI Data Intelligence guides engineering pods and acts as technical advisor to clients, designing governed semantic layers and building production Text-to-SQL and natural language query platforms across Databricks, Redshift, and SQL Server backends. The role suits a senior engineer with strong .NET, Python, and data pipeline experience who can also mentor engineers and explain technical choices to executives.
- Function
- Data Science
- Estimated salary
- Est. ₹19–29 LPA
- Estimated for a manager role, ~8 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Hyderabad, Telangana, India
- Experience
- 8+ yrs
Job description
Overview
Our enterprise products run across AWS and Azure, built on a mission-critical transactional backbone of .NET, C#, Microsoft SQL Server, and extensive RESTful APIs, with modern interfaces delivered via React and Flutter. As we advance our data intelligence capabilities, we are engineering production-grade Text-to-SQL and Natural Language Query (NLQ) platforms that connect operational systems to cloud lakehouses across Amazon Redshift and Databricks (Delta Lake and Unity Catalog) via high-performance Python and FastAPI microservices. In this role, you will act as a technical leader and strategic advisor—partnering directly with business stakeholders to scope high-value analytical workflows, designing governed semantic models and metric ontologies, and guiding engineering pods to build and deploy reliable, conversational data products capable of handling terabytes of data and millions of records with 24x7 enterprise availability.
Roles and responsibilities
- Lead cross-functional engineering pods to design, build, and deploy production Text-to-SQL and Natural Language Query (NLQ) platforms that enable non-technical business teams to query enterprise data.
- Act as a technical advisor, partnering directly with client stakeholders and business leaders to diagnose operational bottlenecks, scope high-impact use cases, and deliver working solutions.
- Architect governed semantic layers, business ontologies, metric views, and parameter mappings that ground language models in verified business logic.
- Build robust microservices, REST APIs, and event-driven data pipelines connecting .NET/C# and SQL Server backends with modern Python, FastAPI, Databricks, and Amazon Redshift platforms.
- Partner closely with product managers, UI/UX designers, and frontend engineers to build responsive conversational data experiences featuring smart disambiguation, interactive filters, and full query provenance.
- Put in place enterprise AI guardrails, evaluation suites, and observability frameworks (golden test datasets, prompt defence, token-cost tracking) to guarantee safety, data privacy, and reliability in production.
- Champion modern AI-assisted engineering practices (using tools like Claude Code, Cursor, and Copilot) and create reusable engineering assets (prompts, MCP servers, automation templates) to accelerate team velocity.
Skills required
Top skills
- Text-to-SQL
- Natural Language Query (NLQ)
- C#/.NET
- REST APIs
All skills (9)
- SQL Server
- Python
- FastAPI
- LLM orchestration
- Semantic layer design
- Databricks
- Amazon Redshift
- React
- Conversational UI design
Qualifications
- 8+ years of experience designing, building, and operating enterprise-scale distributed software and cloud systems, demonstrating deep mastery of OOP and modern .NET/C# REST APIs.
Nice to have
- Deep expertise in SQL Server (relational schema design, complex joins, views, and aggregations), along with hands-on experience building scalable data pipelines on Amazon Redshift and Databricks (Delta Lake, Unity Catalog), would be a plus
- 2+ years of dedicated, hands-on production experience navigating the AI development lifecycle, including LLM orchestration, agentic architectures, contextual retrieval, and non-deterministic system evaluation.
- Advanced proficiency in Python and FastAPI for developing asynchronous microservices, data validation schemas, and enterprise integration gateways.
- Practical experience building Text-to-SQL and NLQ systems, with strong capability in semantic layer architecture and business ontology modelling (metric views, dimensional models, and parameterized functions).
- Experience designing conversational UI workflows (intent disambiguation, active parameter filtering, interactive charting, query lineage drawers), with exposure to benchmark products like Databricks Genie, or comparable conversational analytics tools would be a plus.
- Proven hands-on solutions engineering acumen, comfortable operating in ambiguous, client-facing environments to translate business goals into working technical architectures and drive rapid delivery cycles.
- Strong technical leadership experience, with a track record of mentoring senior engineers, leading delivery pods, and clearly explaining complex technical choices to senior executive stakeholders.
- Familiarity with modern frontend frameworks (such as React, Flutter, or Next.js) for delivering responsive data visualization and conversational analytics.
- Hands-on familiarity with modern AI-assisted development tools (Cursor, Claude Code, Copilot) combined with the critical engineering judgment needed to audit and validate generated code for enterprise security, accuracy, and scalability.
- Bachelor’s or master’s degree in computer science, Software Engineering, Information Systems, or equivalent practical industry experience.
Company info
About Zenoti
Zenoti provides a cloud-based software platform for the beauty and wellness industry, covering online appointment booking, point of sale, customer relationship management, employee and inventory management, and built-in marketing programs. The platform is used by salons, spas, medspas, and fitness studios to run and manage their businesses.