About

  • Worked in data insights at Shopify for seven years: four in data analysis and three in data engineering.

  • Created governed, tested data pipelines with BigQuery, dbt, Airflow, and Terraform for analytical data modelling, data products, and semantic layer metrics.

  • Identified how products could be abused, and integrated machine learning and AI judges into data products that detected it and powered automations and escalations for human review.

  • Evaluated ML and LLM agents used in automations against a golden dataset with confusion matrices before each version bump deployed to production, measuring precision, recall, accuracy, specificity, and ROC-AUC.

Experience

Data Engineering

  • Administered a Google Cloud project as an owner and admin, maintaining Dockerfiles and managing IAM permissions with Terraform.

  • Approved IAM service accounts with least-privilege access, giving only the minimum access needed to unblock work.

  • Applied policy tags to PII and implemented data retention policies to support deletion requests and compliance with EU laws such as GDPR.

  • Combined deterministic, heuristic, ML and LLM-based automated checks to triage operational tasks ensuring human attention is in the loop only when needed.

  • Built AI data pipelines and agent harnesses that looped agentic automations over a feature library rooted in data, and produced structured user journey data that showed how workflows behaved without any users.

  • Used BigQuery, Airflow, dbt, Kafka, Flink, and Meltano for automations, analytically modelled data and data products.

  • Analytically modelled data from raw to conformed layer metrics ensuring SLAs and criticality assigned for use in the semantic layer as product metrics.

  • Built incremental models with type 2 slowly changing dimension merges and insert overwrites, and converted full-drop tables to incremental models for performance.

  • Standardized an incrementalized change-detection pattern via macros that sent only new updates to power trust automations.

  • Managed data incidents across streaming and scheduled batch data products that powered automations based on freshness service level agreements and criticality.

  • Held retros after data incidents to identify what broke, why it broke, and how to stop it from happening again.

  • Built token usage optimization strategies into looping AI data pipelines, so that agentic automations stayed practical to run at the volume that the data work needed.

  • Powered automations via events with streaming and scheduled batch data products that were versioned, unit tested, and held to freshness service level agreements.

  • Applied column-level data tests from dbt and dbt-utils, and wrote unit tests with mock data that ran in CI to block any PR that would break production data.

  • Escalated headless AI tasks to humans for review through durable event-based triggers, which combined abuse and risk experience with agentic data pipelines.

  • Owned a data mesh domain & team in a data warehouse, reviewing PRs and ensuring consistency, versioning, freshness SLAs and criticality were applied to contributions in the domain and mart layers.

Anti-Abuse

  • Analyzed all kinds of abuse as a specialty, across fraud, risk, compliance, and security, and built data pipelines that detected, actioned, automated or escalated it to operations.

  • Built proactive fraud and risk detection on data pipelines and tripwires, so that detection did not wait for someone to report a problem.

  • Modelled event data into tripwires that powered automations for abuse and fraud detection and prevention.

  • Created machine learning models and deterministic algorithms that identified abuse, fraud, and risk, and powered automations that acted on the output.

  • Audited new products for abuse potential and proactively built data pipelines to detect & prevent any fraud, abuse or security problems.

  • Managed and updated gradient boosted tree models for abuse, fraud, and risk detection, alongside deterministic and heuristic checks.

  • Performed on-call incident response for compliance, security, fraud and abuse and worked with strategic stakeholders to respond.

  • Combined deterministic checks with machine learning models to identify abuse, fraud, and risk allowing for cost-saving while applying ML for less obvious signals.

  • Translated product’s vision into a unified policy framework with versioned and unit tested automations to detect potential abuse through SQL tripwires and data pipelines.

Developer Ecosystem and Partnerships

  • Analytically modelled data to support developer marketplaces and ecosystems across all forms of partnerships at Shopify.

  • Created dashboards with analytically modelled data for all forms of developer activity.

  • Applied knowledge of app security, store building, and app development workflows to assess and prevent platform abuse.

  • Used api activity to model and infer types of activity to understand what developers are building.

  • Built streaming and scheduled batch data products for the app developer ecosystem as a Senior Data Engineer.

  • Monitored compliance across 3rd party strategic partnerships, app marketplaces, and developer ecosystems with automations and data pipelines.

Work History

  • 2018-2019, Support Advisor, Shopify

  • 2019, Partner Support Advisor, Shopify

  • 2019-2020, Business Analyst, Partnership Operations, Shopify

  • 2020-2023, Senior Business Analyst, Partnership Operations, Shopify

  • 2023-2024, Data Engineer, Developer Marketplaces, Shopify

  • 2024-2026, Senior Data Engineer, Developer Marketplaces, Shopify