Systems Engineer, Data Platform & Integrations

Pavilion

1d•Remote

About The Position

Pavilion is seeking a Systems Engineer to manage the connections between its core business systems, data warehouse, and customer access logic. This role involves overseeing data flow for critical functions such as sales, payments, product operations, and reporting. The engineer will be responsible for building and maintaining integrations, pipelines, models, and entitlement logic to ensure data accuracy and reliability for customer, subscription, payment, engagement, and revenue data. This is a hybrid role encompassing data platform, backend systems, and business systems architecture, requiring proficiency in Python and SQL, comfort with APIs and webhooks, an understanding of SaaS system integration, and the ability to make independent architectural decisions.

Requirements

10+ years of experience in systems engineering, data engineering, analytics engineering, backend engineering, or business systems engineering.
Strong Python experience for building integrations, pipelines, APIs, automations, or backend services.
Advanced SQL and experience with modern data warehouses (e.g., Snowflake)
Prior ownership of operational databases such as AWS RDS, Postgres, or similar.
Experience building and maintaining integrations with third-party SaaS tools (e.g., Slack, Hivebrite, Circle, Notion, etc.)
Strong understanding of APIs, webhooks, event-driven workflows, and data synchronization.
Experience with payment, subscription, and CRMs is required; Stripe experience or ability to demonstrate deep understanding of Stripe documentation is necessary.
Strong documentation habits and clear communication with technical and non-technical stakeholders.
Ability to make sound, scalable architecture decisions in a fast-moving environment.

Nice To Haves

Familiarity with Hubspot API and prior exposure to subscription businesses is highly preferred
Demonstrated skills creating entitlement systems, access-control logic, or subscription-based products is ideal; ability to incorporate automated workflows into the logic will also be critical.

Responsibilities

Validate and implement the next chapter of Pavilion’s system architecture
Own integrations across core systems, including systems like Stripe, HubSpot, Hivebrite, Slack, Snowflake, AWS RDS or similar, and other third-party tools.
Design and maintain reliable data flows between operational, product, sales, and financial systems, including entitlement logic and payments workflows.
Build and maintain pipelines, transformations, and data models for customer, subscription, payment, revenue, engagement, and access data.
Own the technical layer for entitlements and customer access logic.
Support system migrations and new tool implementations, including data mapping, QA, and downstream reporting impacts.
Improve data quality, freshness, observability, testing, and monitoring.
Document architecture, source-of-truth decisions, data definitions, and system workflows.
Partner with Operations, Sales, Marketing, and Finance to translate business needs into scalable technical solutions and write requirements independently.
Communicate tradeoffs clearly and balance speed with long-term maintainability.