Data Analyst - Data Operations

LP Analyst

Posted 3 months ago

Full Time

Dallas, Texas

In Person

Smart Summary

Responsibilities

The Data Analyst will build and maintain ETL/ELT pipelines to collect and transform financial data while automating manual workflows. They will also ensure data quality through validation, SQL querying, and effective communication with internal teams.

Qualifications

We are looking for a detail-oriented Data Analyst to join our operations team. The ideal candidate will have 0-3 years of experience, proficiency in Python and SQL, and a Bachelor's degree in a relevant field. Strong communication skills and a commitment to data quality are essential.

Job Description

Company Overview

LP Analyst is a leading independent private asset cloud-based analytics and consulting solutions firm that works closely with many of the industry’s most prominent institutional investors (LPs) and fund managers (GPs) to get better, more actionable decision-making intelligence into the hands of today’s demanding investors.
 
Our firm truly sits at the intersection of private asset analytics and consulting which means we take both a highly quantitative and qualitative approach to tackling big challenges and developing cutting-edge solutions for our clients. For our analyst team, this means not only getting into the details when working with large amounts of private asset data across a wide range of strategies but also an opportunity to synthesize this information, through the firm’s proprietary reporting and analytics platform, for key decision makers at our clients’ investment programs, including private asset class leads and chief investment officers.

If you are a high achiever with a passion for learning about the private asset analytics and consulting landscape while also being part of a strong, motivated and innovative team of forward-thinking professionals, LP Analyst might be the right place for you.

LP Analyst encourages and promotes diversity within its team. Women, minorities, people with disabilities, veterans and members of all underrepresented groups are strongly encouraged to apply.

Job Summary 

LP Analyst is seeking a detail-oriented and technically motivated Data Analyst to join our operations team. In this role, you will work alongside a collaborative team responsible for the collection, processing, and delivery of financial data to our clients. You will contribute directly to the automation and ETL workflows that power our data pipelines, helping to build, maintain, and improve the systems that move financial data reliably and at scale. 

This role is well-suited for someone who is comfortable working with data at a technical level — writing Python scripts, querying databases, and supporting pipeline automation — while also understanding the financial data context that underpins our work. You will be embedded within our operations team and will play a hands-on role in day-to-day execution alongside your teammates. 

Key Responsibilities 

  • Support the build-out and maintenance of ETL/ELT pipelines that collect, transform, and load financial data from multiple sources into our internal platform, ensuring accuracy and completeness 
  • Leverage AI-based tools for automated data extraction and validation, helping to assess output quality and flag exceptions that require review or correction 
  • Write and optimize SQL queries to support data transformation, validation, and quality assurance across our internal data platform 
  • Identify manual, Excel-heavy workflows and assist in transitioning them to automated, repeatable solutions 
  • Monitor pipeline performance and data quality, flagging and resolving issues to ensure accurate and timely client data delivery 
  • Interpret varied reporting formats and practices across private capital strategies, applying judgment to ensure data is accurately captured and consistently represented regardless of source format 
  • Communicate effectively with team leads, senior colleagues, and non-technical teammates, translating technical processes and findings into clear business terms and escalating issues through appropriate channels 
  • Contribute to documentation of pipelines, data flows, and processes to build shared knowledge across the team 
  • Assist in testing and QA of new pipeline builds and enhancements before deployment 
  • Respond to ad hoc data requests from internal teams, pulling and summarizing data as needed to support day-to-day business operations 
  • Adhere to data governance standards including naming conventions, data definitions, and data integrity practices, with an awareness of the accuracy and compliance expectations of a financial services environment 
  • Work collaboratively with cross-functional teams, including client services, to meet service-level agreements and data delivery deadlines, adapting to shifting priorities in a deadline-driven environment 

Qualifications and Skills 

  • 0–3 years of experience in a data, analytics, or operations role 
  • Hands-on experience with Python, including writing scripts for data processing or automation 
  • Working knowledge of SQL, including writing queries to extract, transform, and validate data 
  • Exposure to AI-based data tools or a demonstrated curiosity about applying AI and automation to data workflows 
  • Familiarity with ETL/ELT concepts and data pipeline fundamentals 
  • Proficiency in Excel and/or Power Query for data manipulation and analysis 
  • Understanding of financial data — fund accounting, investment data, or financial statements experience — is a plus 
  • Strong attention to detail and a genuine commitment to data quality 
  • Ability to work collaboratively within a team and communicate clearly with both technical and non-technical colleagues 
  • Bachelor's degree in Finance, Business Analytics, Data Science, Computer Science, or a related field 
  • Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa for this position 
Why LP Analyst?
  • Comprehensive onboarding and training programs, including a structured Private Asset Training Program and regular business/industry teach-ins
  • Early opportunities for advancement for top-performing analysts
  • Opportunity to build valuable professional skills early in your career, including communication, organization, and leadership, by working on a dynamic and growing team with cross-functional exposure
  • Exposure to a wide range of strategies (private equity, venture capital, real estate, infrastructure, credit), with the opportunity to specialize in areas of interest
  • High-impact role providing transparency to the world’s leading institutional investors
  • Collaborative, high-performing team culture with smart, supportive colleagues
  • Company-sponsored 401(k) plan, healthcare, and dental insurance
  • Competitive compensation and fully paid parental leave
  • Generous paid time off that increases with tenure, plus an annual volunteer day
  • Casual dress code, frequent team events, and a downtown Dallas office with paid parking, free snacks, and other perks

LP Analyst

LP Analyst is the source for independent advisory and analysis solutions for the private equity investment community. The firm supports limited partners, general partners, and advisors with data-driven, actionable analyses to support decision making and enhance returns. LP Analyst’s founders have worked together for more than 10 years, advised on more than $50B in assets, and leverage backgrounds in investment banking, consulting, and secondary advisory. For more information, contact Bill Farrell at bfarrell@lpanalyst.com or visit www.lpanalyst.com Follow on Twitter: @LPAnalyst Connect on LinkedIn: www.linkedin.com/in/billfarrell3 www.linkedin.com/in/katitapalamar
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria