Hybrid Senior Marketing Campaign Data Architect (CDP & SQL)

Lighthouse Technology Services, Inc; Baltimore (MD); Hybrid; USD 59,000 - 98,000; Full time

Job summary

Lighthouse Technology Services is seeking a Senior Marketing Campaign Analyst for a 12+ month hybrid contract, with a preference for Baltimore, MD or Buffalo, NY. This on-site hybrid role is a W2 position.

You will translate business requirements into multi-channel campaigns, optimize audiences with Amperity CDP, write efficient SQL, document specs in Confluence, manage campaigns in Jira, and help govern data quality and governance across marketing operations, ensuring timely, compliant delivery.

Qualifications

• 8+ years of professional experience in marketing analytics, campaign management, or data management roles.
• Proven experience with Amperity or comparable customer data platform (CDP) and campaign management tools.
• Advanced SQL proficiency with demonstrated ability to write optimized queries for large datasets.
• Strong understanding of marketing campaign operations and multi-channel communication strategies.
• Expertise in translating business requirements into technical solutions and data deliverables.
• Experience with Confluence for documentation and Jira for agile project management.
• Demonstrated ability to collaborate across cross-functional teams including marketing, data quality, and technology stakeholders.

Responsibilities

• Drive marketing campaign delivery by translating business requirements into executable list pools across multiple channels.
• Manage campaign delivery operations using Amperity CDP, optimizing audience segmentation and targeting strategies.
• Write and optimize SQL queries to extract, transform, and deliver data for marketing communications.
• Partner with marketing relationship managers and channel managers to validate and internalize communication requirements.
• Support Customer 360 audience enablement initiatives by implementing data governance best practices.
• Document list requirements and campaign specifications in Confluence, ensuring cross-functional alignment.
• Collaborate with data quality control teams to validate requirements and ensure campaign accuracy.
• Facilitate data management working groups and provide guidance on governance, quality, and issue management.
• Measure compliance with enterprise data management policies and monitor data quality through KPIs and KRIs.
• Manage projects using Jira while following agile methodologies to ensure timely campaign delivery.

Skills

Marketing analytics

Campaign management

Data management

SQL proficiency

Cross-functional collaboration

Data governance

Audience targeting

Education

Bachelor's degree or equivalent

Tools

Amperity CDP

Jira

Confluence

Job description

Lighthouse Technology Services is seeking a Senior Marketing Campaign Analyst for a 12+ month hybrid contract, with a preference for Baltimore, MD or Buffalo, NY. This on-site hybrid role is a W2 position.

You will translate business requirements into multi-channel campaigns, optimize audiences with Amperity CDP, write efficient SQL, document specs in Confluence, manage campaigns in Jira, and help govern data quality and governance across marketing operations, ensuring timely, compliant delivery.