Focus on the Family
Marketing Segmentation Specialist 2
Focus on the Family, Colorado Springs, Colorado, United States, 80509
Posted Tuesday, July 16, 2024 at 6:00 AMHeadquartered 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.The Marketing Segmentation Specialist 2 position exists to be responsible for finding the right people to whom we send communications 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, assuring timely delivery of projects.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.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.Manages multiple projects for several end-users.Keeps supervisor up to date on all efforts.Performs other duties as assigned.Managerial Breadth/Scope of Job:
Can provide some training for Marketing Segmentation Specialist 1.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.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.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.Knowledge/Experience:
Required: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.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:
Advanced skill in use of SQL tools preferred.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.Salary Range:
$58,236 to $67,077/yrApplication 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:A current resume. Must include date ranges to include month and year (mm/yyyy) and whether the position was full time or part time.A cover letter that specifically addresses the job requirements and outlines qualifications.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.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 August 16th, 2024. However, this posting will remain open until filled.The potential employee start date is August 19th, 2024.Posting date:
July 16th, 2024Posting contact email:
job@fotf.orgHelping Families Thrive in Christ! Focus on the Family is a 501c3 Christian Non-Profit Ministry.
#J-18808-Ljbffr
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.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.Manages multiple projects for several end-users.Keeps supervisor up to date on all efforts.Performs other duties as assigned.Managerial Breadth/Scope of Job:
Can provide some training for Marketing Segmentation Specialist 1.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.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.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.Knowledge/Experience:
Required: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.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:
Advanced skill in use of SQL tools preferred.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.Salary Range:
$58,236 to $67,077/yrApplication 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:A current resume. Must include date ranges to include month and year (mm/yyyy) and whether the position was full time or part time.A cover letter that specifically addresses the job requirements and outlines qualifications.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.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 August 16th, 2024. However, this posting will remain open until filled.The potential employee start date is August 19th, 2024.Posting date:
July 16th, 2024Posting contact email:
job@fotf.orgHelping Families Thrive in Christ! Focus on the Family is a 501c3 Christian Non-Profit Ministry.
#J-18808-Ljbffr