Are you a data-driven marketing expert with advanced SQL skills and deep expertise in Salesforce Data Cloud? We're on the hunt for a seasoned professional to lead the charge in transforming our audience segmentation capabilities. In this pivotal role, you will craft sophisticated audience signals, develop intricate segments within Salesforce Data Cloud, and collaborate closely with data engineers to build resilient data pipelines that power innovative marketing campaigns reaching millions of customers. If you thrive in a fast-paced environment and are passionate about leveraging data to drive impactful marketing strategies, we want to hear from you!
Key Responsibilities:
Build and maintain audience segments in Salesforce Data Cloud, including signal identification, Calculated Insights (SQL), and activation to SFMC.
Partner with Data Engineers to design and build data pipelines that feed marketing, reporting and audience systems.
Develop automated reporting solutions and self-service dashboards to track campaign performance and marketing KPIs.
Pull, clean, and analyze large datasets (millions of records) to deliver audience strategy, segmentation, and revenue opportunity sizing.
Ensure data quality and troubleshoot data discrepancies across the audience and reporting systems.
Translate business requirements into technical audience definitions and partner with campaign managers on complex builds.
Required Qualifications:
Minimum 7 years of experience in marketing analytics, data engineering, data science, or a related analytics role.
Expert-level SQL skills: complex queries, CTEs, window functions, query optimization, and working with large datasets (millions of records).
Hands-on experience with Salesforce Data Cloud (or similar CDPs), including segment creation, Calculated Insights, and activation workflows.
Experience building audience signals and audience segments for marketing campaigns.
Proven experience partnering with Data Engineers to build and maintain data pipelines.
Strong experience with report automation: scheduled reports, automated data refreshes, and self-service dashboards.
Proficiency in data visualization tools such as Tableau, Hive, or similar.
Advanced Google Sheets/Excel skills.
Basic Python skills for automation and API utilization.
Excellent communication skills with the ability to translate technical concepts for non-technical stakeholders.
Preferred Qualifications:
Experience with Salesforce Marketing Cloud (SFMC) and marketing automation workflows.
Familiarity with CRM data structures and account-level data models.
Background in B2B marketing analytics.
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. PDN-a1069434-dba2-499f-bb82-83f441ca97f2
Build and maintain audience segments in Salesforce Data Cloud, including signal identification, Calculated Insights (SQL), and activation to SFMC.
Partner with Data Engineers to design and build data pipelines that feed marketing, reporting and audience systems.
Develop automated reporting solutions and self-service dashboards to track campaign performance and marketing KPIs.
Pull, clean, and analyze large datasets (millions of records) to deliver audience strategy, segmentation, and revenue opportunity sizing.
Ensure data quality and troubleshoot data discrepancies across the audience and reporting systems.
Translate business requirements into technical audience definitions and partner with campaign managers on complex builds.
Required Qualifications:
Minimum 7 years of experience in marketing analytics, data engineering, data science, or a related analytics role.
Expert-level SQL skills: complex queries, CTEs, window functions, query optimization, and working with large datasets (millions of records).
Hands-on experience with Salesforce Data Cloud (or similar CDPs), including segment creation, Calculated Insights, and activation workflows.
Experience building audience signals and audience segments for marketing campaigns.
Proven experience partnering with Data Engineers to build and maintain data pipelines.
Strong experience with report automation: scheduled reports, automated data refreshes, and self-service dashboards.
Proficiency in data visualization tools such as Tableau, Hive, or similar.
Advanced Google Sheets/Excel skills.
Basic Python skills for automation and API utilization.
Excellent communication skills with the ability to translate technical concepts for non-technical stakeholders.
Preferred Qualifications:
Experience with Salesforce Marketing Cloud (SFMC) and marketing automation workflows.
Familiarity with CRM data structures and account-level data models.
Background in B2B marketing analytics.
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. PDN-a1069434-dba2-499f-bb82-83f441ca97f2