Descriptive Summary
TrueBridge Capital Partners is seeking a Data Impact Analyst to fill a full-time position on its Operations Team. Reporting to the Data Impact Manager, the Data Impact Analyst is a self-motivated, multi-talented and well-rounded individual who desires to be a key part of the data team in a dynamic and fast-growing company. The ideal candidate has experience or education around writing SQL, building dbt models, maintaining GitHub Action workflows and contributing to web application development.
About TrueBridge
TrueBridge is a leading venture capital investor located in Chapel Hill, NC with $10 billion under management. The firm invests in venture funds as well as directly in high-growth private technology companies such as SpaceX, Stripe, Databricks, Slack, Instacart, and Cribl. TrueBridge has a partnership with Forbes and co-produces several marquee annual venture capital rankings including the Midas List of top technology venture investors and the Next Billion-Dollar Startups, a list of the fastest-growing next-generation tech companies. TrueBridge is a cohesive team of experienced professionals with an entrepreneurial spirit and collaborative culture.
Key Responsibilities
SQL & Data Pipeline Development
- Maintain and extend the layered SQL architecture in Snowflake
- Write and optimize SQL for staging tables that handle amount cleaning, entity enrichment, and graph resolution
Build and maintain analytics views
dbt Modeling & Transformation
- Develop and maintain dbt models organized across staging, intermediate, and marts layers
- Manage dbt seeds and snapshots for tracking historical changes to reference data
- Write dbt tests and documentation to ensure data quality and discoverability
- Configure and maintain dbt profiles for Snowflake connectivity, including schema routing
Web Application Development & Maintenance
- Frontend/ Backend: Contribute to web app development
- Implement client-side aggregation logic including IRR calculations, commitment/unfunded computations, and as-of-date filtering across cached data arrays
- Write and maintain frontend and backend tests to ensure reliability
CI/CD & Infrastructure
- Maintain and improve GitHub Actions workflows for automated testing, Docker image builds, and deployment to Snowpark Container Services
Data Quality & Operations
- Monitor data pipeline health, investigate discrepancies in fund performance metrics, and troubleshoot issues across the SQL/dbt/app stack
- Support incident response procedures, service rollbacks, and audit log review
Required Qualifications
- 1–5 years of professional experience in data analytics, analytics engineering, data engineering, or a related technical role
- Understanding of relational data modeling concepts, particularly around hierarchical/graph structures
- Strong attention to detail and ability to trace data lineage across layered architectures
Proficiency in Python
- Strong SQL skills with experience writing complex queries involving multi-table joins, window functions, CTEs, and conditional aggregation
- Familiarity with Docker for building and deploying containerized applications
- Experience with Git and GitHub-based workflows: branching, pull requests, code review, and CI/CD via GitHub Actions
Preferred Qualifications
- Experience with dbt core, or similar transformation tools for managing SQL transformation pipelines, including models, seeds, snapshots, and tests
- Experience with Snowpark Container Services or AWS EKs/similar cloud hosting platforms
- Familiarity with Snowflake-specific features: Snowpark Container Services, secure views, result caching, OAuth authentication, and role-based access control
- Working knowledge of JavaScript/React. Comfort with JSX, React hooks, and basic D3 visualization
- Knowledge of financial metrics and calculations: NAV, IRR, TVPI, DPI, capital contributions, distributions, and unfunded commitments
- Familiarity with Vite as a frontend build tool
Education, Experience and Attributes
Bachelor’s degree
- Experience building or maintaining internal tools and dashboards for business stakeholders
- Ability to self-direct and juggle multiple competing tasks and demands
- Excellent verbal and written communications skills
- Adapts to frequent change with a proactive, professional and assertive attitude
- Experience in the financial services or investment management industry, particularly venture capital, private equity, or fund-of-funds