Marketing Segmentation Specialist 2

Focus on the Family • Colorado Springs, CO

102d • $62,431 - $74,783

About The Position

The Marketing Segmentation Specialist 2 supports Focus on the Family’s email, direct-mail, and other multichannel marketing communications by identifying appropriate audiences and producing accurate, timely marketing lists. The role creates complex audience segmentations using SQL queries against relational databases and performs list extraction, suppression, quality control, and source-code mining. It also supports data infrastructure needs and helps identify effective data-mining practices for the Marketing Segmentation team.

The specialist develops expertise in constituent and marketing data structures, email preference management, and applicable CAN-SPAM requirements. The position manages complex list schedules and multiple projects, develops selection plans and recommendations, coordinates end-to-end list processing with internal teams, audits list selections, and monitors project timelines and output quality. The role may guide and motivate others to meet deadlines and provide some training to Marketing Segmentation Specialist 1 staff.

The position requires a bachelor’s degree in Computer/Decision Sciences, Marketing, Math, Finance, or Business, or equivalent experience; experience with complex relational databases and Salesforce Marketing Cloud campaign list management; and working SQL knowledge. The posted pay range is $62,431 to $74,783. The potential start date is May 26, 2026.

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 or managing campaign lists 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.
• Proven spreadsheet-development and data-manipulation skills.
• Ability to work independently and understand business data needs.
• Proven ability to accept responsibility, follow through, and meet deadlines.
• Ability to communicate clearly in spoken English and through charts and reports.
• Ability to think logically and work methodically; willingness to learn, improve, ask questions, and pursue excellence.
• Motivation and an appropriate sense of urgency, including notifying the manager when available to take on more work.
• Willingness to take direction and work autonomously without close supervision.
• Must meet the employer’s stated character and spiritual expectations, including adherence to its Standard of Moral Conduct and Statement of Faith, and demonstrate behavior aligned with its core values.

Nice To Haves

• Data warehouse management knowledge.
• Advanced knowledge of SQL.
• Working knowledge of SOQL.
• Robust understanding of omnichannel marketing trends and tools.
• Experience with data segmentation or campaign list management in Salesforce Marketing Cloud.
• Project management experience.
• Advanced skill in using SQL tools.

Responsibilities

• Develop and maintain an understanding of ministry constituent and marketing productivity data structures.
• Stay current on data management trends and provide insights on serving audience segments for ministry communications.
• Develop expertise in email preference management, the ministry data structure and flow for this data, and CAN-SPAM requirements for email list management.
• Manage complex marketing list schedules and deliver accurate lists consistently on time.
• Develop selection-plan details as directed by a manager or project owner, and make selection recommendations independently and through brainstorming discussions.
• Follow complex cultivation and drip campaigns and determine the data elements needed to execute them.
• Coordinate with Postal Affairs, Mailing Services, and Email teams to ensure end-to-end list processing.
• Create complex audience segmentations using SQL in relational databases and troubleshoot data issues using problem-solving and analytical skills.
• Develop understanding of constituent demographic and transactional data and advise and guide marketing list requests for omnichannel segmentations.
• Audit lists selected by others in the position or by other ministry groups, and coordinate with internal or external groups participating in list selection.
• Monitor schedules and timelines to ensure communication lists are ready by the agreed-upon dates.
• Ensure timely uploads of historical mail and digital files, either by monitoring others’ work or uploading files directly, and monitor list-output quality through spot checks and other quality-control methods.
• Take responsibility for project success and guide and motivate others to meet deadlines.
• Understand software used by the ministry, including Salesforce, Marketing Cloud, Aprimo, and SSMS.
• Ensure lists accurately reflect business and constituent communication preferences.
• Manage multiple projects for several end users.
• Keep the supervisor informed about ongoing efforts.
• Provide some training for Marketing Segmentation Specialist 1.
• Learn from and provide learning opportunities to Marketing Segmentation team members to advance the team’s knowledge, skills, and expertise.
• Perform other duties as assigned.

Benefits

• Employees scheduled for 20 or more hours per week are eligible for Norton LifeLock ID Theft Coverage, Legal Shield/ID Shield Coverage, AFLAC, a 403(b) retirement plan, vacation time and vacation payout, sick time, holidays, service awards, community service days, a bookstore discount, and a fitness center.
• Employees scheduled for 30 or more hours per week are eligible for the benefits listed for employees scheduled for 20 or more hours, plus medical, dental, and vision plans; life and disability insurance; flexible spending accounts; an Employee Assistance Program; tuition reimbursement; and warehouse membership reimbursement.
• Temporary employees are not eligible for benefits except sick time, bookstore discount, and fitness center access.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level