Data Analyst V

Orangepeople•San Francisco, NY

14h

About The Position

The Data Analyst V role uses advanced SQL and large, complex datasets to drive audience segmentation, audience strategy, and revenue opportunity sizing. The analyst translates findings into recommendations that shape business, product, and investment decisions, and partners with Data Scientists and Data Engineers to define data logic and pipelines behind audience and reporting systems. The role also presents clear, quantified insights to senior leadership and cross-functional partners. The position includes analyzing audiences and customer journeys, sizing revenue opportunities, defining analytical methodologies and assumptions, reconciling data across sources, and building automated reporting and self-service dashboards. It also translates audience definitions into campaign-ready segments and signals in partnership with campaign and lifecycle owners. Additional responsibilities include participating in OP team meetings, team-building, technical discussions and peer reviews; contributing to the OP-Wiki/Knowledge Base; and providing status reports to OP Account Management as requested.

Requirements

At least 7 years of experience in marketing analytics, data science, or business analytics.
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.
Experience owning audience or customer analysis end-to-end, including segmentation, revenue opportunity sizing, and quantitative business cases, with assumptions and limitations clearly articulated.
Ability to partner with Data Scientists and Data Engineers to define business logic and build data pipelines.
Experience managing complex, multi-source data across CRM, product, engagement, and third-party sources.
Experience establishing automated reporting and dashboards, such as Tableau.
Background in B2B marketing, sales, or customer analytics.
History of presenting to and influencing senior leadership on business or product decisions.
Ability to communicate effectively with technical and non-technical audiences.

Nice To Haves

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 experience across propensity, LTV, attribution, forecasting, and experiment design.
Fluency with CRM and account-level data models.
Advanced Google Sheets or Excel skills, including pivot tables, lookups, and complex formulas.
Basic Python skills for automation and API utilization.

Responsibilities

Deliver audience analysis, including segmentation, lifecycle and funnel analysis, growth and churn signals, and revenue and adoption attribution.
Size revenue opportunities and build business cases to prioritize audiences.
Define how business questions should be answered, including measures, methodology, and assumptions.
Pull, clean, and analyze large datasets using advanced SQL.
Reconcile data across sources and identify the root causes of discrepancies before they affect reporting.
Partner with Data Scientists and Data Engineers to define business logic, data models, and pipelines, and validate completed work.
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.
Participate in OP monthly team meetings and team-building efforts.
Contribute to OP technical discussions and peer reviews.
Contribute content and collaborate through the OP-Wiki/Knowledge Base.
Provide status reports to OP Account Management as requested.