Data Analyst - Data Operations

Posted 2 Days Ago
Dallas, TX, USA
In-Office
Junior
Financial Services
The Role
Join operations team to build, maintain, and monitor ETL/ELT pipelines for private asset financial data. Write Python scripts and SQL queries, apply AI tools for extraction and validation, automate Excel-heavy workflows, perform QA/testing, document processes, and support timely client data delivery while ensuring governance and cross-functional communication.
Summary Generated by Built In

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

Skills Required

  • 0-3 years of experience in a data, analytics, or operations role
  • Hands-on experience with Python (data processing/automation)
  • Working knowledge of SQL (querying, transform, validation)
  • Familiarity with ETL/ELT concepts and data pipeline fundamentals
  • Proficiency in Excel and/or Power Query for data manipulation
  • Exposure to AI-based data tools or curiosity about applying AI to workflows
  • Understanding of financial data (fund accounting, investment data, financial statements)
  • Strong attention to detail and commitment to data quality
  • Ability to communicate clearly with technical and non-technical colleagues
  • Bachelor's degree in Finance, Business Analytics, Data Science, Computer Science, or related field
  • Authorized to work for any employer in the U.S. (no visa sponsorship)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Dallas, TX
41 Employees
Year Founded: 2011

What We Do

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 [email protected] or visit www.lpanalyst.com Follow on Twitter: @LPAnalyst Connect on LinkedIn: www.linkedin.com/in/billfarrell3 www.linkedin.com/in/katitapalamar

Similar Jobs

Agero Logo Agero

Data Analyst

Automotive • Big Data • Insurance • Software • Transportation
Easy Apply
Remote or Hybrid
14 Locations
1600 Employees
110K-135K Annually
In-Office
Dallas, TX, USA
1621 Employees
61K-79K Annually
In-Office
Arlington, TX, USA
1621 Employees
61K-79K Annually
In-Office or Remote
2 Locations
121 Employees

Similar Companies Hiring

Granted Thumbnail
Mobile • Insurance • Healthtech • Financial Services • Artificial Intelligence
New York, New York
23 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account