Data Analyst Lead

The role

The Data Analyst Lead builds well-modeled data marts and communicates insights to internal teams and customers. This person owns analytics initiatives from scoping and data modeling through delivery.

What you will do

• Help clients understand performance and platform utilization.
• Partner with Sales, Client Success, and customers to scope new analyses.
• Support client-facing conversations with dashboards and analyses.
• Support internal revenue analytics such as pacing, forecasting, and product adoption.
• Identify performance trends, business opportunities, and data quality issues.
• Build and maintain data marts and models.
• Write and review advanced SQL to transform, validate, and analyze large, complex datasets.
• Apply analytics engineering practices to build the data modeling layer.
• Investigate and resolve data discrepancies and reporting inconsistencies.
• Balance immediate reporting needs with long-term data model scalability.

Required qualifications

• 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.
• 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.
• Ability to operate independently, manage competing priorities, and make sound decisions in an evolving environment.

Nice to have

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

About the company

Madhive is an operating system built to help local media professionals build profitable, differentiated, and efficient businesses. The platform connects local advertisers with communities and empowers sales teams to extend reach into streaming.