Job Summary: Audience Targeting partners with the Marketers to gather requirements, propose a design for targeting, segmentation and execute on the delivery of final audience. The team is also responsible for the development of code for data extraction and transformation, and deploying the audience into production. This role involves performing Business Analysis and Database Marketing functions for the execution of complex portfolio marketing campaigns and projects, using Base SAS programming and SQL querying. Job Responsibilities: Responsible for the development and execution of code to define customer populations to be targeted in complex marketing campaigns. Responsible for design of functional specification document used for execution of the campaigns Daily interactions with Marketers & project stakeholders on multiple projects - required to communicate and clarify requirements, results, and timelines Requires the ability to assess information extracted from multiple data sources, resolve inconsistencies, and transform high-level information into a detailed technical specification document. Adhere to process adherence requirements and checkpoints for campaign execution The candidate will also distinguish between requestors' wants and needs and to challenge assumptions in the programs and will recommend alternative solutions to technical and business related problems. Develop code based on technical specifications to extract and process large volumes of customer and account data. The candidate will need to validate, audit and test the output produced from their documents to ensure that the programs meets the original request. Adhere to the department's code development and documentation procedures. Provide recommendations and feedback on how to improve or implement strong control procedures. The candidate may also direct efforts with internal and external stakeholders to coordinate end to end process delivery. Provide support on Adhoc requests and special projects as assigned. Required Qualifications, Skills and Capabilities 5+ years extensive experience in developing Base SAS codes for manipulating large amounts of data and creating reports using procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditional SAS data step programming. Experience as Business Analyst in related domains Experience in requirement gathering and interacting with off-shore partners Experience in database querying (Oracle/Teradata) A background in marketing operations, direct marketing or data analysis. Strong analytical skills demonstrated by previous work experiences. Familiarity or experience in operations, direct marketing, and data analysis in a banking or financial institution environment a strong plus.
