Madhive is the leading independent and fully customizable operating system built to help local media professionals build profitable, differentiated, and efficient businesses. Madhive empowers sales teams to extend their reach into streaming and connects local advertisers with the communities they serve. Madhive’s platform provides the unique ability to reach local audiences at national scale, with premium supply partnerships and end-to-end tools for planning, targeting, and measuring full-funnel campaign outcomes. Powering campaigns for over 30,000 small and medium businesses per day, Madhive is driving the evolution of local media.
The Role:
The Data Analyst Lead turns data into clear, actionable answers for the business — building the well-modeled data marts that power our reporting, then communicating the resulting insights directly to internal teams and customers. This role owns analytics initiatives end to end, from scoping and data modeling through delivery and communication of results.
Working closely with our Revenue team (Sales and Client Success), customers, and partners across Finance, Product, and Marketing, the Data Analyst Lead will write advanced SQL and build dashboards and analyses that give stakeholders clear, actionable takeaways.
The ideal candidate operates independently, is comfortable moving between data modeling and stakeholder conversations, and brings sound judgment to how data gets used to answer real business problems
WHAT YOU’LL DO:
CLIENT-FACING INSIGHTS
- Help clients understand their performance and their utilization of our platform; where they’re succeeding, where they’re leaving opportunity on the table, and what to do next.
- Partner directly with Sales, Client Success, and customers to scope new analyses, translating their questions into clear requirements.
- Support client-facing conversations such as QBRs and JBPs with dashboards and analyses that are clear and easy to act on.
INTERNAL REVENUE INSIGHTS
- Support internal revenue analytics such as pacing, forecasting, and product adoption, giving leadership the metrics needed to steer the business.
- Identify performance trends, business opportunities, and data quality issues, and translate them into clear, actionable recommendations.
DATA MODELING AND ANALYTICS ENGINEERING
- Build and maintain the data marts and models — the trusted data foundation — that make client-facing and internal insights reconcilable and correct.
- Write and review advanced SQL to transform, validate, and analyze large, complex datasets.
- Apply analytics engineering practices — tested, documented, version-controlled transformations (e.g. dbt, Dataform, or similar) — to build out our data modeling layer.
- Investigate and resolve data discrepancies and reporting inconsistencies across systems.
- Balance immediate reporting needs with longer-term data model scalability.
WHO YOU ARE
- 5 or more years of professional experience in data analytics, business intelligence, analytics engineering, or a related field.
- Bachelor’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, or a related discipline, or equivalent practical experience.
- Strong proficiency in SQL and experience working with Google BigQuery or comparable cloud-based data platforms.
- Experience with analytics engineering practices — building data marts, dimensional models, and tested, documented transformations (e.g. dbt, Dataform, or similar; tool-agnostic).
- Demonstrated experience owning analytics or reporting projects from requirements gathering through implementation.
- Strong proficiency with reporting and visualization platforms such as Looker, Tableau, Domo, Datorama, Looker Studio, TapClicks, or similar tools.
- Strong experience wrangling, exploring, cleaning, validating, and analyzing large datasets.
- Demonstrated ability to identify insights and translate findings into practical business and product recommendations.
- Strong written and verbal communication…