Senior Business Analytics Engineer - India

The role

This role produces computed metric definitions for Sales, Finance, Fund Admin, and leadership teams. You will own dbt transformation logic and semantic-layer definitions on an internal data warehouse. You will also build an AI-assisted reporting layer and translate business questions into technical requirements.

What you will do

• Own dbt models for revenue and customer data from CRM, CPQ, billing, and ERP systems
• Model the chain from quote to recognized revenue
• Move reporting-level data generation from Salesforce into the warehouse
• Define and govern certified metrics like ARR and CARR
• Write definitions for people and AI agents backed by documentation, tests, and lineage
• Reconcile metrics with NetSuite and the Finance close
• Translate business questions into technical requirements for Data Engineering
• Work with Lead Business Systems Analyst and Integrations Engineers
• Build an AI-assisted reporting layer and self-serve dashboards
• Apply access controls and change management for SOX, SOC 1, and SOC 2 scope

Required qualifications

• 8+ years in analytics engineering, data engineering, or business intelligence
• At least 2 years owning dbt models in production
• Expert SQL: window functions, CTEs, performance tuning, and working through legacy queries
• 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)
• 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

Benefits

• 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

About the company

Juniper Square is an Operations Partner for private markets that unifies technology, data, and fund administration services. The company is founder-led and provides a platform for over 2,300 GPs and 700,000+ LPs.