Senior Marketing Analyst V, Audience Strategy & Insights

Crystal Equation; New York (NY); Hybrid; USD 102,000 - 109,000; Full time

Benefits offered by this job

Paid time off

Medical/dental/vision insurance

401K

Parental leave

Job summary

Crystal Equation is seeking a Senior Marketing Analyst V to join Audience Strategy & Insights. You will perform deep analytics, build segmentation models, size revenue opportunities, and influence leadership with quantified insights.

You'll partner with Data Scientists and Data Engineers to shape data pipelines and reporting, turning complex datasets into actionable business recommendations and self-service dashboards for cross-functional teams.

Qualifications

• 7+ years in marketing analytics, data science, or business analytics with quantitative/technical background.
• Expert-level SQL including complex queries, CTEs, window functions, and optimization on large datasets.
• Proven track record owning end-to-end audience or customer analysis with segmentation, revenue sizing, and business cases.
• Ability to partner with Data Scientists and Data Engineers to define logic, build data pipelines, and stand up automated reporting/dashboards (e.g., Tableau).

Responsibilities

• Deliver deep audience analysis including segmentation, lifecycle and funnel analysis, revenue and adoption attribution.
• Size revenue opportunities and build business cases for prioritizing audiences.
• Define how business questions should be answered including metrics, methodology, and assumptions.
• Pull, clean, and analyze large datasets (millions of records) using advanced SQL.
• Reconcile data across sources and resolve discrepancies before reporting.
• Partner with data teams to define business logic, data models, and pipelines; validate outputs.
• Build automated reporting and self-service dashboards for recurring needs.
• Translate audience definitions into campaign-ready segments and signals with stakeholders.
• Present findings and recommendations to senior leadership and cross-functional partners.

Skills

SQL

Data analysis

Audience segmentation

Dashboarding

Cross-functional partnering

Education

Bachelor's degree in quantitative field

Tools

Tableau

dbt

Airflow

Hive

Unidash

Job description

Senior Marketing Analyst V, Audience Strategy & Insights

Hybrid Summary Our Business Messaging Marketing team is seeking a Senior Marketing Analyst who is both technically deep and business-minded. 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.

Requirements

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

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.

Pay range is $74 - $79 per hour with full benefits available, including paid time off, medical/dental/vision/life insurance, 401K, parental leave, and more. Our compensation reflects the cost of labor across several US geographic markets. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience.

THE PROMISES WE MAKE:

At Crystal Equation, we empower people and advance technology initiatives by building trust. Your recruiter will prep you for the interview, obtain feedback, guide you through any necessary paperwork and provide everything you need for a successful start. We will serve to empower you along the way and provide the path for your professional journey. For more information regarding our Privacy Policy, please visit crystalequation.com/privacy.