CCOR - Senior Compliance Officer - Associate - Global Financial Intelligence Unit Data Analytics
Company: JPMorgan Chase Bank, N.A.
Posted on: May 3, 2021
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
Ideal candidate will be able to quickly prepare target data sets
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
3+ years of data analysis or related experience
Familiarity with Data Wrangling, Analytics and Visualization
Experience using various software tools, including Alteryx,
QlikView, Tableau, Jupyter Notebook, TOAD, IBM I2 Analyst
Bachelor's degree in Computer Sciences, Finance, Accounting or
SQL proficiency is a fundamental requirement and includes: the
ability to join multiple tables in queries, create and updating of
Working knowledge of the firm's data warehouse
Proficiency in applications such as Excel, Word, Power Point, Share
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
Equal Opportunity Employer/Disability/Veterans
Keywords: JPMorgan Chase Bank, N.A., Newark , CCOR - Senior Compliance Officer - Associate - Global Financial Intelligence Unit Data Analytics, Other , Newark, Delaware
Didn't find what you're looking for? Search again!