Be ready to discuss specific tools and platforms you're familiar with: marketing automation (HubSpot, Marketo, Klaviyo, ActiveCampaign), CRM systems (Salesforce, Pipedrive), analytics tools (Google Analytics, Mixpanel, Amplitude), data visualization (Tableau, Looker, Power BI), testing platforms (Optimizely, VWO), or data management platforms. For each tool, be specific about what you actually did (created reports, set up workflows, troubleshot issues, etc.), not just 'familiar with.' If you lack certain tools, mention your ability to learn technical systems quickly and provide examples of how you've picked up new platforms.
MediumTechnical
0 practiced
Walk through how you would build a LookML model for an e-commerce site. Identify the core views (orders, users, products, sessions), primary measures and dimensions, grain selection, joins and their relationship types, use cases for PDTs or aggregate tables to speed queries, and how you'd manage version control and environment promotion.
EasyTechnical
0 practiced
Describe how you used Jira or Azure DevOps to manage BI work. Include how you wrote tickets (acceptance criteria, data samples), prioritized dashboard and data requests, estimated effort, tracked dependencies to data sources or ETL jobs, and how you communicated status and SLAs to stakeholders.
HardTechnical
0 practiced
Design instrumentation for a multi-step checkout funnel that spans web, mobile, and offline channels (phone orders). Specify events, required properties (transaction id, user id, step name, timestamp), session stitching approach, how to ingest offline orders into analytics, sampling decisions, and validation checks to ensure funnel integrity across channels.
HardTechnical
0 practiced
Given two PostgreSQL tables: clicks(click_id, user_id, click_timestamp, campaign_id) and conversions(conversion_id, user_id, conversion_timestamp), write SQL to attribute each conversion to the last click by the same user within the 7 days prior to the conversion. Return conversion_id and attributed_campaign_id. Discuss edge cases like multiple clicks at the same timestamp or conversions without prior clicks.
EasyTechnical
0 practiced
Describe the steps to set up an A/B test using Optimizely or VWO for a homepage redesign. Cover hypothesis formation, audience segmentation, sample size estimation, primary and guardrail metrics, QA and bot filtering, test duration, and a robust stopping decision process that avoids peeking bias.
Unlock Full Question Bank
Get access to hundreds of Technical Skills & Tools Inventory interview questions and detailed answers.
