Data Impact Analyst

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: Contribute to web app development (frontend/backend); 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