[Hiring] Senior Data Marketing Solution Analyst @Contributor Development Partnership, PBC

Role Description

The Senior Data Marketing Solution Analyst builds and improves scalable omni-channel marketing data models, metadata frameworks, and process automations driven by marketing strategy and service requirements. This role’s work includes identifying opportunities to enhance existing model efficiency and design, test and implement new models that support evolving and growing CDP marketing strategy for the MSB Cooperative, AAP and Partner Services.

This role works closely with the Data Marketing Specialists on the BDO team to provide production data delivery and support coverage when needed and collaborates on data model development and process improvements. This role also partners with Quality Control to identify opportunities to automate manual processes and continually improve error rates.

Key Responsibilities

• Translate marketing strategy, fundraising, and audience selection and segmentation requirements into reusable SQL code and components in Snowflake.
• Identify, develop and maintain workflow-based automations for repetitive, manual, high-volume, or error-prone processes involving data preparation, quality control, file generation and handling, and analysis.
• Design validation, exception handling, monitoring, alerts, and recovery procedures for automated processes.
• Partner with service owners and business stakeholders to define data requirements, business rules, success measures, and acceptance criteria for new or enhanced models.
• Manage assigned data projects from discovery through implementation.
• Explore unfamiliar datasets, identify appropriate tables and fields, and determine how data sources relate before developing outputs.
• Evaluate query logic and results for accuracy, completeness, consistency, and alignment with documented business rules.
• Assess query performance and make improvements to filters, joins, calculations, and query structure.
• Document reusable data sources, assumptions, query logic, business definitions, validation steps, known limitations and implementation decisions.
• Communicate findings, risks, and data limitations clearly to marketing, operations, quality, and technical partners.

Essential Functions

• 40%: Data marketing model and framework development - design, test, document, and implement SQL-based models in Snowflake.
• 25%: Process scale and automation - use Snowflake components, SQL, Python, and approved workflow tools to identify automation opportunities.
• 20%: Data delivery and quality control - provide coverage when needed for data delivery and production work.
• 15%: Collaboration and projects - participating in regular, ad-hoc and project meetings with cross-functional teams.

Qualifications

• 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.
• Demonstrated ability and hands-on experience independently writing complex SQL queries.
• Expertise building and using views, models, relational data structures, procedures, notebooks, and functions.
• Demonstrated ability and hands-on experience writing, testing, troubleshooting, and maintaining Python scripts for data file manipulation.
• Experience identifying process-automation opportunities and converting current-state workflows into clearly defined future-state requirements.
• Ability to design automation controls and assess results.
• Demonstrated project-management skills, including requirements gathering and scope definition.
• Ability to lead cross-functional work without direct authority.
• Experience validating output from large data sets through record-level review.
• Strong analytical, critical-thinking, and problem-solving skills.
• Ability to translate nontechnical requirements into query logic.
• Strong attention to detail and proven ability to prioritize multiple requests.
• Clear written documentation practices and an organized approach to query files.
• Proficiency with Microsoft tools such as Excel, Word, Teams, Outlook, and SharePoint.
• Ability to work effectively in a remote environment with minimal direct supervision.

Preferred Qualifications (Not Required)

• Experience using Snowflake tools and features.
• Experience with digital marketing tools like Iterable.
• Experience working with fundraising, direct mail, donor analytics, and nonprofit data.
• Experience with fundraising CRMs such as RevolutionCRM, Salesforce Nonprofit Cloud, or Raiser's Edge.
• 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.
• Experience using project-management tools such as Asana.
• Passion for supporting the mission of public media and nonprofit organizations.

Role Boundaries

The Senior Data Marketing Solution Analyst owns query-based analysis, SQL-based analytical data models, Python-enabled process automation, data marketing framework development and projects for assigned data marketing initiatives.

Educational Requirements

• Bachelor's degree or equivalent relevant work experience.

Commitment to Inclusion

We strongly encourage individuals from historically marginalized and underrepresented groups to apply, even if you don’t meet every qualification. We value diverse perspectives, lived experiences, and commitment to public service.