What are the responsibilities and job description for the Quantitative Analytics [Multiple Positions Available] position at JPMorgan Chase?
DESCRIPTION:
Duties: Design, develop and execute code to define customer population in servicing and marketing campaigns. Develop code based on the technical specification to extract and process large volumes of customer and account data. 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 used for targeting using database metadata. Collaborate with business partners to gather targeting requirements for a campaign and establish strong business partnerships with other members of project teams. Develop and validate audit plan, such as data validations to ensure targeted populations meet requirements. Perform code quality reviews, suggest process improvements, and assist in updating the department's documentation. Identify relationships and trends in data, as well as any factors that could affect results of the campaign. Communicate impacts to business partners and provide sample sizes per category to validate all components extracted and derived fields created. Prepare campaigns for post-processing Analytics and Reporting teams.
QUALIFICATIONS:
Minimum education and experience required: Master's degree in Business Analytics, Economics, Statistics, Mathematics, or related field of study plus one (1) year of experience in the job offered or as Quantitative Analytics, Global Supply Chain Analyst, Market Research Analyst, or related occupation. Experience may be gained pre- or post-bachelor's degree. The employer will alternatively accept a Bachelor's degree in Business Analytics, Economics, Statistics, Mathematics, or related field of study plus three (3) years of experience in the job offered or as Quantitative Analytics, Global Supply Chain Analyst, Market Research Analyst, or related occupation. Experience may be gained pre- or post-bachelor's degree.
Skills Required: This position requires experience with the following: Using SAS Data Step and SQL JOIN operations to combine data from different tables; Manipulating large amounts of data using SAS procedures including Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary, as well as SAS data step programming; Working with millions of records, in relational databases including Oracle, Teradata, and Snowflake, to run and create code for campaign execution and understanding data; Extracting data from databases, flat files, and external APIs using SAS and SQL; Writing SQL queries to retrieve specific data sets from relational databases and integrating data from multiple sources to create comprehensive data sets for analysis; Utilizing PUTTY for secure remote access to Unix systems, facilitating the execution and monitoring of scripts related to campaign execution and data understanding; Employing Unix for running and creating scripts that support campaign execution and data analysis, including managing file systems and automating tasks; Using Excel with basic formulas, pivot tables, and charts for auditing and reviewing the results of campaigns, as well as providing insights into campaign execution; Writing technical specification documents using Word and excel, using basic page setup, editing, and text formatting functions; Managing pages, uploading, and editing documents in MS Teams to facilitate collaboration and document sharing among project team members; Implementing automation using Autosys to schedule and execute batch jobs related to campaign execution and data processing; Writing and executing shell scripts to automate processes and tasks related to campaign execution and data analysis. Experience may be gained pre- or post-bachelor's degree.
Job Location: 300 N King St., Wilmington, DE 19801.
Full-Time.