8675 - Portfolio Campaign Management Associate

Position provides the data expertise and analytical support required to identify and correlate appropriate market segment and campaign frame work to achieve portfolio marketing campaign objectives.The position has full cycle accountability for the designing, coding and manipulation of information to customize and refine content and market segment of portfolio campaigns for various business units. As data experts, incumbents work 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.RESPONSIBILITIESDesigns and codes marketing campaigns using the Affinium and SAS coding tools to extract and manipulate data. Performs new campaign code development and existing campaign manipulation and maintenance.Identifies all necessary data elements for selection from appropriate tables and data sources.Tests coding results in 10 and 100% environments
Presents results, works with marketing partners to tune and refine information and makes recommendations to improve campaign volume, results and to identify any discrepancies.Works with technology partners, across organizational boundaries to ensure campaigns are executed efficiently and accurately
Validates results from nightly ETL (extract transfer and load) processes to ensure accurate data loads.Assists with test case development and user acceptance testing for new data elements, database upgrades and tool enhancement
Continues to expand skills and knowledge
Performs other duties of similar nature and complexity, as assigned. REQUIREMENTS
REQUIRED SKILLS:
Education:Bachelor’s degree required. Concentration in business, marketing, information systems or quantitative economics, as well as an advanced degree preferred.
Experience:Minimum of 2-4 years experience using SAS/SQL/Excel/Unica or other Campaign Management Processing Tools such as Affinium to extrapolate, manipulate and present data, preferably in credit card industry.
Skills and Competencies: General knowledge of marketing and finance principles.Fully functional in all Microsoft Office applications.Knowledge and ability to apply one or more query language, SAS and Affinium coding tools.Proficient written and oral communications skills.Ability to interact with all levels of the organization.Ability to stay on task, work within tight time constraints and meet deadlines.Ability to perform work both independently and as part of a team, as well as achieve results cross functionally.Strong customer service orientation and commitment.
DESIRED SKILLS: