Duties: Design, develop and execute code to define customer population to be targeted in servicing and marketing campaigns. Develop code based on the technical specification to extract and process large volumes of customer and account data. Guide the Marketer, Business Analyst and other campaign resources on ways to design complex audience selection. Provide ideas for global process improvements to increase department efficiency. Represent Audience Management team as a Subject Matter Expert in stakeholder meetings with IT and other areas. Provide recommendations and feedback on how to improve or implement control procedures. Maintain proper data control environment and work closely with Quality Validation and Control teams to ensure compliance with legal, marketing, and data use rules. Research data elements to be used for targeting using database metadata. Collaborate with business partners to gather targeting requirements for a campaign and establish business partnerships with other members of project teams. Develop and validate audit plan data validations to ensure targeted populations meet requirements. Participate in and perform code quality reviews. Assist in updating the department's documentation as needed. Identify relationships and trends in data, as well as any factors that could affect result of the campaign. Communicate impacts to business partners. Provide sample sizes per category to validate all components extracted and derived fields created. Prepare campaigns for post-processing Analytics and Reporting teams. Develop and maintain campaign run-books and training documentation for business resiliency. Mentor new and more junior Audience Management resources.
QUALIFICATIONS:
Minimum education and experience required: Master's degree in Business Analytics, Information Systems, Mathematics, Statistics, Engineering, Computer Science, or related field of study plus 3 years of experience in the job offered or as Quant Analytics Analyst, Data Scientist, Statistical Programmer, or related occupation. The employer will alternatively accept a Bachelor's degree in Business Analytics, Information Systems, Mathematics, Statistics, Engineering, Computer Science, or related field of study plus 5 years of experience in the job offered or as Quant Analytics Analyst, Data Scientist, Statistical Programmer, or related occupation.
Skills Required: This position requires 3 years of experience with the following: Running and creating code for campaign execution and data utilizing relational databases and records, such as Oracle, Teradata, or Snowflake; Auditing and reviewing the results of campaigns, as well as providing insights into campaign execution using Excel with formulas, pivot tables, and charts; Writing technical specification documents using Word and excel, using page setup, editing, and text formatting functions; Writing and executing shell scripts to automate processes and tasks related to campaign execution and data analysis, enhancing efficiency and accuracy in data handling. This position requires 1 year of experience with the following: Combining data from different tables using SAS Data Step and SQL JOIN operations; Manipulating data using SAS procedures including Proc Freq, Proc Format, Proc Sort, Proc SQL, Proc Summary, and SAS data step programming; Extracting data from databases, flat files, and external APIs using SAS and SQL; Writing SQL queries to retrieve data sets from relational databases and integrating data from multiple sources to create comprehensive data sets for analysis; Facilitating the execution and monitoring of scripts related to campaign execution and data understanding utilizing PUTTY for secure remote access to Unix systems; Running and creating scripts that support campaign execution and data analysis, including managing file systems and automating tasks using Unix; Implementing automation using Autosys to schedule and execute batch jobs related to campaign execution and data processing; Managing pages, uploading, and editing documents in MS Teams to facilitate collaboration and document sharing among project team members.
Job Location: 300 N King Street, Wilmington, DE 19801.
Full-Time.