This is the section where the second screening pass actually happens, the last gate before an
interview hits your inbox. The recruiter slows the read right here, and even then your current role
still carries about 95% of the call.
Makes sense: nothing tells a recruiter what you can ship today the way your current position does.
To clear that "yes", the section has to walk the full
BI Developer role profile, one bullet per slot you listed in Domain Expertise above.
Aim every bullet at something you stood up or owned, never at a ticket that landed in your queue.
1
BI Architecture & Semantic Layer
You build the semantic layer every chart runs on. Without it, every dashboard computes revenue its own
way, so hiring managers want to see the semantic model you built and who runs on it. Lay out how you
used semantic-layer design and star schemas, in LookML or Cube, to ship explores that serve teams beyond
your own.
Techniques
Semantic layer design
Star schemas
Explore modeling
Persistent derived tables
Tools
LookML
dbt Semantic Layer
Cube
Metrics
Explores shipped
Models maintained
Teams served
2
Dashboards & Data Visualization
You put data where leaders actually look. Adoption is a number anyone can pull, so weekly active viewers
say more than a screenshot of a pretty layout. Show them how you used executive-grade design and clean
drill-paths, in Looker or Power BI, to grow certified dashboards into a habit people keep.
Techniques
Executive dashboards
KPI tiles & drill-paths
Chart selection
Parameters & user attributes
Tools
Looker
Tableau
Power BI
Metrics
Certified dashboards
Weekly active viewers
Adoption rate
3
KPI & Metrics Definition
You end the arguments over numbers with certified definitions. A governed catalog reads as real control
to a hiring manager; a spreadsheet of definitions does not. Point out how you used a curated KPI catalog
and certified definitions, in the dbt Semantic Layer, to lock definitions down and cut reporting
disputes.
Techniques
KPI catalog curation
Metric trees
Certified definitions
Versioning
Tools
dbt Semantic Layer
LookML
Atlan / Collibra
Metrics
KPIs certified
Definitions locked
Reporting disputes down
4
SQL & Data Modeling
You model the data so dashboards stay fast and cheap. Modeling for BI performance is where the craft is,
so hiring managers want proof in runtime and spend, not "wrote SQL". Talk about how you used
incremental models and query optimization, in dbt on Snowflake, to cut dashboard runtime and pull
warehouse spend down.
Techniques
Incremental models
CTEs & window functions
Query optimization
Layered schemas
Tools
Snowflake, BigQuery
Redshift, Databricks
dbt Core / Cloud
Metrics
Models shipped
Runtime cut
Warehouse spend down
5
Self-Serve Analytics & Enablement
You get the business answering its own questions. Every self-serve user frees the data team for harder
work, so it tells a hiring manager you multiply other people, not just your own output. Walk them
through how you used curated explores and user training, in Looker or Hex, to grow self-serve users and
shrink the ticket queue.
Techniques
Curated explores
Office hours
User training
Templated dashboards
Tools
Looker
Hex
Power BI workspaces
Metrics
Self-serve users
Ticket volume down
Explores adopted
6
Data Quality & Governance
You certify what the business is allowed to trust. Two things ride on it for a hiring manager: certified
assets people rely on without checking, and freshness SLAs that hold through quarter close. Mention how
you used dashboard certification and row-level security, tested through dbt and Monte Carlo, to grow the
certified catalog and keep the SLA hit rate high.
Techniques
Dashboard certification
Row-level security
Freshness SLAs
Data tests
Tools
dbt tests
Monte Carlo
Atlan / Alation
Metrics
Certified assets
SLA hit rate
Incidents caught upstream
7
Stakeholder Partnership
You turn what a VP needs into a standing report. Companies keep the BI developers who power standing
decisions, not the ones who burn down ticket queues, so hiring managers look for it. Spell out how you
used real requirements gathering and joint dashboard reviews, on a standing cadence, to become part of
the reviews where decisions get made.
Techniques
Requirements gathering
Joint dashboard reviews
Operating-rhythm reporting
Quarterly business reviews
Tools
Slides
Loom
Notion / Confluence
Metrics
Stakeholders served
Standing reviews
Decisions powered
8
Tooling & Workflow
You run BI like a codebase: reviews, version control, CI. Hiring managers look here to see whether your
BI survives change, or whether a renamed column breaks Monday's refresh. Tell them how you used CI
for LookML and dbt with automated refreshes, checked by Spectacles, to keep refreshes reliable and save
hours every week.
Techniques
BI code reviews
Git workflow
CI for LookML & dbt
Automated refreshes
Tools
Git & GitHub
Spectacles, dbt CI
Airflow, Dagster
Metrics
Refreshes automated
Hours saved weekly
PRs reviewed