Corrections Data Analyst II

Columbus, OH (United States)

Category: Programming

Posted on: 13 Jan 2021

sql oracle r

The CCB correction analytics COE was built in 2017 with a vision to have high talent Data analysts centralized to support multiple LOB correction efforts including Consumer banking, Business banking, CWM and Credit Card. This COE model provides increased career mobility, better training, stronger controls and more opportunities to allow analysts to work across multiple LOBs. In order to excel in Correction analytics, the individual needs to be highly motivated, highly analytical, extremely detail oriented, and an exceptional problem solver who take pride in being part of the correction organization that owns customer's issues from the beginning to end, fix their problems and deliver great customer experiences.

Responsibility description
Develop code to identify correction population, financials, and/or create list and execution files for cases of medium to difficult complexity
Assist testing with understanding case requirements and code
Research cases to understand their breaks and how to use analytics to carry out requirements (Translate high level requirements to analytical steps)
Assist with process improvement/strategic team initiatives (e.g. OSU Analytics Program, recruitment, code standardization)
Manage case inventory of up to 15 cases
Act as Data analyst lead
+ Coach/teach/intervene as needed
+ Research and develop business requirements
+ Coach/teach analysts outside of managed book of work

Skill/competency requirements
Expertise and practical experience with pulling and wrangling data using SQL and SAS or other advanced programming skills (C++, R, Python, Stata, etc.)
+ Utilize data-step programming and PROC SQL to efficiently pull and manipulate data
+ Knowledge of analytical functions
+ Ability to write and read SAS macros
+ Able to pull data, aggregate/group by fields, and remove duplicate observations
+ Understanding of how to match tables without unique fields
Elevated proficiency with standard MS Office tools (Excel, Word, etc.)
Possess good verbal and written communication skills
+ Communicates thoughtfully and thoroughly
Ability to quickly self-learn different business and execute analytics projects
+ Understanding the business problem
+ Working out an analytical solution
+ Simplify complex issues
Identify and carry out programming steps to solve a problem
Analyst will frequently need to challenge and self-identify correction requirements
Ability to research data structure using front-end systems
Able to independently deep dive and do root cause analysis
Exhibit strong process adherence discipline
+ Throughout the life cycle of a project, specific process control procedures and documentation must be followed and completed by the DA (Corrections Data Analyst)
Must be detailed and quality assurance oriented
+ Willingness to ask questions to fully understand the break and correction activities
Be able to work multiple problems simultaneously
+ Typically a DA will be assigned two to three problems at once
Understanding of the data infrastructure in a financial services organization will be a plus
Detailed JPMC product, data table, and/or structure knowledge preferred
Proficient in Tera Data database environments. Oracle environments a plus.

Knowledge/experience/education requirements
Advanced SQL experience related to data wrangling and aggregation
Advanced SAS experience related to data-step programming
College degree and 5 + years experience
MS Office experience
Experience working on multiple projects at once
Experience redefining unclear business requirements
Experience leading a case/project
Advanced degree preferred
JPMC Product knowledge preferred
JPMC Data knowledge preferred
Experience with agile methodology preferred
Teradata and/or Oracle databases experience preferred

Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.

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


Want more jobs like this?

Apply Now

By clicking "Apply Now" or "Subscribe and Apply" you will be redirected to an external website. By clicking "Subscribe & Apply" you give TechieJobs consent to process and store your data, and send you job alerts to provided email.

Job Source: Stackoverflow (Will expire by: 2021-02-27 00:00:00)

Apply Now

Quick poll
How did COVID-19 affect your employment?
  • Nothing's changed
  • I now work from home
  • My salary decreased
  • I lost my job

* This poll is anonymous.