Marketing Segmentation Specialist 2

Focus on the Family•Colorado Springs, CO

1d•Onsite

About The Position

The Marketing Segmentation Specialist 2 is responsible for identifying the target audience for email and direct mail communications by creating lists from SQL queries on relational databases. This role involves list extraction, segmentation, suppression, quality control, and source code mining to support multi-channel marketing campaigns, ensuring deadlines are met. The specialist will also contribute to data infrastructure needs and identify best practices for data mining within the Marketing Segmentation team, ensuring timely project delivery.

Requirements

Exemplifies Ephesians 5:1-2, “Therefore be imitators of God as dear children and walk in love, as Christ also has loved us and given Himself for us...”
Pursues the Great Commission given by Jesus Christ in Matthew 28:19-20, “Go therefore and make disciples of all the nations, baptizing them in the name of the Father and of the Son and of the Holy Spirit, teaching them to observe all things that I have commanded you; and lo, I am with you always, even to the end of the age.”
Is a consistent witness for Jesus Christ; maintains a courteous, Christ-like attitude in dealing with people within and outside of Focus; adheres to the Standard of Moral Conduct and Statement of Faith; upholds Focus on the Family's ministry in prayer
Prays personally for Focus on the Family’s staff and constituents and may occasionally lead in a public prayer
Engages in Christian ministry
Demonstrates behaviors aligned with FOF core values
Proven ability to accept responsibility, follows through, and meets deadlines
Good ability to communicate clearly in spoken English and through charts / reports
Proven ability to think logically and work methodically
Desire to learn, improve, and ask questions, commitment to excellence
Motivated and feels an appropriate sense of urgency, notifies manager when has time available to accomplish more
Willingness to take direction as well as work autonomously
No need for close supervision
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
Strong analytical, planning, organizational and problem-solving skills
Ability to work independently and to understand business data needs
Proven skills with spreadsheet development and data manipulation required

Nice To Haves

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
Advanced skill in use of SQL tools preferred

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
Monitors schedules and timelines to assure lists for communications are ready on the agreed upon date
Assures timely uploads of historical mail and digital files either by monitoring the work of others or by uploading the files directly and monitors the quality of list outputs through spot checking and other QC methods
Is responsible not only for project success, but also able to guide and motivate others to achieve deadlines.
Understands software utilized by the ministry (Salesforce, Marketing Cloud, Aprimo, SSMS)
Is responsible for ensuring lists accurately reflect businesses preferences, as well as constituent communication preferences
Manages multiple projects for several end-users
Keeps supervisor up to date on all efforts
Performs other duties as assigned