Senior Data Marketing Solution Analyst

🕒 vor 11 Tagen

🍂 Massachusetts – Remote

🍂 Massachusetts – Remote

💵 $80.000 - $95.000 / Jahr

⏰ Vollzeit

🟠 Senior

🎡 Marketing

👻 Geisterscore 0%

Was es bedeutet: wie wahrscheinlich diese Stelle offen bleibt, ohne dass aktiv eingestellt wird.So liest du es: 60 % oder höher heißt, wir halten das für einen Geisterjob. Niedrigere Werte sind weniger bedenklich.Wie wir werten: Dauer offen, Neuveröffentlichungen, offene Stellen vs Teamgröße, wie schnell Stellen geschlossen werden, und ob ein Gehalt angegeben ist.Hinweis: eine Schätzung aus öffentlichen Daten, kein Urteil über das Unternehmen. Echte Stellen können hoch punkten, nutze es also als Hinweis, nicht als Fakt.

Jetzt Bewerben

Ähnliche Remote-Jobs finden

E-Mail-Benachrichtigung für neue Jobs einrichten

📊 Überprüfen Sie Ihre Lebenslauf-Bewertung für diese Stelle

Verbessern Sie Ihre Chancen auf ein Vorstellungsgespräch, indem Sie Ihre Lebenslauf-Bewertung vor der Bewerbung überprüfen.

Lebenslauf hochladen

CDP Community

WebsiteLinkedInAlle Stellen

51 - 200 Mitarbeiter

Gegründet 2011

💼 Beratung

📣 Marketing

🤝 Non-Profit

Consulting • Marketing • Non-profit

CDP Community ist eine gemeinnützige Partnerschaft, die öffentlichen Medienanstalten hilft, ihre Fundraising-Aktivitäten durch kollaborative Best Practices, Technologie und gemeinsame Dienste zu steigern. Sie entwickeln und skalieren erprobte Marketing- und Fundraising-Strategien über die CDP Labs, bieten CRM- und Marketing-Automatisierungsplattformen sowie Berichte an und betreiben ein Full-Service-Mitgliederservicebüro, das transaktionale und analytische Arbeiten übernimmt, damit sich die Stationen auf Engagement und Beziehungen zu größeren Spendern konzentrieren können.

Beschreibung

• 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

🎯 Anforderungen

• 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

🏖️ Vorteile

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