Senior Business Analytics Engineer - India
Juniper Square30 days ago
India (city not specified)Senior
Responsibilities
- Own dbt models for revenue and customer data sourced from CRM, CPQ, billing, and ERP systems.
- Model the lifecycle from quote through order, provisioning, invoice, and recognized revenue at the entity and service grain.
- Define and govern certified ARR, CARR, backlog, and related revenue metrics in a semantic layer.
- Document, test, and maintain metric definitions and lineage so people and AI agents receive consistent answers.
- Reconcile revenue metrics with NetSuite data and Finance close processes.
- Translate requirements from Sales, Finance, Fund Administration, and leadership into precise technical specifications for Data Engineering.
- Build AI-assisted reporting on governed semantic definitions and create self-service dashboards for revenue, operations, and leadership.
- Establish measurement for the Lead-to-Cash program and apply access controls, data classification, and change management for financial and customer data.
- Partner with business systems and integrations teams to ensure commercial models and source data are reportable from the start.
Requirements
- At least 5 years of experience in analytics engineering, data engineering, or business intelligence, including at least 2 years owning production dbt models.
- Expert SQL skills, including window functions, CTEs, performance tuning, and working with legacy queries.
- Hands-on dbt experience with models, tests, documentation, incremental models, and CI.
- Experience with a semantic-layer tool such as dbt Semantic Layer/MetricFlow, LookML, Cube, or similar.
- Strong understanding of ARR, CARR, bookings, backlog, churn, billing, and revenue recognition.
- Practical data modeling experience with dimensional modeling, slowly changing dimensions, and explicit grain.
- Experience working with Salesforce and NetSuite data.
- Experience with a cloud data warehouse such as Redshift, Snowflake, BigQuery, or similar.
- Regular use of AI coding and data tools such as Claude.
- Ability to work directly with US-based Finance and business stakeholders with some overlap with US time zones.
- Python experience for transformation logic, automation, or API-based extraction is preferred.
- Experience with Looker, Tableau, Power BI, or Sigma is preferred.
- Exposure to fund administration, private markets, or financial services is preferred.
- Experience building AI-ready data products or metrics that agents can query is preferred.
- Understanding of governance and control ownership for revenue and customer data changes is preferred.
Benefits
- Health, dental, and vision care for employees and families.
- Life insurance and mental wellness coverage.
- Fertility and growing family support.
- Flexible time off in addition to company-paid holidays.
- Paid family, medical, and bereavement leave.
- Retirement savings plans.
- Allowance to customize a home work and technology setup.
- Annual professional development stipend.
- Flexible work options ranging from fully remote to working in a physical office, with offices in Mumbai and Bangalore among other locations.
About Juniper Square
Juniper Square builds software and provides fund administration for private markets general partners, including real estate, private equity, and venture firms. Its SaaS platform supports fundraising, investor onboarding, compliance, treasury, reporting, and LP communications, with optional administration services and applied-AI tools integrated into clients’ systems. Founded in 2014 and headquartered in San Francisco, it is privately held and used by more than 2,000 GPs worldwide.