Senior Data Marketing Solution Analyst

This is a fully remote position, open to applicants in Massachusetts.

📋 Description

• Develop and enhance scalable omni-channel marketing data models, metadata frameworks, and automated processes aligned with marketing strategies and service needs.

• Convert marketing, fundraising, audience selection, and segmentation requirements into reusable SQL code and components within Snowflake.

• Create, test, document, and implement SQL-based models that facilitate audience selection, segmentation, quality control, reporting, reconciliation, and marketing operations.

• Identify, develop, maintain, monitor, and optimize workflow automations for data preparation, quality control, file generation/handling, and analysis.

• Design validation, exception handling, monitoring, alerts, and recovery protocols for automated processes.

• Collaborate with service owners and stakeholders to establish data requirements, business rules, success metrics, and acceptance criteria.

• Oversee assigned data projects from discovery to implementation, encompassing scope, planning, milestones, dependencies, risks, decisions, testing, and status updates.

• Investigate unfamiliar datasets to identify relevant tables and fields, and clarify source-data relationships.

• Assess query logic and results for accuracy, completeness, consistency, and adherence to business rules.

• Diagnose discrepancies through query tracing, source-record comparisons, and root-cause analysis.

• Evaluate and enhance query performance, including filters, joins, calculations, and overall query structure.

• Provide production data delivery and support coverage as required.

• Document reusable data sources, assumptions, query logic, business definitions, validation steps, limitations, and implementation decisions.

• Share findings, risks, and data limitations with marketing, operations, quality, and technical partners.

• Work collaboratively with BDO, Marketing Strategy, Service Teams, Fundraising OPS, Tech Solutions, Quality Control, and various cross-functional teams.

• Engage in station onboarding, campaign launches, vendor/client interactions, production meetings, and data working groups.

⛳️ Requirements

• Bachelor's degree or equivalent relevant professional experience.

• Practical experience managing large datasets for audience selection, segmentation, A/B testing logic, scoring-data integration, and outcome analysis for omni-channel marketing initiatives.

• Proven ability to independently write complex SQL queries, beyond simply executing or making minor modifications to pre-existing scripts.

• Proficiency 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 in writing, testing, troubleshooting, and maintaining Python scripts for structured data-file manipulation, validation, logging, and error handling.

• Ability to identify opportunities for process automation and transform workflows into sustainable solutions.

• Skill in designing automation controls that incorporate validation, exception handling, monitoring, alerts, and recovery procedures.

• Demonstrated project management capabilities, including requirements gathering, scope definition, work planning, milestone tracking, risk and dependency management, testing coordination, and status updates.

• Capacity to lead cross-functional initiatives without direct authority and advance projects from vague business needs to well-documented, implemented solutions.

• Experience validating large data outputs through record-level reviews, reconciliations, control totals, and comparisons with business requirements.

• Strong analytical, critical thinking, and problem-solving abilities.

• Competence in translating non-technical requirements into query logic and articulating data analyses to business stakeholders.

• Exceptional attention to detail and ability to manage multiple priorities in a deadline-driven environment.

• Clear documentation practices and organized management of query files, definitions, assumptions, and revisions.

• Proficiency in Microsoft Excel, Word, Teams, Outlook, and SharePoint.

• Capability to work effectively in a remote setting with minimal supervision.

• Preferred: Experience with 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 technologies.

🏝️ Benefits

• Flexible remote work arrangement.

• Support for professional development.

• Commitment to equal employment opportunities.

• Reasonable accommodations for applicants with disabilities.