Sr. Business Intelligence Engineer, Enterprise Intelligence (Hybrid, Bangalore)

Smartsheet is establishing a new Enterprise Insights & Intelligence team to centralize ownership of corporate metrics, analytics governance, and self-serve data enablement. This is a foundational hire — you will help build this function from the ground up, with direct visibility to senior leadership and the opportunity to shape how the entire organisation consumes and trusts its data.

We are looking for a Senior Business Intelligence Engineer who can operate across three strategic pillars: automating and governing corporate executive reporting, standardising metrics and reporting practices at scale, and enabling self-serve and AI-powered data solutions. Day to day, this means you could be building an automated executive scorecard, codifying metric definitions into a governed semantic layer, standing up an AI agent that lets business users query trusted data in natural language, or leading enablement sessions on our analytics platforms. The thread connecting all of it is ensuring that Smartsheet's data is trusted, consistent, accessible, and ready for both human and AI consumption.

This is not a traditional reporting or data science role. You will work across dbt, MetricFlow, Snowflake, and Databricks to build the governed data layer that underpins everything — from board-level scorecards to LLM-powered insights to self-serve dashboards.

You Will

• Design, build, and maintain governed metric models — standardised, reusable definitions of business KPIs that dashboards, reports, and AI agents all query from a single source of truth
• Own the automation and maintenance of corporate scorecards and executive reporting (SLT/XLT), ensuring trusted, timely data with AI-powered anomaly detection and alerting
• Conduct deep dives on key KPIs and company goals, surfacing actionable insights and translating short- and long-term business priorities into data-driven recommendations shared via reviews and async updates
• Lead metric certification and governance — maintain a centralised KPI glossary, standardise dashboards, and retire stale reporting assets
• Build AI agent integrations (MCP servers, skills, subagents) that allow tools like Claude and Snowflake Cortex to query enterprise data through the semantic layer with metric-correct SQL
• Drive self-serve analytics enablement — documentation, training, dashboard quality checks, and experimentation governance across Amplitude, Tableau, and other platforms
• Partner with Product, Engineering, Finance, GTM, and Customer Success to align metric definitions and data sources cross-functionally
• Translate qualitative UX signals and customer feedback into measurable data pipelines

You Have

• Bachelor's degree (B.Tech / B.E. / B.Sc.) in Computer Science, Engineering, Mathematics, Statistics, or a related quantitative field
• 5+ years of experience in analytics engineering, BI engineering, data engineering, or a closely related role
• Experience with KPI design and insight generation — ability to define meaningful metrics, analyse trends, identify anomalies, and communicate findings that drive business decisions
• Familiarity with dbt (dbt Core or dbt Cloud) and concepts like YAML-based metric definitions and reusable data models; hands-on experience is a plus but not required
• Deep SQL expertise with experience working in cloud data platforms such as Snowflake and/or Databricks
• Experience building semantic layers, governed data models, or canonic