Senior Data Marketing Solution Analyst
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior analyst building Snowflake and Python marketing data models and automations. Supporting CDP’s public media fundraising, audience activation, and data-delivery services.
Responsibilities:
- 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
Similar Jobs
Senior Channel Field Marketing
Senior channel marketer driving co-marketing programs and partner pipeline for Horizon3’s autonomous cybersecurity platform. Managing MDF, field programs, attribution, and ROI across the South Central U.S.
Senior Field Marketing Manager
Senior Field Marketing Manager owning Northwest regional programs for Horizon3’s autonomous cybersecurity platform. Connecting events, ABM, digital campaigns, and SDR alignment to measurable pipeline.
Senior Marketing Campaigns Manager, ABM
Senior ABM manager driving account-based marketing and integrated campaigns for Horizon3’s autonomous cybersecurity platform. Orchestrating webinars, multi-channel programs, and Sales alignment to accelerate pipeline.
Technical Marketing Expert, Claude
Technical Marketing Expert für digitale Gesundheitslösungen zur Verbesserung der Frauengesundheit. Verantwortlich für Kampagnen, Tracking, Landingpages und KI-gestützte Creatives.
Channel Partner Marketing Manager
Channel Partner Marketing Manager enabling SCIEX’s EMEA distributor network. Driving partner campaigns, events, lead governance, and marketing KPIs for life sciences solutions.
Regional Marketing Coordinator
Remote Regional Marketing Coordinator overseeing senior living communities for Tutera. Driving sales growth through site visits, lead conversion, reporting, and strategic referral partnerships.
Regional Marketing Coordinator
Remote Regional Marketing Coordinator overseeing senior living communities, site visits, reporting, and lead conversion. Driving regional census growth and strategic referral partnerships for Tutera.
Regional Marketing Coordinator
Remote Regional Marketing Coordinator overseeing senior living communities, site visits, referrals, and lead conversion. Driving census growth for Tutera Senior Living & Health Care.
Director, OPX Global Marketing
Marketing director leading OPX market intelligence, digital campaigns and commercial growth. Supporting Westinghouse’s global clean nuclear energy solutions through strategic marketing and AI-enabled practices.
Senior DTC Web Marketing Manager
DTC web marketing manager optimizing Nordic Naturals’ Shopify storefronts, analytics, and conversion funnels. Driving digital revenue through CRO, CRM, testing, and consumer web strategy.
Senior Manager, Shopper Marketing
Sr. Manager leading shopper marketing, retail media, and omnichannel activation for Nordic Naturals’ U.S. omega-3 supplement brand. Bridging brand strategy, sales, and retail execution.
Marketing Coordinator
Marketing Coordinator supporting campaign execution, content, analytics, and research for Cengage, a global digital education company serving millions of learners.
Associate Marketing Manager
Associate Marketing Manager developing acquisition and product marketing strategies for Cengage, a global education technology company. Managing campaigns, analytics, and cross-functional initiatives.
Experiential Marketing Coordinator
Experiential Marketing Coordinator executing fitness, running, and wellness brand experiences for BibRave. Managing vendors, timelines, activations, reporting, and client communications remotely.
Senior Media Buyer
Senior Media Buyer managing paid acquisition campaigns across major ad platforms for an international iGaming and digital entertainment marketing company. Optimising budgets, audiences and creatives across multiple markets.
Marketing Manager – Customer Advocacy
Marketing Manager scaling Darktrace’s customer advocacy program for AI-driven cybersecurity. Turning customer outcomes into stories, reviews, references, and growth-driving proof.
Manager, Integrated Account Based Marketing – Government & Collection Services
ABM Manager leading multichannel government and collections campaigns for TP, a global digital business services provider. Driving pipeline through personalized account targeting, events, and marketing technology.
Media Buyer, UAC
Media buyer, який масштабує прибуткові Google UAC кампанії в DEVILS — східноєвропейській affiliate-медіабаїнговій компанії. Управління глобальним трафіком і кампаніями з бюджетами від $30K.
Marketing Intern
Marketing Intern supporting BOLD Magazine’s digital campaigns, social media, SEO, and email marketing. Creating content, researching markets, and tracking campaign performance.
Marketing Specialist
Marketing Specialist driving regional campaigns, digital media, and franchisee events for Fix Network’s automotive service brands. Building awareness, traffic, loyalty, and community engagement across the United States.