Data Analyst Lead

madhive; United States; Hybrid; USD 120,000 - 160,000; Full time

Job summary

Madhive, the leading independent OS for local media professionals, is hiring a Data Analyst Lead to drive measurement, analytics, and reporting across its product platform. In this hybrid, NYC-based role, you will guide end-to-end analytics initiatives and establish scalable reporting for internal teams and customers.

You'll lead ETL design, SQL analytics, and collaboration with product and engineering to ensure data quality and actionable insights, while mentoring other analysts and shaping

Qualifications

• 5 or more years of professional experience in data analytics, business intelligence, media analytics, data engineering, or a related field.
• Bachelor's degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, o

Responsibilities

• Lead the end-to-end development of complex reporting, measurement, and analytics solutions within Madhive's product platform.
• Translate business, product, and customer needs into clear technical requirements, reporting specifications, and implementation plans.
• Design scalable reporting frameworks, dashboards, and automated solutions that support internal teams and external customers.
• Develop advanced analyses that identify performance trends, business opportunities, data quality issues, and actionable recommendations.
• Serve as a subject matter expert for media measurement, reporting methodologies, data interpretation, and visualization design.
• Ensure reporting solutions are accurate, intuitive, scalable, and aligned with business and customer needs.
• Design, develop, and optimize ETLs, data pipelines, scheduled queries, and reporting automation.
• Write and review advanced SQL queries used to transform, validate, and analyze large and complex datasets.
• Partner with backend and data engineers to define data models, reporting structures, system integrations, and technical requirements.
• Investigate and resolve complex data discrepancies, reporting inconsistencies, and performance issues across multiple systems.
• Establish validation, documentation, testing, and quality-control standards for analytics and reporting solutions.
• Evaluate new tools, technologies, and approaches that improve the scalability, efficiency, and reliability of the reporting environment.
• Contribute to web-based reporting integrations, including iframe implementations and embedded analytics experiences.

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 Data Analyst Lead is responsible for leading the development, implementation, and ongoing evolution of measurement, analytics, and reporting capabilities within Madhive's product platform. This role owns complex analytics initiatives from initial requirements through technical design, development, validation, deployment, and ongoing optimization.

Working closely with Product, Engineering, Client Success, and other data professionals, the Data Analyst Lead will establish scalable reporting solutions, improve data quality and reliability, and translate complex data into actionable insights for internal teams and customers.

This role serves as a technical and analytical leader for the team. The Data Analyst Lead will provide guidance to other analysts, establish best practices, and help determine the methods, architecture, and standards used across new analytics and reporting initiatives. The ideal candidate combines advanced analytics and visualization expertise with an application and data engineering mindset.

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

What You’ll Do

Analytics and Reporting Leadership

Lead the end-to-end development of complex reporting, measurement, and analytics solutions within Madhive's product platform.

Translate business, product, and customer needs into clear technical requirements, reporting specifications, and implementation plans.

Design scalable reporting frameworks, dashboards, and automated solutions that support internal teams and external customers.

Develop advanced analyses that identify performance trends, business opportunities, data quality issues, and actionable recommendations.

Serve as a subject matter expert for media measurement, reporting methodologies, data interpretation, and visualization design.

Ensure reporting solutions are accurate, intuitive, scalable, and aligned with business and customer needs.

Data Engineering and Technical Ownership

Design, develop, and optimize ETLs, data pipelines, scheduled queries, and reporting automation.

Write and review advanced SQL queries used to transform, validate, and analyze large and complex datasets.

Partner with backend and data engineers to define data models, reporting structures, system integrations, and technical requirements.

Investigate and resolve complex data discrepancies, reporting inconsistencies, and performance issues across multiple systems.

Establish validation, documentation, testing, and quality-control standards for analytics and reporting solutions.

Evaluate new tools, technologies, and approaches that improve the scalability, efficiency, and reliability of the reporting environment.

Contribute to web-based reporting integrations, including iframe implementations and embedded analytics experiences.

Project and Cross-Functional Leadership

Lead high-impact analytics projects involving multiple teams, systems, and stakeholders.

Define project scope, requirements, milestones, dependencies, risks, and success measures.

Partner with Product leaders to shape the roadmap for analytics, measurement, and reporting capabilities.

Communicate technical concepts, project risks, analytical findings, and recommendations to both technical and nontechnical audiences.

Act as an escalation point for complex reporting, data, and analytical issues.

Balance immediate business needs with long-term platform scalability and technical sustainability.

Team Leadership and Development

Provide technical guidance, coaching, and mentorship to data analysts and other team members.

Review analytical approaches, SQL, dashboards, technical documentation, and reporting solutions developed by others.

Establish and promote consistent standards for data analysis, visualization, documentation, and quality assurance.

Lead knowledge‑sharing sessions and help strengthen the team's technical and analytical capabilities.

Support project prioritization and work allocation across analytics initiatives.

Influence team practices and technical direction without requiring formal direct‑report management responsibilities.

Who You Are

5 or more years of professional experience in data analytics, business intelligence, media analytics, data engineering, or a related field.

Bachelor's degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, o