CCOR - Senior Compliance Officer - Associate at JPMorgan Chase Bank, N.A. in Newark, Delaware

Job Description:

Key Responsibilities:

• Utilization of SQL skills to query the firm's data warehouse. Activities include: identification of all JPMC account relationships pertaining to select individuals, extraction of transactional history for demand deposit and credit cards, as well as performing targeted searches based on ZIP and NAIC codes.

• Researching data sources to support investigative objectives

• Extraction and preparation of data sets

• Refinement and enrichment of data to support analytics

• Creation of targeted reports and visualizations to support investigative efforts

• Ideal candidate will be able to quickly prepare target data sets for investigators

• Support investigators by utilizing the firm's data warehouse to enrich the initial investigative dataset with information concerning subjects: banking products, transaction history, online logins, demographics and KYC.

• Translate investigator requests into tactical SQL queries that can utilized for data extraction.

• Validate data provided for both completeness and accuracy

Qualifications:

• 3+ years of data analysis or related experience

• Familiarity with Data Wrangling, Analytics and Visualization concepts

• Experience using various software tools, including Alteryx, QlikView, Tableau, Jupyter Notebook, TOAD, IBM I2 Analyst Notebook

• Bachelor's degree in Computer Sciences, Finance, Accounting or related discipline

• SQL proficiency is a fundamental requirement and includes: the ability to join multiple tables in queries, create and updating of tables

• Working knowledge of the firm's data warehouse

• Proficiency in applications such as Excel, Word, Power Point, Share Point

• Exhibit Intellectual Curiosity

• Ability to work independently

• Problem solving strength is a must, as periodically new and unique requests are presented.

• Ability to multitask and meet deadlinesJPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.

Equal Opportunity Employer/Disability/Veterans