Data Analytics & Engineering - Data Analyst V - Marketing Analytics

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

Immediate need for a talented Data Analytics & Engineering - Data Analyst V - Marketing Analytics. This is a 06+months contract opportunity with long-term potential and is located in New York ,NY (Hybrid).

Job ID:26-34825

Pay Range: $80 - $85/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

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

Key Requirements and Technology Experience:

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

Our client is a leading Social Media Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.