Sirius XM seeks a Campaign Development Analyst with 4+ years of experience working with marketing databases and building and automating complex direct marketing campaigns in support of Marketing and Strategic Analytics business initiatives. Responsibilities include implementing campaign data requirements developed by internal business partners, developing functional specifications, producing and quality-testing campaign data files, identifying and remediating issues along the campaign development lifecycle, and managing relationships with marketing stakeholders. This is a fast-paced environment that requires working cross-functionally inside and outside the group and interacting with different departments across the company.
The ability to handle several campaign projects simultaneously is essential, as are strong communication and a project management skills. The Campaign Developer will develop a deep understanding of the functionality of the CRM interface, the content of the data warehouse, and the nuances of SiriusXM direct marketing business; the right candidate must enjoy and excel at problem-solving, troubleshooting, and root cause analysis. Expert SQL coding capabilities are a must. Candidates should have experience working with high-end CRM/Multi-Channel Campaign Management products; experience with Teradata marketing applications (Aprimo Relationship Manager) is preferred
Duties and Responsibilities:
Produce Campaign data lists and reports using CRM interface and/or custom SQL
Communicate campaign status updates to SME and marketing managers
Review and analyze business requirements, write Functional Specifications
Quality Control testing of campaign lists and/or Analytic reporting files
4+ yrs. practical experience in coding, testing and implementing marketing business intelligence campaign initiatives.
Strong affinity for and knowledge of big data environments, relational databases, data interrogation techniques, complex joins, complex segmentation, etc.
Familiarity with direct marketing business concepts and terminology
4+ yrs. SQL coding experience
BS/BA Degree and/or equivalent combination of education and experience required.
Good public speaking and presentation skills.
Interpersonal skills and ability to interact and work with staff at all levels.
Excellent written and verbal communication skills.
Ability to work independently and in a team environment.
Ability to pay attention to details and be organized.
Ability to project professionalism over the phone and in person.
Ability to handle multiple tasks in a fast-paced environment.
Commitment to "internal client" and customer service principles.
Willingness to take initiative and to follow through on projects.
Creative writing ability.
Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
Must have legal right to work in the U.S.
80% technical 20% functional
Experience with Teradata marketing applications (Aprimo Relationship Manager) or any campaign automation tool such as Unica/Adobe
Deep understanding and skills with Relational Databases and BI tools
Expert SQL coding skills -- develop, modify and improve complex SQL-based Stored Procedures
Experience with peer review
Experience with data mapping
Our goal at SiriusXM+Pandora is to provide and maintain a work environment that fosters mutual respect, professionalism and cooperation. SiriusXM+Pandora is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, national origin, ancestry, alienage or citizenship status, age, disability or handicap, sex, gender identity, marital status, familial status, veteran status, sexual orientation or any other characteristic protected by applicable federal, state or local laws.
The requirements and duties described above may be modified or waived by the Company in its sole discretion without notice.