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.
PE Fund Administration & Reporting
- 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.
LemonEdge & Portfolio Accounting Systems
- 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.
SQL Development & Data Architecture
- 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.
