Job Information
Focus on the Family Marketing Segmentation Specialist 1 in Colorado Springs, Colorado
Headquartered in Colorado Springs, Colorado, Focus on the Family has nearly 700 employees who work to achieve the mission of enriching the lives of families, engaging the culture, advocating for life and spreading the Gospel of Jesus Christ. The work is meaningful, the culture is rewarding, and the purpose is eternal.
Emails are essential to our communication strategy with constituents. The Marketing Segmentation Specialist 1 position exists to be responsible for finding the right people to whom we will send these emails and therefore will be trained at creating lists from SQL queries on relational databases. This person will provide list extraction, segmentation, suppression, quality control, and source code mining in support of multi-channel marketing campaigns all while meeting deadlines. This person will also provide support for the data infrastructure needs and identifying best practices mining data for the Marketing Segmentation team.
Essential Duties/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
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
Coordinates with Email teams to ensure end to end processing of lists
Creates audience segmentations through SQL coding in relational databases
Develops a growing understanding of constituent demographic and transactional data and able to understand list requests for omni-channel segmentations
Other Duties/Responsibilities:
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
Keeps supervisor up to date on all efforts
Performs other duties as assigned
Working Environment/Physical Requirements:
Able to do 80-90% desk/computer driven tasks
JOB QUALIFICATIONS/REQUIREMENTS:
Character/Spiritual:
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 (http://media.focusonthefamily.com/fotf/pdf/about-us/human-resources/moral-policy.pdf) and Statement of Faith (http://www.focusonthefamily.com/about/foundational-values#values) ; 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 (http://www.focusonthefamily.com/about/foundational-values#values)
Personal Characteristics:
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
Knowledge/Experience:
Required:
Bachelor’s degree in Computer/Decision Sciences, Marketing, Math, Finance or Business; or equivalent experience
1-3 years of experience with complex relational databases
Basic knowledge of SQL
Preferred:
Data Warehouse Management knowledge
Working knowledge of SQL
Basic knowledge of SOQL
Familiar with omni-channel marketing trends and tools
Ability to work with data segmentation/campaign list management, Salesforce Marketing Cloud
Team Membership:
Learns from and provides learning opportunities for members of the Marketing Segmentation team to advance knowledge, skills, and expertise of the whole team.
Skills, Abilities, and Special Talents/Gifts:
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
Pay Range: $26.00 to $30.00/hr
Application Materials Required: Cover Letter, Resume/CV
Application Materials Instructions: Please identify the job specific minimum qualifications you possess in your cover letter and be sure your resume includes any and all relevant experience to be accurately assessed against the qualifications listed in the posting. To apply, please submit the following application materials to this posting. 1. A current resume. Must include date ranges to include month and year (mm/yyyy) and whether the position was full time or part time. 2. A cover letter that specifically addresses the job requirements and outlines qualifications.
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
Tentative Search Timeline:
Priority will be given to applications submitted by June 15th, 2024. However, this posting will remain open until filled.
The potential employee start date is June 24th, 2024.
Posting date: May 13th, 2024
Unposting date: ongoing until filled
Posting contact email: job@fotf.org
Helping Families Thrive in Christ! Focus on the Family is a 501c3 Christian Non-Profit Ministry.
Job Details
Pay Type Hourly