J

JP Morgan Chase

Runs a consumer bank and an investment bank

Quant Analytics

Data AnalysisPosted on Nov 9
Full-timePlano, TX, USANo salary listedIn-person

About the Job

Requirements

  • A Master's degree in Business Analytics, Statistics, Mathematics, Information Systems, Computer Science, or a related field and at least one year of experience in the job offered or a related occupation; alternatively, a Bachelor's degree in one of those fields or a related field and at least three years of such experience.
  • Experience combining data from different tables using SAS Data Step and SQL JOIN operations.
  • Experience manipulating data with SAS procedures, including Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary, and SAS data step programming.
  • Experience designing database structures for transactions and reporting, including setting up primary and foreign keys, unique constraints, and indexes.
  • Experience writing and optimizing SQL and stored procedures using CTEs, window functions, and partitioning to apply business rules and perform data quality checks.
  • Experience extracting data from databases, flat files, and external APIs using SAS and SQL.
  • Experience cleaning and preprocessing raw data for accuracy and consistency, and integrating multiple sources into datasets for analysis.
  • Experience administering key-based authentication using PuTTY for secure access to Linux and Unix servers.
  • Experience transferring files between environments and automating routine operations with core utilities for parsing log files and validating data extracts.
  • Experience overseeing processes and jobs, file permissions, and scheduled tasks across environments.
  • Experience writing startup scripts and environment profiles to standardize variables, library paths, and credential management using key stores.
  • Experience implementing job dependencies and conditions, including success, failure, or done conditions.
  • Experience building fault-tolerant schedules with retries, on-ice and on-hold states, and notification handlers; performing ad hoc reruns and backfills with audit notes; monitoring jobs through status dashboards and logs; and analyzing runtimes to identify bottlenecks and optimize batch chains.
  • Experience 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.
  • Experience parallelizing independent steps to reduce data-load wall-clock time.
  • Experience conducting analysis with Excel using queries 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.

Responsibilities

  • Partner with the business to create audiences for marketing and servicing communications across owned, paid media, and non-digital campaigns.
  • Support acquisition and engagement across credit card, auto, retail, home lending, and payments.
  • Define, size, and execute audiences.
  • Collaborate with business partners, using analytics and data insights to improve campaign performance.
  • Develop and manage customer attributes and research new data elements for insights.
  • Validate campaign populations to ensure marketing requirements are met.
  • Identify correlations and trends in data and communicate impacts that could affect campaign results.
  • Participate in quality code reviews and identify issues and errors for correction or improvement.
  • Recognize and implement global process-improvement ideas 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.

About the Company

JP Morgan Chase

Runs a consumer bank and an investment bank

JPMorgan Chase runs the largest bank in the United States, which serves households and small businesses as Chase and large companies, governments, and investors as J.P. Morgan. During the 2008 financial crisis it bought the failing investment bank Bear Stearns and lender Washington Mutual, and in 2023 it took over First Republic Bank after regulators seized it. Chase takes deposits and earns interest on credit cards, mortgages, and car loans, while the investment side earns fees for advising on mergers, raising money for companies, trading stocks and bonds, and managing wealth. Formed in a 2000 merger, JPMorgan Chase traces its roots to 1799 and is based in New York City.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1799

Recently Posted Jobs

Explore more opportunities at JP Morgan Chase

See more jobs