Data Analyst Lead

Description

The company is a local media operating system used by media professionals to run businesses, with a platform that reaches local audiences at national scale through premium supply partnerships.

Its tools cover planning, targeting, and measuring full-funnel campaign results, and it serves over 30,000 small and medium businesses each day.

Responsibilities

• Turn data into clear answers the business can act on by building well-modeled data marts for reporting, then sharing the insights with internal teams and customers.
• Own analytics projects from scoping and data modeling through delivery and explaining the results.
• Work with the Revenue team (Sales and Client Success), customers, and partners in Finance, Product, and Marketing, writing advanced SQL and building dashboards and analyses with clear takeaways.
• Help clients see how they use the platform, where they are doing well, where they are missing opportunity, and what to do next.
• Work directly with Sales, Client Success, and customers to scope new analyses and turn their questions into clear requirements.
• Prepare dashboards and analyses for client meetings such as QBRs and JBPs that are easy to read and act on.
• Support internal revenue analytics, including pacing, forecasting, and product adoption, so leadership has the metrics to guide the business.
• Find performance trends, business opportunities, and data quality problems, and turn them into clear recommendations.
• Build and maintain the data marts and models that serve as the trusted base, so client-facing and internal numbers reconcile and are correct.
• Write and review advanced SQL to transform, validate, and analyze large, complex datasets.
• Apply tested, documented, version-controlled transformations (such as dbt, Dataform, or similar) to the data modeling layer.
• Investigate and fix data discrepancies and reporting inconsistencies across systems.
• Balance urgent reporting needs against the long-term scalability of the data models.

Requirements

• Have 5 or more years of professional experience in data analytics, business intelligence, analytics engineering, or a related field.
• Hold a bachelor's degree in data analytics, computer science, statistics, mathematics, engineering, or a related field, or have equivalent practical experience.
• Be highly skilled in SQL and have worked with Google BigQuery or a comparable cloud data platform.
• Have analytics engineering experience, including building data marts, dimensional models, and tested, documented transformations with tools such as dbt, Dataform, or similar. The tool choice is flexible.
• Have owned analytics or reporting projects from requirements gathering through to implementation.
• Be highly skilled with reporting and visualization tools such as Looker, Tableau, Domo, Datorama, Looker Studio, TapClicks, or similar.
• Have strong experience wrangling, exploring, cleaning, validating, and analyzing large datasets.
• Be able to find insights and turn them into practical business and product recommendations.
• Communicate well in writing and speaking, and work effectively with client-facing stakeholders and business leaders.
• Work independently, manage competing priorities, and make sound decisions in a changing environment.
• Optional: experience in advertising technology, streaming television, digital media, campaign measurement, or marketing analytics.
• Optional: experience building customer-facing analytics or reporting products.
• Optional: a strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting.
• Optional: a record of improving reporting accuracy, automation, scalability, or operational efficiency.
• Optional: the ability to move comfortably between strategic planning, hands-on analysis, and technical execution.

Conditions

This is a hybrid role with 3 days a week at the New York City headquarters.

The approximate pay range is $137,000-$165,000. The final offer depends on total compensation and benefits, as well as experience, knowledge, skills, abilities, and internal equity.

The company does not use third-party recruiting agencies for this search.

The company welcomes applicants of all backgrounds, including differences in education, culture, opinion, race, ethnicity, gender identity, veteran status, religion, disability, sexual orientation, and beliefs.