Data Analyst Lead

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. Madhives 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 30000 small and medium businesses per day Madhive is driving the evolution of local media.

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

This is a hybrid role working 3 days a week at Madhive HQ in New York City

• Help clients understand their performance and their utilization of our platform where theyre succeeding where theyre 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.

• Bachelors 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.

• 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.

The approximate compensation range for this position is $137000-$165000. The actual offer reflecting the total compensation package and benefits will be determined by a number of factors including the applicants 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 thats important. Whether its 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.

Required Experience:

IC