~/portfolio · nathan.sql
snowflake · connected
01
02
03
04
05
06
07
08
transitioning into analytics engineering

Turning operational complexity into data-driven insight.

I'm Nathan Sinclair — a fintech operations leader working at the intersection of operations and analytics engineering. I lead teams, design dbt models, and build the dashboards and automations behind portfolio performance at scale.

10+
yrs in fintech ops
accounts per FTE
60%
ticket volume cut
Nathan Sinclair
SELECT * FROM nathan 1 row
-- about

An operator learning to think in queries.

I spent the last decade running collections, recovery, and client-experience teams at PayBright (Affirm), Wealthsimple, and Fig Financial — building the operational systems that keep fintech portfolios healthy.

Along the way I got tired of waiting on dashboards to answer questions my team needed today. So I picked up the stack — SQL, dbt, Snowflake, and modern BI — and started shipping the models, metrics, and pipelines myself. It made me a sharper operator and a better partner to the data and engineering teams I work with.

Today I sit at the intersection of operations and analytics engineering — leading teams, owning portfolio outcomes, and building the data layer underneath them. Whether the next role is operator, analytics engineer, or somewhere in between, the through-line is the same: turn messy reality into systems and numbers people can act on.

profile.yml
name: Nathan Sinclair
location: Toronto, Canada
role: Sr. Manager, Resolutions
  @ Fig Financial
focus:
  - analytics_engineering
  - dbt + snowflake
  - operational_data_modeling
learning:
  - advanced_dbt (macros, incremental
    models, snapshots, testing)
  - data_modeling_patterns
  - data_observability
committees:
  - risk_management
ships: dashboards, models,
  vendor programs, teams
-- skills

The toolkit behind the work.

Where ten years of operational pattern recognition meets a modern data stack.

Data & Analytics

SQLSnowflakeBigQuerydbt CloudFivetranMySQLpgAdminRegexExcel

BI & Visualization

LookerTableauSisenseMetabasePeriscopePresetSigmaZendesk Explore

AI & Automation

WorkatoZapiern8nMakeOpenAIClaudeGeminiLovable

Analytics Engineering

dbt ModelsData ModelingELT/ETLGit/GitHubAPIsDashboards

Operations & Strategy

Process OptimizationVendor MgmtRisk & ComplianceKPI DesignWorkforce Strategy

Leadership & Collaboration

Team BuildingCoachingStakeholder MgmtCross-Functional DeliveryHiringMentorship
-- experience

A decade of measurable outcomes.

Each role solving the same problem at a different scale: how do you turn messy operational data into decisions the business can trust?

Senior Manager — Resolutions & Recovery

@ Fig Financial
Jan 2024 — Present · Toronto, Canada · Subsidiary of Fairstone Bank
  • Designed dbt models tracking hardship treatments, repayment outcomes, and vendor performance; partnered with Analytics Engineering to productionize dashboards.
  • Scaled managed accounts per FTE 5× through new segmentation models, workflow automation, and refined KPI monitoring.
  • Launched segmented customer treatment strategies that reduced roll rates by 10% with measurable improvements in net write-off (NWO).
  • Member of the Risk Management Committee; partner with the CRO and Head of Legal on collections policy and governance.
  • Piloted GenAI tooling and workflow automation (Workato, Zapier, n8n, Make) to remove manual effort from reporting, QA, and vendor reconciliation.
dbtSnowflakeSQLLookerRiskBPO

Team Lead — Client Experience Risk

@ Wealthsimple
Feb 2022 — Jan 2024 · Toronto, Canada · 2M+ client fintech platform
  • Built SQL- and Periscope-based dashboards to identify bottlenecks and optimize agent performance across Client Support Risk.
  • Analyzed support and fraud data to cut Velocity Monitor ticket volume by 60%, reducing false positives and agent toil.
  • Co-led Wealthsimple's first Account Opening BPO initiative, freeing internal bandwidth for high-touch work.
  • Partnered with Fraud, Compliance, and CX leadership to refine routing logic — improving resolution speed.
SQLPeriscopeZendeskFraud Ops

Team Lead — Resolutions

@ PayBright / Affirm
Feb 2019 — Feb 2022 · Toronto, Canada · Buy-now-pay-later fintech
  • Owned end-to-end resolutions and recovery workflows; used SQL, Zendesk Explore, and Looker to track performance and drive continuous improvement.
  • Led CRM migration from Zendesk to Salesforce — improved data integrity, reporting accuracy, and cross-functional visibility.
  • Built PayBright's first BPO program with CBCC, ARO, and Indebted; scaled volume by 80% through training, SOPs, and QA frameworks.
SQLLookerSalesforceProcess Design

Corporate Trainer

@ Teleperformance
Apr 2018 — Feb 2019 · Toronto, Canada · Sprint Mobile (US telecom) program
  • Designed and delivered new-hire and continuous-education training for call-centre agents supporting Sprint Mobile, a major US telecommunications provider.
  • Built training content, knowledge checks, and QA rubrics that lifted agent ramp speed and first-call resolution.
  • Partnered with operations and quality leadership to translate performance data into targeted coaching plans.
TrainingCall Center OpsQACoaching
-- projects

Things I've shipped.

A mix of production work, side experiments, and learning projects. More on GitHub.

private

fct_collections_performance

dbt model unifying hardship treatments, repayment outcomes, and vendor SLAs into a single fact table powering portfolio dashboards.

dbtSnowflakeSQLFivetran
private

Roll-Rate Segmentation Engine

Segmentation logic + dashboards quantifying treatment impact across delinquency buckets — drove a 10% reduction in roll rates.

SQLLooker
private

Vendor Reconciliation Automation

Workato/n8n pipeline replacing weekly manual reconciliation across 5 BPO partners. Outputs land in Snowflake for downstream reporting.

Workaton8nSnowflakeRegex
private

Velocity Monitor BI Suite

Periscope dashboards diagnosing false-positive volume in fraud-flagged tickets — informed routing changes that cut volume 60%.

PeriscopeSQLZendesk Explore
private

GenAI QA Co-Pilot

Prompt-driven QA assistant that scores agent transcripts against compliance rubrics — piloted across two BPO programs.

OpenAIClaudeMakeNotion
public

canadian-immigration-economic-analysis

Exploratory data analysis tying Canadian immigration flows to economic indicators — cleaning, modeling, and visualizing trends from public Statistics Canada datasets.

SQLPandasJupyter
view on github
public

bigquery-customer-support-analytics

BigQuery analytics project transforming raw customer support events into modeled marts and dashboards quantifying agent throughput, SLA health, and resolution patterns.

BigQuerySQLLooker Studio
view on github
public

snowflake-dbt-home-credit

End-to-end dbt project on Snowflake modeling Home Credit default-risk data — staging, marts, tests, and documentation for a production-grade analytics workflow.

dbtSnowflakeSQL
view on github
public

Sigma BI Dashboard

Interactive Sigma Computing workbook exploring operational and financial metrics — published view showcasing modeled data, slicers, and visual storytelling end-to-end.

SigmaSQLBI
view on github
-- contact

Let's build something measurable.

I'm actively talking to teams hiring for analytics engineering, BI, or operations-analytics roles. Always up for a coffee or a Slack DM.

Toronto, Canada · Remote-friendly