01
SQL transformations
Make this concrete enough that another engineer can understand what you built and why.
CAREER PROJECT · Beginner–Intermediate · 1 weekend
Product Funnel Analysis
Turn messy event data into a reproducible funnel analysis with SQL, quality checks, visualizations and a decision memo.
SQLPythonData cleaningVisualizationExperiment thinkingCommunication
DEFINITION OF DONE
Leave artifacts a reviewer can inspect.
02
Notebook or pipeline
Make this concrete enough that another engineer can understand what you built and why.
03
Dashboard
Make this concrete enough that another engineer can understand what you built and why.
04
Data-quality checks
Make this concrete enough that another engineer can understand what you built and why.
05
One-page decision memo
Make this concrete enough that another engineer can understand what you built and why.
RESUME / PORTFOLIO FRAMING
Describe what you actually did.
Analyzed product event data with SQL and Python, built a reproducible funnel model and communicated prioritized conversion opportunities.
Use this as a starting structure, then replace it with your real implementation details, metrics and constraints. Do not claim outcomes you did not measure.
STRETCH GOALS
Go deeper if the core is already solid.
Cohort retention
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.
Experiment sizing
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.
dbt model
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.
Automated anomaly checks
Add only if it strengthens the engineering story instead of delaying a finished, deployable core.