Data Analyst Lead

Jobtailor

New York (NY)

On-site

USD 120,000 - 170,000

Full time

3 days ago

Be an early applicant

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

Madhive is seeking an experienced analytics leader to drive end-to-end reporting and measurement solutions on our product platform. You will translate complex business needs into technical specs, design scalable dashboards, and build automated ETL pipelines to empower internal teams and clients.

You will lead high-impact analytics projects, mentor analysts, and collaborate with data engineers on data models and integrations, ensuring accuracy and actionable insights across stakeholders.

Qualifications

5+ years of professional experience in data analytics, BI, or related field.
Bachelor’s degree in a relevant discipline.
Advanced proficiency in SQL.
Experience with cloud platforms (Google Cloud Platform) and data tooling.
Experience leading complex analytics projects from requirements to implementation.
Experience designing and maintaining ETLs and data pipelines.
Knowledge of embedded analytics, APIs, and web concepts.
Strong communication and mentoring abilities.

Responsibilities

Lead end-to-end development of complex reporting and analytics solutions.
Translate business needs into technical requirements and implementations.
Design scalable reporting frameworks, dashboards, and automation.
Develop analyses to identify trends, opportunities, and data quality issues.
Serve as SME for media measurement, visualization design, and reporting methodologies.
Establish standards for validation, testing, and QA of reporting solutions.
Collaborate with data engineers on data models and system integrations.
Provide technical guidance and mentorship to data analysts.
Lead analytics projects across teams and stakeholders.
Communicate findings and risks to technical and non-technical audiences.

Skills

Advanced SQL

Data Analytics

Mentoring

Independent Decision-Making

Communication

Project Leadership

Education

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

Master’s degree is a plus

Tools

Google Cloud Platform

Airflow

GitHub

Looker

Tableau

Domo

Datorama

Looker Studio

TapClicks

APIs

Job description

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 technical requirements, reporting specifications, and implementation plans
Design scalable reporting frameworks, dashboards, and automated solutions for internal teams and external customers
Develop advanced analyses to 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 for transforming, validating, and analyzing large datasets
Partner with backend and data engineers on data models, reporting structures, system integrations, and technical requirements
Investigate and resolve complex data discrepancies, reporting inconsistencies, and performance issues
Establish validation, documentation, testing, and quality-control standards
Evaluate tools, technologies, and approaches to improve reporting scalability, efficiency, and reliability
Contribute to web-based reporting integrations, including iframe implementations and embedded analytics experiences
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 analytics, measurement, and reporting roadmap
Communicate technical concepts, project risks, analytical findings, and recommendations to technical and nontechnical audiences
Act as an escalation point for complex reporting, data, and analytical issues
Provide technical guidance, coaching, and mentorship to data analysts and team members
Review analytical approaches, SQL, dashboards, technical documentation, and reporting solutions
Establish standards for data analysis, visualization, documentation, and quality assurance
Lead knowledge-sharing sessions and support project prioritization and work allocation

Requirements

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
Advanced proficiency in SQL
Experience with Google BigQuery or comparable cloud-based data platforms
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 Google Cloud Platform, Airflow, GitHub, or comparable technologies
Advanced experience with Looker, Tableau, Domo, Datorama, Looker Studio, TapClicks, or similar tools
Strong experience wrangling, exploring, cleaning, validating, and analyzing large structured and unstructured datasets
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 across data environments such as Google Cloud, AWS, Hadoop, or similar platforms
Experience mentoring analysts, reviewing technical work, or providing leadership across projects
Strong written and verbal communication skills
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 is an advantage
Experience building customer-facing analytics or reporting products is an advantage
Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting is an advantage
Master’s degree is a plus

Core Competencies

Demonstrates advanced proficiency in SQL and experience with data analytics, reporting automation, and ETL processes. Capable of leading complex analytics projects, mentoring team members, and translating technical findings into actionable business insights.

Highest-signal resume keywords