Campaign Analyst

Department: Business AnalyticsEmployment Type: Full TimeLocation: DallasReporting To: Michael HoranCompensation: $90,000 - $120,000 / yearDescriptionJoin a dynamic team and help drive targeted marketing strategy through data, analytics, and precision execution with Group O.Our client is seeking a highly skilled Campaign Analyst to support end-to-end campaign development, from gathering requirements to technical build and QA. If you’re analytical, detail-oriented, and experienced with SQL and campaign tools like IBM Campaign/Unica, this is an excellent opportunity to make an impact.Key ResponsibilitiesEssential FunctionsPartner with business stakeholders to gather requirements and translate them into accurate campaign designs.Build customer selections using IBM Campaign/Unica.Provide insights and recommendations to improve campaign strategy and targeting.Create use cases and test scenarios to validate campaign logic.Develop functional and technical specifications alongside cross-functional teams.Write and troubleshoot SQL to support backend processing and investigations.Perform detailed QA checks to ensure flawless campaign execution.Manage multiple projects in a fast-paced environment with shifting priorities.Education/CertificationsJob QualificationsBachelor’s Degree/Equivalent, or 3-5 years related experience.Preferred ExperienceExperience with AT&T products or databases is a plus.Adobe FAC/AJO/AEP experience is beneficial.Skills And QualificationsStrong SQL expertise: complex joins, aggregations, temp tables, data formatting, imports/exports.Excellent communication skills, both written and verbal.Project Management, Adobe Workfront, and experience in list management or campaign generation.Ability to work independently and collaboratively with strong attention to detail.Experience with ETL processes is a plus.Familiar with and has worked in IBM/Unica Campaign.Background in CRM, direct marketing, or campaign management.Strong analytical decision-making skills.Proficiency in Microsoft Office (Excel, Outlook, PowerPoint, Word).Be able to multitask in high-stress, fast-paced environments.Physical Requirements: N/ABenefitsMedical, Dental, Vision, and Life InsuranceFlexible Spending Accounts (Medical and Dependent Care)401(k) Plan with Company MatchGenerous Paid Time Off10.5 Paid HolidaysCareer Development Opportunities