Back to jobs

Data Analyst Lead

Madhive HQ (New York, NY) · New York, United States

Live, first seen by us 71 days ago
Pay
$137,000–165,000/yearAnnual period assumed — pay source
This is a hybrid role, working 3 days a week at Madhive HQ in New York City 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
Read the full posting
Work setting
Hybrid — work setting source
The ability to move comfortably between strategic planning, hands-on analysis, and technical execution. This is a hybrid role, working 3 days a week at Madhive HQ in New York City 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.
Location type: Hybrid
From the employer’s posting
Employment
Full-time — employment source
Employment type: Full-time
From the employer’s posting
Team
Go to Market Strategy — team source
Department: Go to Market Strategy
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain data marts and models that power reporting

  • Write and review advanced SQL to transform, validate, and analyze large datasets

  • Help clients understand their platform performance and next steps

  • Support internal pacing, forecasting, and product adoption analytics

  • Investigate and resolve data discrepancies across systems

From the employer’s posting
Build and maintain the data marts and models — the trusted data foundation
Write and review advanced SQL to transform, validate, and analyze large, complex datasets
Help clients understand their performance and their utilization of our platform
Support internal revenue analytics such as pacing, forecasting, and product adoption
Investigate and resolve data discrepancies and reporting inconsistencies across systems

Before you apply

Employer’s visa record
3 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Sponsorship
Visa sponsorship not confirmed — sponsorship source
Do you currently require, or will you eventually require, sponsorship to work legally in the U.S.? (e.g., H-1B, O-1, or similar) If you are currently on F-1 OPT or STEM OPT, please select “Yes.”
From the employer’s application form

What you’ll bring

All qualifications

Core experience

  • 5 or more years of professional experience in data analytics, business intelligence, analytics engineering, or a related field.
  • Experience with advertising technology, streaming television, digital media, campaign measurement, or marketing analytics.
  • Bachelor’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, or a related discipline, or equivalent practical experience.
  • Experience building customer-facing analytics or reporting products.
  • Strong proficiency in SQL and experience working with Google BigQuery or comparable cloud-based data platforms.
  • Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting.
Qualification wording
5 or more years of professional experience in data analytics, business intelligence, analytics engineering, or a related field.
Experience with advertising technology, streaming television, digital media, campaign measurement, or marketing analytics.
Bachelor’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, or a related discipline, or equivalent practical experience.
Experience building customer-facing analytics or reporting products.
Strong proficiency in SQL and experience working with Google BigQuery or comparable cloud-based data platforms.
Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting.
Education & alternatives
- 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.
Apply at Madhive

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 11, 202671 days ago
Recorded sightings
43
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Higher than most similar jobs

$137K–$165K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 71

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,018 similar postings that came down. Coming down is not always a hire.

Madhive is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • BigQuery
  • dbt
  • Looker
  • Tableau
Where the posting names them
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
- 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.
- 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 (e.g. dbt, Dataform, or similar; tool-agnostic).
- 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.
- 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.
- 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.

Your next step

Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.

Applying through Ashby

  • No account needed. “Autofill from resume” at the top of the form fills the key fields from your file.

Already applied? Track this application

Job description

View original posting ↗

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 Role:

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

What You’ll Do:

Client-Facing Insights

  • Help clients understand their performance and their utilization of our platform; where they’re succeeding, where they’re 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.

Internal Revenue Insights

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

Data Modeling and Analytics Engineering

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

Who You Are

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

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.

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

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
This is a hybrid role, working 3 days a week at Madhive HQ in New York City 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
Location & working pattern

New York, United States

- The ability to move comfortably between strategic planning, hands-on analysis, and technical execution. This is a hybrid role, working 3 days a week at Madhive HQ in New York City 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.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.