Senior Data Marketing Solution Analyst - Full Time (Remote)

Contributor Development Partnership, PBC • Boston, MA

17d • Remote

About The Position

CDP, a Boston-based public benefit corporation, utilizes a collaborative fundraising model to enhance the operational efficiency and revenue generation of public media organizations. CDP offers outsourced marketing, data analytics, fundraising, and technology services to over 230 NPR and PBS public media organizations, helping them increase net income, grow donor files, reduce fundraising costs, and focus on local engagement. Since its inception, CDP has generated over $1 billion in membership revenue for participating local organizations and is the most adopted Public Media service. CDP is dedicated to supporting both public media organizations and the professional development of its team members. The Business Data Operations (BDO) Team, part of the Fundraising OPS Department, manages critical fundraising functions including the Member Service Bureau (MSB) cooperative, Partner Services, and the Audience Activation Platform (AAP). The BDO Team is responsible for data marketing operations, including data delivery for the MSB cooperative's direct mail program, which dispatches over 10 million solicitations annually for more than 50 public media clients.

Requirements

• Demonstrated ability and hands-on experience working with large data sets to build audience selection, segmentation, A/B split logic, and integrating scoring data for omni-channel marketing campaigns (text, email, direct mail, phone, canvassing) and outcome analysis.
• Demonstrated ability and hands-on experience independently writing complex SQL queries; experience must extend beyond executing or making minor edits to prewritten scripts.
• Expertise building and using views, models, relational data structures, procedures, notebooks, and functions employing joins, common table expressions, subqueries, aggregate and window functions, conditional logic, data-type handling, and other SQL techniques.
• Demonstrated ability and hands-on experience writing, testing, troubleshooting, and maintaining Python scripts for data file manipulation, including structured file handling, validation, logging, and error handling.
• Experience identifying process-automation opportunities and converting current-state workflows into clearly defined future-state requirements and maintainable solutions.
• Ability to design automation controls and assess results using validation, exception handling, monitoring, alerts, recovery procedures, effort saved, error reduction, cycle time, adoption, reliability, and increased service capacity.
• 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 an ambiguous business need to an implemented, documented solution.
• Experience validating output from large data sets through record-level review, reconciliations, control totals, and comparison to business requirements.
• Strong analytical, critical-thinking, and problem-solving skills, including the ability to investigate ambiguous data questions.
• Ability to translate nontechnical requirements into query logic, explain data output analysis and conclusions to business stakeholders.
• Strong attention to detail and proven ability to prioritize multiple requests in a deadline-driven environment.
• Clear written documentation practices and an organized approach to query files, definitions, assumptions, and revisions.
• Proficiency with Microsoft tools such as Excel, Word, Teams, Outlook, and SharePoint.
• Ability to work effectively in a remote environment with minimal direct supervision.
• Bachelor's degree or equivalent relevant work experience.

Nice To Haves

• Experience using Snowflake tools and features like Workspaces and Notebooks.
• Experience with digital marketing tools like Iterable.
• Experience working with fundraising, direct mail, donor analytics, and nonprofit data.
• Experience working with fundraising CRMs such as RevolutionCRM, Salesforce Nonprofit Cloud, Raiser's Edge, or a similar platform.
• Experience with reporting or analysis tools such as Tableau and advanced Excel functionality.
• Experience supporting new or growing data-enabled services, products, or operational programs.
• Experience automating recurring data preparation, validation, reporting, file generation, or operational workflows.
• Familiarity with DBT, GitHub, scheduling tools, APIs, or other modern data and automation tools sufficient to develop governed analytical models and controlled workflows; software engineering expertise is not required.
• Experience using project-management tools such as Asana and maintaining clear project plans, decision logs, or status reports.
• Passion for supporting the mission of public media and nonprofit organizations.

Responsibilities

• Builds and improves scalable omni-channel marketing data models, metadata frameworks, and process automations driven by marketing strategy and service requirements.
• Identifies opportunities to enhance existing model efficiency and design, test, and implement new models supporting CDP's evolving marketing strategy for MSB Cooperative, AAP, and Partner Services.
• Works closely with Data Marketing Specialists on the BDO team to provide production data delivery and support coverage.
• Collaborates on data model development and process improvements.
• Partners with Quality Control to identify opportunities to automate manual processes and improve error rates.
• Translates marketing strategy, fundraising, and audience selection/segmentation requirements into reusable SQL code and components in Snowflake.
• Identifies, develops, and maintains workflow-based automations for repetitive, manual, high-volume, or error-prone processes (data preparation, quality control, file generation/handling, analysis), reducing manual effort without sacrificing data quality or operational controls.
• Designs validation, exception handling, monitoring, alerts, and recovery procedures for automated processes.
• Partners with service owners and business stakeholders to define data requirements, business rules, success measures, and acceptance criteria for new or enhanced models.
• Manages assigned data projects from discovery through implementation, defining scope, work plans, milestones, dependencies, risks, decisions, testing activities, and status communications.
• Explores unfamiliar datasets, identifies appropriate tables and fields, and determines data source relationships before developing outputs.
• Evaluates query logic and results for accuracy, completeness, consistency, and alignment with business rules; troubleshoots discrepancies.
• Assesses query performance and makes improvements; escalates platform or pipeline issues when appropriate.
• Documents reusable data sources, assumptions, query logic, business definitions, validation steps, known limitations, and implementation decisions.
• Communicates findings, risks, and data limitations clearly to marketing, operations, quality, and technical partners.
• Provides coverage for data delivery and production work when needed.
• Researches data questions, performs root cause analysis, validates model and automation outputs, troubleshoots discrepancies, and communicates findings and limitations.
• Participates in regular, ad-hoc, and project meetings with cross-functional teams.
• Participates in planning sessions for onboarding new stations, campaign kick-offs, vendor and client interfacing, and production meetings.

Benefits

• Commitment to supporting each team member in their professional development.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree