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
You pull the right answer out of a warehouse with SQL that scales. Every analyst claims SQL, so hiring
managers want proof yours survives real data: window functions, CTEs, queries that don't take an
hour. Talk about how you used window functions and query optimization, on BigQuery or Snowflake, to cut
a key query's runtime and own the datasets behind it.
Techniques
Window functions
CTEs
Joins & subqueries
Query optimization
Tools
PostgreSQL
BigQuery, Snowflake
Redshift
Metrics
Queries shipped
Runtime cut
Datasets owned
2
BI Dashboards & Visualization
You build dashboards people actually use. Hiring managers look here to see whether your work gets used,
or whether it's another tab nobody clicks. Show them how you used self-serve design and sharp KPI
tiles, in Tableau or Looker, to grow weekly active viewers on the dashboards you shipped.
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
You pin down what every metric actually means. When definitions drift, every meeting turns into an
argument about whose number is right, so hiring managers want to see you lock them down. Point out how
you used metric trees and versioned definitions, in dbt or LookML, to bring reporting errors down and
get every team quoting the same number.
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
You chase a strange number down to its real cause. A root-cause story reads as analysis to a hiring
manager; a pile of charts does not. Lay out how you used cohort analysis and root-cause digging, in SQL
and a Python notebook, to answer the question fast enough to change the decision.
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
You call a test honestly, from power to confidence intervals. A mis-sized experiment burns weeks on a
false positive, and the math is easy to check, so real rigor carries weight here. Walk them through how
you used power analysis and proper hypothesis testing, with statsmodels or GrowthBook, to size the tests
and bring false positives down.
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
You make numbers people can trust without asking you. Two things ride on it for a hiring manager: tests
that catch bad data early, and documentation that stops the same question landing in your inbox every
week. Mention how you used dbt tests and clear model docs, backed by Great Expectations, to catch issues
upstream and get the docs actually adopted.
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
You change decisions with what you found. Companies promote the analysts who shift decisions, not the
ones who just send charts nobody acts on, so hiring managers look hard at this. Spell out how you used
executive readouts and clear recommendation memos, tightened into a short deck, to move a real call the
business made.
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
You automate reporting so nobody reruns it by hand. Automation hands you the hours back, so it tells a
hiring manager you scale yourself instead of drowning in requests. Tell them how you used Python and
Airflow, with a clean Git workflow, to automate the recurring reports and save real hours every week.
Techniques
Python scripting
Git workflow
Notebook hygiene
Automated reporting
Tools
pandas, NumPy
Git & GitHub
Airflow, Jupyter
Metrics
Reports automated
Hours saved weekly
Repos contributed