JPMorgan Chase
From JPMorgan Chase's careers page
Status: listed on the employer's own careers page when we last checked (daily). Confirm on their site before applying.
Duties: Partner with business to create audiences for Marketing & Servicing communications through multiple channels including owned, paid media and non-digital campaigns. Support acquisition and engagement across credit card, Auto, Retail, Home Lending and Payments. Define, size, and execute on audiences. Collaborate with business partners by leveraging analytics and data insights to improve campaign performance. Develop and manage customer attributes and research new data elements for insights. Produce data validations on campaign populations to ensure marketing requirements are met. Identify correlations and trends in data and communicate impacts that could affect results of the campaign. Participate in quality code reviews and identify issues and errors for correction or improvement. Recognize and implement ideas for global process improvements to increase department efficiency. Represent the Audience Management area in technical meetings with IT and other areas. Mentor new and more junior Audience Management resources.
Minimum education and experience required: Master's degree in Business Analytics, Statistics, Mathematics, Information Systems, Computer Science, or related field of study plus 1 year of experience in the job offered or as Quant Analytics, Logistic Engineer, Data Scientist, Logistic Coordinator, or related occupation. The employer will alternatively accept a Bachelor's degree in Business Analytics, Statistics, Mathematics, Information Systems, Computer Science, or related field of study plus 3 years of experience in the job offered or as Quant Analytics, Logistic Engineer, Data Scientist, Logistic Coordinator, or related occupation.
Skills Required: This position requires 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, and Proc Summary, as well as SAS data step programming; Designing database structures for transactions and reporting; set up primary/foreign keys, unique constraints, and indexes; Writing and optimizing SQL and stored procedures using CTEs, window functions, and partitioning to apply business rules and run data quality checks; Extracting data from databases, flat files, and external APIs using SAS and SQL; Cleaning and pre-processing raw data to ensure accuracy and consistency; Integrating data from multiple sources to create data sets for analysis; Administering key based authentication using PuTTY for secure access to Linux and Unix servers; Transferring files for controlled movement of extracts, logs, and deployment artifacts between environments; Automating routine operations with core utilities for parsing log files and validating data extracts; Overseeing processes and jobs, file permissions, and scheduled tasks across environments; Writing startup scripts and environment profiles to standardize variables, library paths, and credentials management using key stores; Implementing job dependencies and conditions such as success, failure, or done; Building fault tolerant schedules with retries, on ice and on hold, and notification handlers; Performing ad hoc reruns and backfills with audit notes; Monitoring job via status dashboards and logs; Analyzing runtimes to identify bottlenecks and optimize batch chains; Developing parameterized Bash scripts to orchestrate end to end ETL flows, fetch inputs, archive outputs, emit structured logs, and run SQL via sqlplus, bteq, and db2cli; Parallelizing independent steps to reduce wall clock time for data loads; Conducting analysis with Excel using Querying and joins, Subqueries and CTEs, Aggregation, Window and analytic functions, Conditional and null handling, String and text functions, Date and time functions, Numeric and type conversion, Set operations, DML, DDL and physical design, Performance and tuning, and Temporary and utility objects.
Job Location: 8181 Communications Pkwy, Plano, TX 75024.
Full-Time.
Scores your resume against this job the way resume scanners do: the job's hard and soft skills, searchability, recruiter tips and formatting.
Create a free account to see your score. Your resume stays in this browser until then, and we never store it.
Already a member? Sign in