Lead, Business Intelligence

What you'll do

• Own and maintain Azure-based BI infrastructure, including Azure Synapse Analytics, Azure Data Factory, and Blob Storage
• Manage and evolve data pipelines, including ingestion, transformation, and delivery
• Write and optimize complex SQL queries, stored procedures, and pipeline logic
• Partner with data engineering on integrations with upstream systems (Salesforce, DSPs, ad platforms)
• Ensure data quality, pipeline reliability, and documentation standards across the team
• Oversee the development and maintenance of Power BI dashboards and other reporting
• Translate business questions from stakeholders into data models and reporting solutions
• Support revenue analytics - including advertiser performance, DSP reporting, and product-level breakdowns
• Own ad hoc analysis and deep-dives as needed
• Collaborate across Sales, Sales Support, Finance, Marketing and Product to build and maintain a platform that serves their needs
• Manage and mentor a team of BI analysts across the globe, supporting their growth and day-to-day execution
• Triage and prioritize incoming data requests alongside the Director of BI
• Set and uphold standards for code quality, documentation, and project delivery
• Serve as the subject matter expert for BI infrastructure

Requirements

• 5+ years of experience in business intelligence, data analytics, or data engineering
• Strong SQL skills, including window functions, complex joins, stored procedures, and performance tuning
• Hands-on experience with Azure cloud services or equivalent (Synapse Analytics, Data Factory, Blob Storage)
• Proficiency with Power BI or a comparable BI tool (Tableau, Looker, Sigma, etc.)
• Experience managing or mentoring junior analysts or engineers
• Ability to communicate technical concepts clearly to non-technical stakeholders
• Comfort working in a fast-paced environment with a high degree of ownership
• Experience in ad tech, media intelligence, or programmatic advertising (DSPs, SSPs, audience data)
• Familiarity with Salesforce as a revenue source of truth
• Experience working with international teams across multiple time zones
• Prior exposure to Microsoft Fabric or awareness of the Azure/Fabric roadmap

Tech stack