Senior Marketing Analytics Data Analyst - Hybrid NYC

Pyramid Consulting, Inc; Village of Nyack (NY); Hybrid; USD 110,000 - 117,000; Full time

Job summary

Pyramid Consulting, Inc. seeks a Data Analytics & Engineering - Data Analyst V specializing in Marketing Analytics for a 6+ month hybrid engagement in New York, NY. The role focuses on audience analysis, revenue attribution, and building scalable analytics pipelines using SQL, dbt, and orchestration tools.

You will collaborate with data scientists and engineers, develop self-service dashboards, and present insights to senior leadership. Prior experience with CRM/data platforms is preferred.

Qualifications

• 7+ years in marketing analytics, data science, or business analytics.
• Bachelor’s degree in a quantitative, technical, or business field, or equivalent.
• Expert-level SQL skills, including complex queries, CTEs, window functions, and query optimization.
• Proven track record of end-to-end audience or customer analysis: segmentation, revenue opportunity sizing, and quantitative business cases.
• Demonstrated ability to partner with Data Scientists and Data Engineers to manage complex multi-source data and build automated reporting.
• Background in B2B marketing, sales, or customer analytics, with experience presenting to senior leadership.
• 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.
• Exposure to Salesforce Marketing Cloud and marketing automation workflows.
• Statistical modeling experience across propensity, LTV, attribution, forecasting, and experiment design.
• Fluency with CRM and account-level data models.
• Advanced skills in Client Sheets/Excel, including pivot tables and complex formulas.
• Basic Python for automation and API utilization.

Responsibilities

• Deliver deep audience analysis, including segmentation, lifecycle and funnel analysis, growth and churn signals, and revenue attribution.
• Size revenue opportunities and build the business case for audience prioritization.
• Define methodologies for answering business questions, including measurement 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 Scientists and Data Engineers to define business logic and validate data pipelines.
• Build automated reporting and self-service dashboards for recurring business needs.
• Translate audience definitions into campaign-ready segments in collaboration with campaign owners.
• Present findings and recommendations to senior leadership and cross-functional teams.

Skills

SQL

Advanced data analysis

Cross-functional collaboration

Python basics

Excel (pivot tables, formulas)

Education

Bachelor’s degree in quantitative/technical/business field

Tools

dbt

Airflow

Hive

Unidash

Salesforce Data Cloud

Salesforce Marketing Cloud

Job description

Pyramid Consulting, Inc. seeks a Data Analytics & Engineering - Data Analyst V specializing in Marketing Analytics for a 6+ month hybrid engagement in New York, NY. The role focuses on audience analysis, revenue attribution, and building scalable analytics pipelines using SQL, dbt, and orchestration tools.

You will collaborate with data scientists and engineers, develop self-service dashboards, and present insights to senior leadership. Prior experience with CRM/data platforms is preferred.