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