P

Senior Analytics Engineer

Pandadoc
21 days ago
Full-time
Remote
Worldwide
Remote Data

We're looking for a Senior Analytics Engineer to join our data team at PandaDoc. In this role, you'll be at the intersection of data engineering and analytics, building the foundational data models and infrastructure that power insights across the organization. You'll work closely with data analysts, business stakeholders, and engineering teams to transform raw data into trusted, accessible datasets that drive strategic decisions around customer success, revenue growth, and product development.

About the PandaDoc Data Platform:

You'll be working with a best-in-class modern data stack that reflects industry-leading practices. Our infrastructure is built on Snowflake as our cloud data warehouse, with dbt powering our transformation layer and Select Star providing comprehensive data cataloging and discovery. We've implemented robust data governance practices including PII auditing and data quality monitoring via Monte Carlo. Our platform integrates data from across the businessโ€”including Salesforce, HubSpot, Recurly, and our product databasesโ€”creating a unified view of customer journeys, subscription metrics, and product usage. We're actively exploring cutting-edge technologies like composable CDPs, reverse ETL with Hightouch, and event analytics with PostHog. The data team has a strong partnership with business stakeholders, regularly delivering high-impact analyses that drive decisions around customer expansion, payment gateway adoption, and product strategy. You'll have the autonomy to influence our architecture decisions and help shape our evolution toward an AI-enabled, domain-oriented data organization.

What You'll Do:

  • Design, build, and maintain dimensional data models in Snowflake that serve as the foundation for analytics and reporting across the company
  • Develop and optimize dbt models to transform raw data from systems like Salesforce, HubSpot, Recurly, and other business platforms into clean, reliable datasets
  • Create and maintain data documentation in Select Star and other catalog tools to ensure discoverability and understanding of our data assets
  • Partner with data analysts and business teams to understand their analytical needs and translate them into scalable data solutions
  • Implement data quality checks and monitoring to ensure accuracy and reliability of analytics datasets
  • Optimize SQL queries and data pipelines for performance and cost efficiency
  • Support strategic analytics initiatives including customer journey analysis, revenue analytics, and product usage metrics
  • Contribute to data governance practices including data quality standards, PII handling, and metadata management