Technical Marketing Senior Associate, Campaign Management & Analysis,# 11907

Location: Riverwoods, IL UNITED STATESFunctional Area: MarketingMin Pay Rate: $0Max Pay Rate: $0Pay Type: YearResource Type: Full TimeJob Description: The position has full accountability for designing, coding and manipulating portfolio campaigns for various business units. The incumbent serves as a data expert working closely with marketing and technology business partners to execute daily, weekly, bi-weekly and monthly marketing campaigns. Working independently, they design workflows for campaign execution, coding and extrapolating data from internal data marts and flat file data sources. Other responsibilities include report design, data element identification and propagation, offer management, contact management and acceptance testing.RESPONSIBILITIES Design and code marketing campaigns using Affinium Campaign and SQL coding tools to extract and manipulate data. Manages both new campaign code development and existing campaign manipulation and maintenance. May use additional Affinium tools including Affinium Plan and Optimize. Primary responsibility will be handling the Usage and Retention campaign. Approximate campaign volume is 10-12 campaigns per month.Identify all necessary data elements for selection from appropriate tables and data sources. Test coding results in 10 and 100% environments.Work with Marketing partners to achieve desired campaign results. Develops waterfall reports and segmentation counts as well as other results to Marketing. Provides recommendations for improved campaign volume and results and identify any discrepancies. .Work with technology partners to ensure campaigns are executed efficiently and accurately.Validate results from nightly ETL (extract transform and load) processes to ensure accurate data loads. Identify any issues for escalation and correction.Continues to expand skills and knowledge.Assist with test case development and user acceptance testing for new data elements, database upgrades and tool enhancementsSKILLSRequired: Skills and Competencies:Thorough understanding and ability to apply marketing and technology principlesStrong oral and written communication skillsAbility to work independently and in a teamAbility to manage and code complex campaigns and multiple programsDetail-oriented and highly organizedAbility to communicate with al levels of management *hjDesired: Desired:SQL or SASUnixCampaign Management software Click here to apply: