Data Analyst (Senior Marketing Analyst, Audience Strategy & Insights)

OP

New York (NY)

On-site

USD 110,000 - 170,000

Full time

26 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

401(k)
Dental Insurance
Health insurance
Vision insurance
Equal opportunity employer

Job summary

OP is seeking a Senior Marketing Analyst to drive audience segmentation, strategy, and revenue opportunity sizing using expert SQL on large datasets. You will partner with Data Scientists and Engineers to shape data pipelines and reporting, influencing senior leadership with quantified insights.

You will own end-to-end audience analysis, build dashboards, and translate insights into actionable recommendations for business, product, and investment decisions.

Qualifications

  • 7+ years in marketing analytics, data science, or business analytics with quantitative degree.
  • Expert SQL skills: complex queries, CTEs, window functions, multi-million record datasets.
  • Experience owning end-to-end audience analysis: segmentation, revenue sizing, business cases.

Responsibilities

  • Deliver deep audience analysis: segmentation, funnel, churn signals, revenue opportunities.
  • Define measurement and methodology for business questions.
  • Pull, clean, and analyze large datasets with advanced SQL; reconcile data across sources.
  • Partner with Data Scientists/Engineers to define logic, models, and pipelines.
  • Build automated reporting and self-service dashboards for recurring needs.
  • Translate audience definitions into campaign-ready segments with stakeholders.
  • Present findings to senior leadership and cross-functional partners.

Skills

Advanced SQL
Audience analytics
Data storytelling
Cross-functional
Leadership partnerships

Education

Bachelor's degree in a quantitative/technical/business field

Tools

Tableau
dbt
Airflow
Hive
Unidash
Salesforce Data Cloud

Job description

We are looking for an experienced Senior Marketing Analyst who is both technically deep and business-minded to join our team. This role uses expert SQL and large, complex datasets to drive audience segmentation, audience strategy, and revenue opportunity sizing, and translates that analysis into recommendations that shape business, product, and investment decisions. The ideal candidate is comfortable partnering with Data Scientists and Data Engineers to define the data logic and pipelines behind audience and reporting systems, and has a track record of influencing senior leadership with clear, quantified insights.

Responsibilities
  • Deliver deep audience analysis, including segmentation, lifecycle and funnel analysis, growth and churn signals, and revenue and adoption attribution. Size revenue opportunities and build the business case for which audiences to prioritize.
  • Define how a business question should be answered, including what to measure, the methodology to use, and which assumptions apply.
  • Pull, clean, and analyze large datasets (millions of records) using advanced SQL. Reconcile data across sources and root-cause discrepancies before they reach reporting.
  • Partner with Data Scientists and Data Engineers to define business logic, data models, and pipelines, and validate what is built.
  • Build automated reporting and self-service dashboards for recurring business needs.
  • Translate audience definitions into campaign-ready segments and signals in partnership with campaign and lifecycle owners.
  • Present findings and recommendations to senior leadership and cross-functional partners.
Minimum Qualifications
  • Minimum 7 years in marketing analytics, data science, or business analytics, and a Bachelor's degree in a quantitative, technical, or business field, or equivalent.
  • Expert-level SQL, including complex queries, CTEs, window functions, and query optimization across datasets of millions of records.
  • Proven track record of owning audience or customer analysis end-to-end: segmentation, revenue opportunity sizing, and quantitative business cases, with assumptions and limitations clearly articulated.
  • Demonstrated ability to partner with Data Scientists and Data Engineers to define business logic and build data pipelines, manage complex multi-source data across CRM, product, engagement, and third-party sources, and stand up automated reporting and dashboards (e.g., Tableau).
  • Background in B2B marketing, sales, or customer analytics, with a history of presenting to and influencing senior leadership on business or product decisions, and communication that lands with both technical and non-technical audiences.
Preferred Qualifications
  • Hands-on pipeline building with dbt, Airflow, or equivalent orchestration tools.
  • Familiarity with Hive and Unidash, or comparable large-scale query and dashboarding environments.
  • Working knowledge of a customer data platform, preferably Salesforce Data Cloud, including segment creation, Calculated Insights, and activation.
  • Exposure to Salesforce Marketing Cloud and marketing automation workflows.
  • Statistical modeling across propensity, LTV, attribution, forecasting, and experiment design.
  • Fluency with CRM and account-level data models.
  • Advanced Google Sheets/Excel, including pivot tables, lookups, and complex formulas.
  • Basic Python for automation and API utilization.
Benefits
  • 401(k).
  • Dental Insurance.
  • Health insurance.
  • Vision insurance.
  • We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
  • The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
Additional Responsibilities
  • Participate in OP monthly team meetings and participate in team-building efforts.
  • Contribute to OP technical discussions, peer reviews, etc.
  • Contribute content and collaborate via the OP-Wiki/Knowledge Base.
  • Provide status reports to OP Account Management as requested.
About Us

At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we ve been challenging the status quo of the consulting industry serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Marketing Analyst - Audience Strategy & Customer Insights
Senior Marketing Analyst - Audience Strategy & Customer Insights

Intelliswift • San Francisco (CA)

On-site
USD 110,000 - 165,000
Program Manager III
Program Manager III

OP • New York (NY)

On-site
USD 120,000 - 180,000
401(k)
Dental Insurance
Health insurance
+1
Audience & Data Strategy Director
Audience & Data Strategy Director

OMGCA Omnicom Media Group Canada • New York (NY)

Hybrid
CAD 105,000 - 115,000
Generous paid time off
Hybrid work model
Formal training opportunities
+2
Director, Audience Analytics
Director, Audience Analytics

Interpublic • United States

On-site
USD 145,000 - 175,000
Senior Marketing Analytics: Revenue & Audience Insights
Senior Marketing Analytics: Revenue & Audience Insights

OP • New York (NY)

On-site
USD 110,000 - 170,000
401(k)
Dental Insurance
Health insurance
+2
Manager, Data Operations
Manager, Data Operations

Interpublic • United States

On-site
USD 50,000 - 95,000
In-office schedule
Executive Director, Business Analytics
Executive Director, Business Analytics

Interpublic • United States

On-site
USD 150,000 - 250,000
Data Analyst V
Data Analyst V

Akidev Corporation • New York (NY)

On-site
USD 120,000 - 180,000
Senior Marketing Analyst – Audience Strategy & Insights-6376
Senior Marketing Analyst – Audience Strategy & Insights-6376

itD Tech • San Jose (CA)

Hybrid
USD 69,000 - 72,000
Medical benefits
401k plan
Paid holidays
SVP, Business Analytics
SVP, Business Analytics

Omnicom Media • New York (NY)

On-site
USD 220,000 - 250,000