Analytics / Data Engineer

About the department

Data & Analytics is the function that turns raw business data into decisions. We own the data platform, product analytics, marketing attribution, and revenue operations analytics. Our current priority is building reliable data infrastructure that supports both day-to-day reporting and the next wave of AI-driven workflows at PFM.

About the role

Own and scale the core data platform that powers reporting, attribution, product analytics, reconciliation, AI workflows, and company-wide decision-making at PFM. Turn fragmented raw data into reliable, reusable business intelligence layers that enable faster decisions and scalable automation.

Performance objectives

Objective 1 - Own the data platform foundation

• Own BigQuery warehouse architecture and dbt models.
• Manage Airbyte pipelines and tracking infrastructure.
• Apply orchestration tools (e.g., Airflow) for recurring workflows.
• Monitor pipeline reliability and address breakages.

Objective 2 - Build reliable business data models

• Model revenue and commission flows end-to-end.
• Model product funnels for conversion analysis.
• Model partner performance for the Revenue Operations team.
• Build executive reporting layers.

Objective 3 - Improve data quality and reduce manual work

• Implement governance, permissions, monitoring, and alerting.
• Automate recurring reports and reconciliations.
• Enable self-service analytics for non-technical stakeholders.
• Improve documentation and discoverability of warehouse tables.

Objective 4 - Enable AI workflows and new integrations

• Integrate QuickBooks, CRM, support, social, and operational systems.
• Support AI enablement (Claude / internal AI assistants) with structured data.
• Use AI-assisted coding workflows to speed development.
• Partner with Engineering on integration architecture.

Requirements

What we look for

• 3+ years of experience as a Data Engineer or Analytics Engineer.
• Strong SQL and warehouse modelling skills (dbt, BigQuery preferred).
• Data pipeline engineering experience (Airbyte, orchestration, monitoring).
• Comfortable with workflow orchestration tools (Airflow or similar).
• Strong data governance, quality, and documentation mindset.
• Excellent async written communication - we are remote-first.