Job description

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 skills, with the ability to work effectively with client-facing stakeholders and business leaders. - Ability to operate independently, manage competing priorities, and make sound decisions in an evolving environment. WHAT SETS YOU APART - Experience with advertising technology, streaming television, digital media, campaign measurement, or marketing analytics. - Experience building customer-facing analytics or reporting products. - Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting. - A track record of improving reporting accuracy, automation, scalability, or operational efficiency. - The ability to move comfortably between strategic planning, hands-on analysis, and technical execution. This is a hybrid role, working 3 days a week at Madhive HQ in New York City The approximate compensation range for this position is $137,000-$165,000. The actual offer, reflecting the total compensation package and benefits, will be determined by a number of factors including the applicant's experience, knowledge, skills, and abilities, as well as internal equity among our team. We are Madhive Madhive is a dynamic, diverse, innovative, and friendly place to work. We embrace our differences and believe they fuel our creativity. We come from varied backgrounds and think that’s important. Whether it’s taking ideas from previous lives and applying them in different ways or creating something completely new, we are all trail-blazing team players who think big and want to make an impact. We are committed to cultivating a culture of inclusion and collaboration. We welcome diversity in education, culture, opinions, race, ethnicity, gender identity, veteran status, religion, disability, sexual orientation, and beliefs. Please be advised that we will NOT be using third-party recruiting agencies for this search.

Requirements

Must-haves

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
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.
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.
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.
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 skills, with the ability to work effectively with client-facing stakeholders and business leaders.
Ability to operate independently, manage competing priorities, and make sound decisions in an evolving environment.
Experience with advertising technology, streaming television, digital media, campaign measurement, or marketing analytics.
Experience building customer-facing analytics or reporting products.
Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: ashby
Effort: quick

Benefits

Benefits detected in the listing.

Vision