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, reducing manual effort without sacrificing data quality or operational controls.
• Design validation, exception handling, monitoring, alerts, and recovery procedures so automated processes remain reliable and supportable after implementation.
• 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 by defining scope, work plans, milestones, dependencies, risks, decisions, testing activities, and status communications, while coordinating across BDO, Marketing Strategy, Service Teams, Fundraising OPS, Tech Solutions, and other partners to keep initiatives aligned and moving forward.
• 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; troubleshoot discrepancies by tracing query steps, comparing source records, and identifying likely causes.
• Assess query performance and make improvements to filters, joins, calculations, and query structure; escalate platform or pipeline issues when appropriate.
• Document reusable data sources, assumptions, query logic, business definitions, validation steps, known limitations and implementation decisions so work can be reviewed and reused.
• Communicate findings, risks, and data limitations clearly to marketing, operations, quality, and technical partners.

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 including text, email, direct mail, phone, and 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 effectively 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.

Preferred

• 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.