Data Analytics, Associate Director (BLR)

Alchelyst group; Bengaluru; On-site; INR 4,000,000 - 8,000,000; Full time

Job summary

Alchelyst group is seeking a seasoned Associate Director to lead and deepen PE fund accounting systems capabilities in Bengaluru. The role requires 15+ years in alternative investments, strong SQL, and exposure to LemonEdge and Investran.

You will drive data architecture, reporting, and system implementations across PE, real assets, and credit strategies. You will partner with clients and internal teams, oversee reporting cycles, and mentor junior staff, while shaping platform roadmap and

Qualifications

• 15+ years in alternative investments focusing on PE fund administration and reporting.
• Deep knowledge of PE fund structures, capital activity, NAV, waterfalls, and LP reporting.
• Advanced SQL skills with complex queries, tuning and validation.
• Experience with LemonEdge and/or Investran preferred.
• Knowledge of PE data architecture, ETL/data integration, and automated reporting.
• Strong analytical and problem‑solving abilities; able to troubleshoot complex data issues.
• Experience leading system implementations, migrations, or optimisations in alt investments.
• Excellent stakeholder management and ability to translate tech concepts for business audiences.
• Preferred: Power BI, Tableau, Python or PowerShell; exposure to Real Estate, Infra, Credit assets.

Responsibilities

• Lead PE fund accounting workflows and reporting cycles for accuracy and timeliness.
• Quality‑assure LP statements, capital accounts and management reports.
• Guide LemonEdge data architecture and integration with other platforms.
• Define data import/export patterns and automated reconciliation routines.
• Collaborate with clients and internal teams to translate requirements into solutions.
• Lead upgrades, patches, and migration projects; provide technical leadership.
• Write and maintain SQL datasets, views, procedures powering reporting.
• Develop data governance, quality standards and documentation.
• Mentor junior analysts and associates across fund accounting and data teams.

Skills

Advanced SQL

PE fund accounting

LemonEdge

Investran

Stakeholder mgmt

Data architecture

ETL

Power BI/Tableau

Python/PowerShell

Tools

LemonEdge

Investran

Power BI

Tableau

Python

PowerShell

Job description

Data Analytics, Associate Director (BLR)

Alchelyst is a client solutions and infrastructure partner for private markets asset managers. Purpose-built for the expanding demands and sophistication of global private markets, the firm offers a comprehensive managed service offering that can support GPs, private wealth funds and investors. Alchelyst has offices in the US, Ireland, UK, Luxembourg and India.

We are seeking a seasoned Associate Director with 15+ years of experience in the alternative investment industry to lead and deepen our fund accounting systems capabilities. The ideal candidate brings deep expertise in Private Equity fund administration and PE reporting, strong hands‑on SQL programming skills, and meaningful exposure to portfolio accounting platforms—particularly Investran and LemonEdge. This is a senior, high‑impact role that sits at the intersection of PE operations, data architecture, and system implementation.

• Serve as the senior subject matter expert on Private Equity fund administration workflows, including capital calls, distributions, waterfall calculations, NAV reporting, and investor accounting.
• Oversee and quality‑assure PE fund reporting cycles, ensuring accuracy, completeness, and timeliness of LP statements, capital account statements, and management reports.
• Partner with fund accounting operations teams to evaluate and continuously improve reporting processes, leveraging deep knowledge of PE accounting standards and fund structures.
• Act as the primary escalation point for complex fund accounting issues across PE, real assets, and credit strategies.
• Collaborate with clients and internal stakeholders to gather requirements and translate them into actionable system and data solutions.
• Develop a thorough understanding of LemonEdge’s system architecture, data model, and configuration framework in order to guide implementation and optimisation efforts.
• Design and build the data layer for LemonEdge—including SQL‑based datasets, data sources, inbound data feeds, and outbound reporting extracts—to support fund accounting workflows and downstream consumption.
• Define and implement data import/export strategies, integration patterns, and automated reconciliation routines within LemonEdge and connected systems.
• Exposure to accounting system’s configuration, reporting, and data extraction activities, applying equivalent depth of understanding to both platforms.
• Evaluate new system capabilities, patches, and vendor roadmaps; provide technical leadership on upgrade and migration projects.
• Write, optimise, and maintain complex SQL queries, stored procedures, views, and data extraction routines that power fund accounting reporting and operational workflows.
• Architect SQL datasets and data sources within LemonEdge and across integrated platforms, ensuring structural integrity, performance, and alignment with business reporting requirements.
• Lead data reconciliation, validation, and root‑cause analysis activities, resolving discrepancies across fund accounting systems and downstream data consumers.
• Define and enforce data quality standards, governance controls, and documentation practices across the data layer.
• Identify and implement opportunities to automate manual data processes through SQL‑driven workflows and integration logic.

Leadership & Stakeholder Management

• Provide thought leadership on fund accounting systems strategy, advising senior management on platform roadmap, architecture decisions, and technology investments.
• Mentor and develop junior analysts and associates across fund accounting and systems teams.
• Manage relationships with system vendors (including LemonEdge and Investran) and third‑party implementation partners.
• Lead cross‑functional projects involving operations, technology, compliance, and client services teams.
• Document technical solutions, business processes, data dictionaries, and operational procedures to enable knowledge transfer and scalability.

Qualifications & Experience :

• 15+ years of experience in alternative investments, with deep expertise in Private Equity fund administration, accounting, and investor reporting.
• Strong understanding of PE fund structures, accounting principles, reporting cycles, capital activity, NAV, waterfalls, and LP reporting.
• Advanced SQL skills, including complex queries, stored procedures, performance tuning, and data validation.
• Experience with fund administration and portfolio accounting platforms; exposure to LemonEdge and/or Investran is highly preferred.
• Knowledge of fund accounting data architecture, ETL/data integration workflows, and automated reporting processes.
• Strong analytical and problem‑solving skills with the ability to troubleshoot complex data and system issues.
• Proven experience leading or supporting system implementations, migrations, or optimisation projects within alternative investments.
• Excellent stakeholder management and communication skills, with the ability to translate technical concepts for business and client audiences.
• Preferred: Experience with Power BI, Tableau, Python, or PowerShell, and exposure to Real Estate, Infrastructure, Credit, or other alternative asset classes.

What Success Looks Like:

• You have developed a deep, working knowledge of LemonEdge’s system architecture—including its data model, entity relationships, and configuration framework—enabling you to make authoritative decisions on how data flows in and out of the platform.
• The LemonEdge data layer is fully architected and operational: SQL datasets and data sources are well‑structured, performant, and reliably serve fund accounting workflows, operational reporting, and downstream data consumers.
• Inbound data feeds and outbound reporting extracts are automated, validated, and consistently accurate—reducing manual intervention and eliminating reconciliation breaks before they reach operations or clients.
• Fund accounting data across PE portfolios is consistently accurate, reconciled, and available on time for LP reporting, management reporting, and audit requirements.
• System capabilities are well‑documented, scalable, and positioned to support business growth—with clear data governance, defined processes, and an architecture that can absorb new funds, strategies, and integrations without rework.