Data Analyst Lead

Madhive; New York, Northern (NY, KY); Hybrid; USD 137,000 - 165,000; Full time

Job summary

Madhive, a leading local media platform, seeks a Data Analyst Lead to own analytics, reporting, and data engineering initiatives within its product platform. You will guide cross-functional teams across Product, Engineering, and Client Success, shaping scalable analytics and embedded reporting experiences.

Ideal candidates bring 5+ years in analytics or data engineering, strong SQL with BigQuery, and a track record of leading reporting projects.

Qualifications

• 5+ years of professional experience in data analytics, BI, media analytics, data engineering, or a related field.
• Bachelor’s degree in a related discipline; master’s preferred.
• Advanced SQL skills and experience with Google BigQuery or similar cloud platforms.
• Proven ability to lead complex analytics or reporting projects end-to-end.

Responsibilities

• Lead end-to-end development of complex reporting, measurement, and analytics solutions.
• Translate business and product needs into technical requirements and implementations.
• Design scalable reporting frameworks, dashboards, and automated solutions.
• Develop analyses to identify trends, opportunities, and data quality issues.
• Provide guidance on analytics best practices and visualization design.
• Work with data engineers to define data models and system integrations.

Skills

SQL

BigQuery

Python

Data visualization

Leadership

Communication

ETL

Analytical thinking

Education

Bachelor’s degree in Data Analytics, CS, Stats, Math, Engineering

Master’s degree is a plus

Tools

Looker

Tableau

Domo

Datorama

Looker Studio

TapClicks

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, or a related discipline. A master’s degree is a plus.
• Advanced proficiency in SQL and experience working with Google BigQuery or comparable cloud-based data platforms.
• Demonstrated experience leading complex analytics or reporting projects from requirements gathering through implementation.
• Strong experience designing and maintaining ETLs, data pipelines, scheduled queries, and reporting automation.
• Experience with tools such as Google Cloud Platform, Airflow, GitHub, or comparable technologies.
• Advanced experience 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 structured and unstructured datasets.
• Demonstrated ability to identify insights and translate findings into practical business and product recommendations.
• Experience developing data models, technical requirements, testing plans, and reporting documentation.
• Experience with embedded analytics, iframe integrations, APIs, or web development concepts.
• Working knowledge of Python. Experience with Java, Scala, Spark, or similar technologies is a plus.
• Experience working across data environments such as Google Cloud, AWS, Hadoop, or similar platforms.
• Demonstrated experience mentoring analysts, reviewing technical work, or providing leadership across projects.
• Strong written and verbal communication skills, with the ability to work effectively with technical teams, business leaders, and client-facing stakeholders.
• 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.

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.