Senior Data Marketing Solution Analyst

🕒 6 days ago

🍂 Massachusetts – Remote

🍂 Massachusetts – Remote

💵 $80k - $95k / year

⏰ Full Time

🟠 Senior

🎡 Marketing

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CDP Community

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2011

💼 Consulting

📣 Marketing

🤝 Non-profit

Consulting • Marketing • Non-profit

CDP Community is a nonprofit partnership that helps public media stations increase fundraising through collaborative best practices, technology, and shared services. They develop and scale proven marketing and fundraising strategies via CDP Labs, provide CRM and marketing-automation platforms and reporting, and offer a full-service Member Services Bureau that handles transactional and analytic work so stations can focus on engagement and major-donor relationships.

📋 Description

• Build and improve scalable omni-channel marketing data models, metadata frameworks, and process automations driven by marketing strategy and service requirements • Translate marketing, fundraising, audience-selection, and segmentation requirements into reusable SQL code and components in Snowflake • Design, test, document, and implement SQL-based models supporting audience selection, segmentation, quality control, reporting, reconciliation, and marketing operations • Identify, develop, maintain, monitor, and improve workflow automations for data preparation, quality control, file generation/handling, and analysis • Design validation, exception handling, monitoring, alerts, and recovery procedures for automated processes • Partner with service owners and stakeholders to define data requirements, business rules, success measures, and acceptance criteria • Manage assigned data projects from discovery through implementation, including scope, plans, milestones, dependencies, risks, decisions, testing, and status communications • Explore unfamiliar datasets, identify appropriate tables and fields, and determine source-data relationships • Evaluate query logic and results for accuracy, completeness, consistency, and business-rule alignment • Troubleshoot discrepancies through query tracing, source-record comparisons, and root-cause analysis • Assess and improve query performance, including filters, joins, calculations, and query structure • Provide production data-delivery and support coverage when needed • Document reusable data sources, assumptions, query logic, business definitions, validation steps, limitations, and implementation decisions • Communicate findings, risks, and data limitations to marketing, operations, quality, and technical partners • Collaborate with BDO, Marketing Strategy, Service Teams, Fundraising OPS, Tech Solutions, Quality Control, and other cross-functional teams • Participate in station onboarding, campaign kick-offs, vendor/client interfacing, production meetings, and data working groups

🎯 Requirements

• Bachelor's degree or equivalent relevant work experience • Hands-on experience working with large data sets for audience selection, segmentation, A/B split logic, scoring-data integration, and outcome analysis for omni-channel marketing campaigns • Independent experience writing complex SQL queries beyond executing or making minor edits to prewritten scripts • Expertise with SQL views, models, relational data structures, procedures, notebooks, functions, joins, common table expressions, subqueries, aggregate and window functions, conditional logic, and data-type handling • Experience writing, testing, troubleshooting, and maintaining Python scripts for structured data-file manipulation, validation, logging, and error handling • Experience identifying process-automation opportunities and converting workflows into maintainable solutions • Ability to design automation controls using validation, exception handling, monitoring, alerts, and recovery procedures • Demonstrated project-management skills, including requirements gathering, scope definition, work planning, milestone tracking, risk and dependency management, testing coordination, and status reporting • Ability to lead cross-functional work without direct authority and move projects from ambiguous business needs to implemented, documented solutions • Experience validating large-data outputs through record-level review, reconciliations, control totals, and comparison with business requirements • Strong analytical, critical-thinking, and problem-solving skills • Ability to translate nontechnical requirements into query logic and explain data analyses to business stakeholders • Strong attention to detail and ability to prioritize multiple requests in a deadline-driven environment • Clear written documentation practices and organized query-file, definition, assumption, and revision management • Proficiency with Microsoft Excel, Word, Teams, Outlook, and SharePoint • Ability to work effectively in a remote environment with minimal direct supervision • Preferred: Snowflake Workspaces and Notebooks, Iterable, fundraising/direct mail/donor analytics/nonprofit data, fundraising CRMs, Tableau, advanced Excel, DBT, GitHub, scheduling tools, APIs, Asana, and related data/automation tools

🏖️ Benefits

• Remote work arrangement • Professional development support • Equal employment opportunity • Reasonable accommodations for applicants with disabilities