$ dbt build --select +andrew_lee
Running with dbt=andrew · target: prod · last updated October 2026
Found 7 models, 19 data tests
-- Not on the High Street
-- compiled
select
*
from source('career', 'first_job')
-- E-commerce Assistant. Where it started.
-- Not on the High Street
-- compiled
select
*,
experimentation,
sql
from ref('not_on_the_high_street.ecommerce_assistant')
-- Data Analyst · July 2018 – March 2020. A/B testing and customer journey analysis for product teams.
PASS ab_tests_across_product_teams [PASS]
PASS web_data_restructured_lower_cost [PASS]
-- Trainline
-- compiled
select
*,
product_analytics
from ref('not_on_the_high_street.data_analyst')
-- Product Analyst · March 2020 – March 2021. Product analytics: opportunity sizing, KPIs and experiments.
PASS experiments_shaping_product_roadmap [PASS]
PASS analysts_trained_in_sql_and_tableau [PASS]
-- Trouva
-- compiled
select
*,
dbt,
ci_cd
from ref('trainline.product_analyst')
-- Data Engineer · March 2021 – January 2022. Moved down the stack: migration to a modern data stack.
PASS legacy_stack_migrated_to_dbt [PASS]
PASS six_analysts_building_own_tables [PASS]
-- Lick
-- compiled
select
*,
crm_modelling,
orchestration
from ref('trouva.data_engineer')
-- Senior Analytics Engineer · January 2022 – August 2023. Designed the data infrastructure of an early-stage startup from scratch.
PASS pipelines_99pct_success_zero_downtime [PASS]
PASS not_null_every_model_documented [PASS]
PASS kpi_reporting_live_in_2_months [PASS]
PASS crm_and_ecommerce_in_one_customer_view [PASS]
-- Lick
-- compiled
select
*,
data_strategy,
governance_gdpr
from ref('lick.senior_analytics_engineer')
-- Head of Data / Data Lead · August 2023 – April 2025. Sole data lead, working directly with the C-suite.
PASS data_tooling_spend_cut_40pct [PASS]
PASS gdpr_governance_overhauled [PASS]
PASS investor_reporting_with_c_suite [PASS]
-- Ffern
-- compiled
select
*,
hiring,
exec_reporting,
platform_from_zero,
governed_ai_access,
ai_assisted_engineering
from ref('lick.head_of_data')
-- Head of Data · April 2025 – now · team of 3. First data hire: strategy, platform and team from scratch.
PASS unique_first_dedicated_data_hire [PASS]
PASS data_team_scaled_from_0_to_3 [PASS]
PASS one_governed_source_of_truth [PASS]
PASS ai_analytics_with_role_based_access [PASS]
PASS board_reporting_on_agreed_metrics [PASS]
PASS accepted_values_stack [PASS]
- snowflake
- dbt
- dagster
- lightdash
- estuary
Finished running 7 table models, 19 data tests in 9 years.
Completed successfully.
Done. PASS=19 WARN=0 ERROR=0 SKIP=0 TOTAL=19
$ dbt show --select skills
Previewing node 'skills':
| skill | area |
| ----------------------- | ----------- |
| data_strategy | leadership |
| governance_gdpr | leadership |
| hiring | leadership |
| exec_reporting | leadership |
| platform_from_zero | platform |
| governed_ai_access | platform |
| ai_assisted_engineering | platform |
| dbt | engineering |
| ci_cd | engineering |
| crm_modelling | engineering |
| orchestration | engineering |
| experimentation | analytics |
| sql | analytics |
| product_analytics | analytics |
$ dbt run --select contact
email hello@andrewpblee.dev
$ _