Senior Marketing Analyst

Ready to transform how millions of customers connect with us? We’re hunting for a Senior Marketing Analyst with top-tier Salesforce Data Cloud expertise and razor-sharp SQL skills to turbocharge our Marketing Analytics team. If you’re passionate about crafting powerful audience signals, building complex segments, and partnering with data engineers to unlock game-changing insights, this is your chance to make a massive impact. Join us, lead the data-driven revolution, and help shape the future of marketing at scale. 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.