FTI System Analyst (Data Analyst - Business Intelligence)

Lexington Partners is one of the world’s largest and most trusted managers of secondary private equity and co-investment funds. Since our founding in 1994, we’ve been at the forefront of innovation in private equity investing, managing over $70 billion in committed capital and partnering with a global network of institutional investors, private equity firms, and portfolio companies.

As a Systems Analyst – Business Intelligence on the Data & AI team at Lexington Partners, you will contribute to delivering business intelligence and data analytics solutions that drive meaningful business impact. The ideal candidate has a growth and learning mindset, is detail-oriented, and possesses strong analytical skills to navigate complex challenges. You should be comfortable working in a fast-paced, startup-like environment within an established enterprise and able to quickly adapt to new tools and solutions. You will play a pivotal role in the firm’s business intelligence initiatives enabling data-driven decision-making.

Key Responsibilities:

• Build dashboards and analytics using Power BI, Power Query, and related tools in the ecosystem.

• Collaborate closely with Finance and Technology teams to deliver BI solutions.

• Perform system administration of Business Intelligence platforms (e.g., Power BI), including user security management and maintenance.

• Own regular and ad hoc operational reporting, driving continuous improvement and scalability.

• Work collaboratively with various business functions to understand reporting needs and deliver actionable insights.

• Develop and maintain scalable, automated dashboards and reports to benchmark and track progress against key operational goals and initiatives.

• Perform data modeling by modifying existing models or creating new ones as needed.

• Assist end users in building ad hoc reports through BI tools.

What ideal qualifications, skills & experience would help someone to be successful?

• Bachelor’s degree in Business Administration, Finance, Information Management, Computer Science, or a related field.

• Strong attention to detail and analytical thinking skills. Must be a gate-keeper for high data quality.

• Proficiency in SQL, PowerBI, PowerQuery, ETL techniques. 

• Experience in Microsoft Azure and Power Platform is a plus.

• Knowledge of Snowflake is good to have.

• Versatile and Effective Communicator – able to interact with diverse group of individuals with very different styles and back grounds.

• Ability to implement row-level security on data and a strong understanding of application security layer models in Power BI.

• Capable of working independently as well as in a team-oriented environment.

• Excellent written and verbal communication skills, with a collaborative and ownership-driven mindset.

Work Shift Timings - 2:00 PM - 11:00 PM IST