Quant Analytics [Multiple Positions Available]

JPMorganChase•Wilmington, NC

2d•Onsite

About The Position

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.

Requirements

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.
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.
3 years of experience running and creating code for campaign execution and data utilizing relational databases and records, such as Oracle, Teradata, or Snowflake.
3 years of experience auditing and reviewing the results of campaigns, as well as providing insights into campaign execution using Excel with formulas, pivot tables, and charts.
3 years of experience writing technical specification documents using Word and excel, using page setup, editing, and text formatting functions.
3 years of experience writing and executing shell scripts to automate processes and tasks related to campaign execution and data analysis, enhancing efficiency and accuracy in data handling.
1 year of experience combining data from different tables using SAS Data Step and SQL JOIN operations.
1 year of experience manipulating data using SAS procedures including Proc Freq, Proc Format, Proc Sort, Proc SQL, Proc Summary, and SAS data step programming.
1 year of experience extracting data from databases, flat files, and external APIs using SAS and SQL.
1 year of experience writing SQL queries to retrieve data sets from relational databases and integrating data from multiple sources to create comprehensive data sets for analysis.
1 year of experience facilitating the execution and monitoring of scripts related to campaign execution and data understanding utilizing PUTTY for secure remote access to Unix systems.
1 year of experience running and creating scripts that support campaign execution and data analysis, including managing file systems and automating tasks using Unix.
1 year of experience implementing automation using Autosys to schedule and execute batch jobs related to campaign execution and data processing.
1 year of experience managing pages, uploading, and editing documents in MS Teams to facilitate collaboration and document sharing among project team members.

Responsibilities

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.