This is where the second screening pass actually plays out, the last gate before an interview lands
in your inbox. The recruiter slows their reading right here, and even at this point your current
role still carries close to 95% of the call.
Stands to reason: nothing shows a recruiter what you can deliver right now the way your current
position does. To reach the "yes", this section needs to walk the entire
Data Analyst role profile, with a bullet against each domain you named in
Domain Expertise above. Aim each bullet at something you actually shipped, never at a ticket
that landed on your queue.
1
SQL & Data Querying
This is the foundation of an analyst's day, and the first thing a recruiter looks for. Show
the kind of question you answered in SQL, the warehouse you queried, and a query you tuned down to
something usable. Name the analysis and the warehouse, not "wrote SQL".
Techniques
Window functions
CTEs
Joins & subqueries
Query optimization
Tools
PostgreSQL
BigQuery, Snowflake
Redshift
Metrics
Queries shipped
Runtime cut
Datasets owned
2
BI Dashboards & Visualization
Where the raw analysis becomes something a stakeholder can actually act on. Show the dashboard you
built, the team that uses it day to day, and the decision it feeds. Name the dashboard and who reads
it, not "made some charts".
Techniques
Self-serve dashboards
KPI tiles & drill-downs
Chart selection
Filters & parameters
Tools
Tableau
Looker
Power BI
Metrics
Dashboards live
Active users
Weekly views
3
KPI & Metric Definition
The unglamorous work that shapes how a whole team measures itself. Show the metric you defined, the
edge cases you ruled on, and the doc that pinned it down. Call out the KPI you owned, not
"tracked metrics".
Techniques
Metric trees
North-star KPIs
Edge-case rules
Versioned definitions
Tools
dbt
Looker LookML
Mode
Metrics
KPIs owned
Definitions locked
Reporting errors down
4
Ad Hoc Analysis & Deep Dives
The questions that arrive on Slack with no warning. Show the deep dive you ran, the hypothesis you
tested, and the call leadership made because of your findings. Name the question and the decision,
not "ran an analysis".
Techniques
Funnel analysis
Cohort analysis
Root-cause investigation
Time-series breakdowns
Tools
SQL, Python notebooks
Hex
Mode
Metrics
Investigations shipped
Decisions influenced
Time-to-answer
5
Statistics & Experimentation
The bar a recruiter starts looking for from mid-level on. Show the A/B test you sized, the confidence
interval you actually used, and the call your reading drove. Statistical rigour you can defend reads
as real judgment; "ran some tests" doesn't.
Techniques
A/B testing
Power analysis
Hypothesis testing
Confidence intervals
Tools
Statsmodels, SciPy
Optimizely
GrowthBook
Metrics
Tests sized
Decisions called
False positives down
6
Data Quality & Documentation
The work that keeps the rest of analytics trustworthy. Show the data issue you caught, the model you
documented, and the test you wrote against it for next time. Name the issue you found, not
"cleaned data".
Techniques
Data tests
Model documentation
Issue triage
Schema reviews
Tools
dbt tests
Great Expectations
Notion
Metrics
Tests in place
Issues caught early
Docs adopted
7
Business Storytelling & Stakeholders
Where analysis turns into a decision, or simply doesn't. Show the readout you delivered, the
stakeholder you worked with, and the action they ended up taking. Name the meeting and the call, not
"presented findings".
Techniques
Executive readouts
Insight framing
Recommendation memos
Stakeholder discovery
Tools
Slides
Loom
Notion docs
Metrics
Decisions shifted
Stakeholders re-engaged
Memos delivered
8
Tooling & Workflow
The toolbox that lets one analyst do the work of three. Show the scripting you do outside SQL, the
version control you actually use, and the automation that removed a recurring chore. Name the
workflow, not "used Python".
Techniques
Python scripting
Git workflow
Notebook hygiene
Automated reporting
Tools
pandas, NumPy
Git & GitHub
Airflow, Jupyter
Metrics
Reports automated
Hours saved weekly
Repos contributed