Marketing Segmentation Specialist 2

Both Email and Direct Mail are essential to our communication strategy with constituents. The Marketing Segmentation Specialist 2 position exists to be responsible for finding the right people to whom we send these 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 Duties/Responsibilities:Develops and maintains an understanding of ministry constituent and marketing productivity data structureIs current on data management trends and provides valuable insights on how best to serve up audience segments for ministry communicationsDevelops an expertise in email preference management and the ministry data structure/flow for this data including CANSPAM requirements for email list managementManages a complex marketing list schedule and delivers consistently on-time accurate listsDevelops and provides details for selection plans as outlined by the manager or project owner develops selection recommendations independently and through brainstorming discussionsCan follow complex cultivation and drip campaigns and then determine the data elements needed to make them happenCoordinates with Postal Affairs Mailing Services and Email teams to ensure end to end processing of listsCreates complex audience segmentations through SQL coding in relational databases and troubleshoots data issues through problem solving and analytical skillsDevelops a growing understanding of constituent demographic and transactional data and able to advise and guide marketing list requests for omni-channel segmentationsAudits 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 selectionMonitors schedules and timelines to assure lists for communications are ready on the agreed upon dateAssures 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 methodsIs responsible not only for project success but also able to guide and motivate others to achieve 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 preferencesManages multiple projects for several end-usersKeeps supervisor up to date on all effortsPerforms other duties as assignedManagerial Breadth/Scope of Job:Can provide some training for Marketing Segmentation Specialist 1Working Environment/Physical Requirements:Able to do 80-90% desk/computer driven tasksJOB 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 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 a consistent witness for Jesus Christ; maintains a courteous Christ-like attitude in dealing with people within and outside of Focus; adheres to theStandard of Moral ConductandStatement of Faith; upholds Focus on the Familys ministry in prayerPrays personally for Focus on the Familys staff and constituents and may occasionally lead in a public prayerEngages in Christian ministryDemonstrates behaviors aligned withFOF core valuesPersonal Characteristics:Proven ability to accept responsibility follows through and meets deadlinesGood ability to communicate clearly in spoken English and through charts / reportsProven ability to think logically and work methodicallyDesire to learn improve and ask questions commitment to excellenceMotivated and feels an appropriate sense of urgency notifies manager when has time available to accomplish moreWillingness to take direction as well as work autonomously No need for close supervision Knowledge/Experience:Required:Bachelors degree in Computer/Decision Sciences Marketing Math Finance or Business; or equivalent experience2-4 years of experience with complex relational databases1-3 years of experience creating data segmentations/campaign list management in Salesforce Marketing CloudRobust understanding of meeting marketing objectives using queries statistics and analysisWorking knowledge of SQLPreferred:Data Warehouse Management knowledgeAdvanced knowledge of SQLWorking knowledge of SOQLRobust understanding with omni-channel marketing trends and toolsAbility to work with data segmentation/campaign list management Salesforce Marketing CloudProject management experienceTeam MembershipLearns from and provides learning opportunities for members of the Marketing Segmentation team to advance knowledge skills and expertise of the whole Abilities and Special Talents/Gifts: Advanced skill in use of SQL tools preferredStrong analytical planning organizational and problem-solving skillsAbility to work independently and to understand business data needsProven skills with spreadsheet development and data manipulation requiredPay Range: $60324 to $72258Application Materials Required: Cover Letter Resume/CV*Colorado Residents: In any materials you submit you may redact or remove any age-identifying information such as age date of birth or dates of school attendance or graduation. You will not be penalized for redacting or removing this 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. 2. A cover letter that specifically addresses the job requirements and outlines on the Family puts a high value on our team members and offers a unique benefit scheduled for 20 hours or more per week are eligible for:Norton LifeLock ID Theft CoverageLegal Shield/ID Shield CoverageAFLAC403B Retirement PlanVacation Time & Vacation PayoutSick TimeHolidaysService AwardsCommunity Service DaysBookstore DiscountFitness CenterEmployees scheduled for 30 hours or more per week are eligible for all the above and:Medical PlanDental PlanVision PlanLife InsuranceDisability InsuranceFlexible Spending AccountsEAP (Employee Assistance Program)Tuition ReimbursementWarehouse Membership ReimbursementNote: 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 TimeBookstore DiscountFitness CenterTentative Search Timeline:Priority will be given to applications submitted by May 20 2026 However this posting will remain open until potential employee start date is May 26 2026Posting date: April 20 2026Un-posting date: ongoing until filledPosting contact email: