Malcolm Angus

• Directly responsible for all marketing data and metrics (from instrumentation to enrichment and reporting).
• Successfully built and maintained a marketing data pipeline that scales >10B events.
• Worked closely with CMO, Content, Product and Performance Marketers to analyze funnel metrics and acquisition tactics. Made several key recommendations that enabled Retool to double ROAS through better keyword feedback loops.
• Leveraged AI to create an internal data product to analyze 1M+ minutes of customer conversations w/ Sales to better understand use-cases for our horizontal platform product. Enabled Product Marketers to create content tailored to each use-case and vertical and improve CVRs by 30%.

• Rank #1 for "seo data pipeline"
• Owned, architected, and built the company's data org and systems to power SEO analytics for 20 mid-sized B2B SaaS companies.
• Recruited, manage, and develop 2 full-time data/analytics engineers
• Launched a data product (Retool dashboard) that summarizes and forecasts performance in real-time.
• Created a suite of dashboards to power internal operations for the agency (SQL + Redash)
• Developed a robust data pipeline using SQL, dbt, Python, GCP, and cron to support a 24-hour cadence across terabytes of data on a limited budget.
• Integrated multiple 3rd party APIs including Google Analytics, Google Search Console, and DataForSEO
• Co-developed internal API services for scraping clients' websites, forecasting, and enrichment via GPT.

• Initiated and lead the company-wide efforts for data quality
• Designed and built an end-to-end automated solution (using Python, jinja-based SQL, internal APIs, and Tableau) for ensuring uptime and accuracy of a highly interdependent data-warehouse
• Cut data quality issues and SLAs failures by 50% through tighter reporting of failures; Improved trust and transparency of reporting for dozens of engineers, analysts, and downstream stakeholders
• Developed an automated method for table and dependency inferences to contribute to the data catalog
• Founding member of the data operations and competitive-intelligence teams
• Patent contributor for a data-quality invention

• Conducted 50+ technical interviews for analysts and data scientists to assess SQL, tracking, and analytical capabilities; Helped grow and mentor the team from 3 to 20+ analysts
• Made significant contributions to the team's proprietary enrichment and marketing attribution ETL repository (4.4k lines of SQL; 3.5k lines of python)
• Legacy Performance 2017 (awarded to ~5% of employees)
• Supported the Product Marketing team in the growth and adoption of Bitbucket; Included founder-level presentations and recommendations
• Monitored and reported on funnel metrics across the portfolio of products with $500M+ in ARR

Mentored dozens of individuals wanting to land their first job in analytics.

I taught a weekly course on learning and loving SQL. Google: "7 Common Pitfalls Holding You Back in SQL Interviews"