Senior Business Analytics Engineer - India
Juniper SquareIndiaOn-Site
Needs a free Superjobs account. You'll finish on Juniper Square's Ashby page.
Skill score
Summary
This Senior Business Analytics Engineer owns dbt transformation logic and semantic-layer metric definitions such as ARR and CARR, reconciles them with NetSuite and the Finance close, and builds AI-assisted reporting and dashboards on top of them. The role suits an experienced analytics engineer who can translate business questions from Finance and Sales into technical requirements and works comfortably with US stakeholders.
- Function
- Data Science
- Estimated salary
- Est. ₹19–28 LPA
- Estimated for a senior role, ~8 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, India
- Experience
- 8+ yrs
- Employment type
- Full-time
Job description
Overview
About your role
We're hiring a Senior Business Analytics Engineer to produce the revenue numbers Juniper Square runs on. This role produces one computed definition of metrics for different ARR metrics for Sales, Finance, Fund Admin and leadership teams at different levels.
You'll own the dbt transformation logic and the semantic-layer definitions on top of our internal data warehouse, as part of a company-wide rebuild of how revenue moves from quote to recognized revenue. You'll also be the link between business stakeholders and our Data Engineering team, turning business questions into precise technical requirements. And you'll build the AI-assisted reporting layer that lets people and AI agents get the same trustworthy answer from the same source.
Roles and responsibilities
Transformation & data modeling
- Own dbt models for revenue and customer data sourced from CRM, CPQ, billing, and ERP systems
- Model the chain from quote to order to provisioning to invoice to recognized revenue at the entity and service grain
- Move reporting-level data generation out of Salesforce and into the warehouse, where other systems can consume it
Semantic layer & metric definitions
- Define and govern certified metrics like ARR and CARR and the dimensions behind them
- Write definitions precise enough for both people and AI agents to reason over consistently, backed by documentation, tests, and lineage
- Reconcile metrics with NetSuite and the Finance close so the numbers tie out
Requirements translation
- Translate business questions from Sales, Finance, Fund Administration, and leadership into technical requirements for Data Engineering, covering source data, grain, freshness, and quality
- Work with our Lead Business Systems Analyst and Integrations Engineers so the commercial model and source data are reportable from the start
AI-assisted reporting & measurement
- Build an AI-assisted reporting layer on top of governed semantic definitions, so questions asked through tools like Claude return certified answers
- Build self-serve dashboards for revenue, operations, and leadership stakeholders
- Stand up measurement for the Lead-to-Cash program so monthly progress is shown in numbers rather than status updates
Governance & controls
- Apply access controls, data classification, and change management suited to financial and customer data in SOX, SOC 1, and SOC 2 scope
Skills required
Top skills
- dbt
- SQL
- Semantic layer
- Data modeling
All skills (8)
- Salesforce data
- NetSuite data
- Cloud data warehouse
- Recurring revenue metrics
- Python
- BI tools
- Fund administration
- AI-ready data products
Qualifications
Required
- 8+ years in analytics engineering, data engineering, or business intelligence, including at least 2 years owning dbt models in production
- Expert SQL: window functions, CTEs, performance tuning, and the ability to work through legacy queries you didn't write
- Hands-on dbt experience across models, tests, documentation, incremental models, and CI
- Experience with a semantic layer tool (dbt Semantic Layer/MetricFlow, LookML, Cube, or similar)
- Strong understanding of recurring revenue metrics (ARR, CARR, bookings, backlog, churn) and how they tie to billing and revenue recognition
- Practical data modeling skills: dimensional modeling, slowly changing dimensions, and explicit grain
- Experience working with Salesforce and NetSuite data
- Experience with a cloud data warehouse (Redshift, Snowflake, BigQuery, or similar)
- Regular use of AI coding and data tools (e.g., Claude) in your own workflow
- Comfort working directly with US-based Finance and business stakeholders, with a few hours of overlap with US time zones
Nice to have
- Python for transformation logic, automation, or API-based extraction
- Experience with BI tools such as Looker, Tableau, Power BI, or Sigma
- Exposure to fund administration, private markets, or financial services
- Experience building AI-ready data products or metrics that agents can query
- A governance instinct: you understand why a change to revenue or customer data needs a control owner and a ticket
Other details
- Health, dental, and vision care for you and your family
- Life insurance
- Mental wellness coverage
- Fertility and growing family support
- Flex Time Off in addition to company-paid holidays
- Paid family leave, medical leave, and bereavement leave policies
- Retirement savings plans
- Allowance to customize your work and technology setup at home
- Annual professional development stipend
Compensation
Your recruiter can provide additional details about compensation and benefits.
Company info
About Juniper Square
Private markets are one of the largest, most complex, and most underserved corners of global finance. Our mission at Juniper Square is to unlock their full potential. We’re the Operations Partner trusted by 2,300+ GPs, unifying technology, data, and fund administration services into a single platform that helps GPs move