Services Description
Enable, triage, prioritize, and answer questions from the Stripe sales and marketing teams via Slack and Jira. This includes:
- Automate reporting and visualization of core business metrics in Hubble Dashboards (inhouse tool built on Presto, SQL, React JS and Plotly).
- Ad-hoc Analysis in Tableau.
- Provide operational support for Analytics & Insights initiatives.
- Ensure quality of data and accuracy of downstream reporting through precise attention to detail.
- Create analyses that tell a story focused on insights, not just data.
- Create sales enablement materials.
Qualifications
- 6 Years of experience in Data Analytics, with a focus on analyzing large data sets to solve problems and building user-friendly dashboards.
- Experience wrangling imperfect data and writing efficient SQL.
- Some coding experience Python, React Javascript, Plotly (charts).
- Beginner to intermediate knowledge in creative data visualization in Tableau.
- Experience creating dashboard documentation for end users.
- Communicate clearly, proactively, and concisely with stakeholders.
- Ability to work independently in a fast-paced and frequently changing environment.
Focused on building and maintaining dashboards, preparing WBR/MBR/QBR data packs, weekly deal lists, and managing BAU ticketed requests
Dashboards & Reporting
- Build, maintain, and QA dashboards (xBR dashboard, SA dash, Performance). Dashboards run via Hubble and front-end JS (analyst runs queries and config; devs/engineers own underlying code).
- Refresh Hubble dashboards weekly (refreshes run Mondays) and troubleshoot discrepancies.
- Weekly Business Reviews / Decks
Prepare WBR decks and notes: aggregate data, validate, create Google Slides, take refreshed screenshots, craft short written commentary.
- Maintain WBR notes and weekly deal lists (rolling current/prior week spreadsheets).
- Regular Packs & Quarterly Reporting
Create MBR and QBR data packs and support quarter-end reporting.
- Headcount checks and backfills: run checks (e.g., HC counts/IDs) and correct sheet formulas for manual QA.
Ticketing & BAU Operations
- Triaged via Slack and Asana: 35 tickets/week, typically LXL (multiday).
- Handle adhoc requests from sales, F&S, and other stakeholders; create tickets and follow Asana flow.
SQL & Data Work
- Daily SQL usage via Hubble to fetch and validate data. High technical proficiency expected for senior; junior may rely on LLMs to generate/modify queries.
- Analysts do not write back to databases; readonly data access only.
Manual Process Work
- High amount of manual spreadsheet work, formula updates, chart refreshes, screenshots, and manual QA.
Coordination & Training
- Train contractors on WBR note processes and business context. Coordinate with data engineers & program managers for larger projects and access issues.
- Advanced SQL skills: write, adapt, and troubleshoot queries in Hubble; understand joins, aggregations, windows
- Advanced Google Sheets: SUMIFS, VLOOKUP/XLOOKUP, INDEX/MATCH, array formulas, pivot tables, conditional formatting.
- Dashboard experience: building/maintaining commercial dashboards; troubleshoot data-display mismatches.
- Strong written communication: distill data into concise commentary for WBR slides and stakeholder updates.
- GTM / sales ops knowledge: deal lifecycle, pipeline concepts, forecasting basics.
- Operational discipline: triaging and tracking tickets in Asana; clear handoffs via Slack/email.
- Comfortable working under deadlines and ambiguity; methodical QA mindset.
table mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,; tr mso-height-source:auto; col mso-width-source:auto; td padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Aptos Narrow, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0; .xl27 font-size:10.0pt; vertical-align:middle; border-top:.5pt solid black; border-right:none; border-bottom:.5pt solid black; border-left:none; white-space:normal;
table mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,; tr mso-height-source:auto; col mso-width-source:auto; td padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Aptos Narrow, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0; .xl27 font-size:10.0pt; vertical-align:middle; border-top:.5pt solid black; border-right:none; border-bottom:.5pt solid black; border-left:none; white-space:normal;
table mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,; tr mso-height-source:auto; col mso-width-source:auto; td padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Aptos Narrow, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0; .xl27 font-size:10.0pt; vertical-align:middle; border-top:.5pt solid black; border-right:none; border-bottom:.5pt solid black; border-left:none; white-space:normal;
