Responsibilities

• Develops and maintains an understanding of ministry constituent and marketing productivity data structure
• Is current on data management trends and provides valuable insights on how best to serve up audience segments for ministry communications
• Develops an expertise in email preference management and the ministry data structure/flow for this data, including CANSPAM requirements for email list management
• Manages a complex marketing list schedule and delivers consistently on-time, accurate lists
• Develops and provides details for selection plans as outlined by the manager or project owner, develops selection recommendations independently and through brainstorming discussions
• Can follow complex cultivation and drip campaigns and then determine the data elements needed to make them happen
• Coordinates with Postal Affairs, Mailing Services and Email teams to ensure end to end processing of lists
• Creates complex audience segmentations through SQL coding in relational databases and troubleshoots data issues through problem solving and analytical skills
• Develops a growing understanding of constituent demographic and transactional data and able to advise and guide marketing list requests for omni-channel segmentations
• Audits lists selected by others in this position, or by other groups within the ministry and coordinates with other groups (internal or external) who may be participating in list selection

Requirements

• Bachelor’s degree in Computer/Decision Sciences, Marketing, Math, Finance or Business; or equivalent experience
• 2-4 years of experience with complex relational databases
• 1-3 years of experience creating data segmentations/campaign list management in Salesforce Marketing Cloud
• Robust understanding of meeting marketing objectives using queries, statistics, and analysis
• Working knowledge of SQL
• Preferred : Data Warehouse Management knowledge
• Advanced knowledge of SQL
• Working knowledge of SOQL
• Robust understanding with omni-channel marketing trends and tools
• Ability to work with data segmentation/campaign list management, Salesforce Marketing Cloud

Preferred

• Data Warehouse Management knowledge
• Advanced knowledge of SQL
• Working knowledge of SOQL
• Robust understanding with omni-channel marketing trends and tools
• Ability to work with data segmentation/campaign list management, Salesforce Marketing Cloud
• Project management experience

Benefits

• Focus on the Family puts a high value on our team members and offers a unique benefit package.
• Employees scheduled for 20 hours or more per week are eligible for: - Norton LifeLock ID Theft Coverage - Legal Shield/ID Shield Coverage - AFLAC - 403B Retirement Plan - Vacation Time & Vacation Payout - Sick Time - Holidays - Service Awards - Community Service Days - Bookstore Discount - Fitness Center Employees scheduled for 30 hours or more per week are eligible for all the above and: - Medical Plan - Dental Plan - Vision Plan - Life Insurance - Disability Insurance - Flexible Spending Accounts - EAP (Employee Assistance Program) - Tuition Reimbursement - Warehouse Membership Reimbursement Note: This is a summary and should not be construed as future promises to continue to provide benefits as outlined above. For complete and definitive language, refer to the governing plan documents. *Temporary employees are not eligible for benefits, except for: - Sick Time - Bookstore Discount - Fitness Center