Data Impact Analyst

TrueBridge Capital Partners; Chapel Hill (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

TrueBridge Capital Partners is seeking a Data Impact Analyst to join the Operations Team in a full-time role. The candidate will work under the Data Impact Manager, writing SQL, building dbt models, and maintaining GitHub Actions workflows, with responsibilities spanning data quality, analytics views, and app development.

Ideal candidates have experience with SQL, dbt, Snowflake, and associated data engineering tools, and a comfort with cloud-based data platforms.

Qualifications

• Proficient in writing complex SQL queries with multi-joins and window functions.
• Experience or education around dbt modeling and transformation.
• Familiarity with Docker for containerized apps and GitHub-based CI/CD workflows.
• Experience with Snowflake features like Snowpark and secure views is a plus.

Responsibilities

• Maintain and extend the layered SQL architecture in Snowflake.
• Write and optimize SQL for staging tables and data enrichment.
• Build and maintain analytics views and dbt models across layers.
• Configure dbt profiles for Snowflake connectivity and routing.
• Contribute to web app development and client-side data aggregation logic.
• Monitor data pipeline health and support incident response.

Skills

SQL

Python

GitHub Actions

Docker

Data modeling

Tools

dbt

Snowflake

Snowpark Container Services

Git

Job description

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

• 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
• 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

• 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