American Express - Analyst - Operations Excellence - SQL

Analyst - Operations Excellence - Strong SQL Coding

Function Description

The US Consumer Operational Excellence team is the First Line of Defense (FLoD) team with a mission to enable business growth and objectives while maintaining a strong control environment. The Operational Excellence team acts as a Center of Excellence (CoE) within the business, and assists in the identification, measurement, monitoring, and management of Operational Risks related to the business products and processes. Operational risk is the risk to the current or projected business objectives and resilience arising from inadequate or failed internal processes or systems, human errors or misconduct, or adverse external events.

This team's scope includes multiple business verticals across the US Consumer landscape.

In line with Amex's "three lines of defense" approach to risk management, the FLoD Operational Excellence team actively works with Second Line of Defense and Third Line of Defense teams to ensure adequate implementation of risk management framework requirements.

Qualifications:

- 3+ year of experience with data-driven analytics

- Preferred experience in financial services and risk management

- Preferred Postgraduate degree in Statistics/Mathematics/Economics/Engineering/Management

- Knowledge of risk management and key credit risk metrics

- Should be a person with strong analytical thinking and skills who can undertake below steps independently

- Identify problems / opportunities at hand

- Gather information on process flow, data, system, and related losses / events

- Develop hypothesis to opportunities / problems identified

- Use data analytics to prove your hypothesis, identify root cause (if applicable) and size the opportunities / problems (if applicable)

- Draw conclusion based on analysis conducted

- Be able to solve business problems in complex and unstructured environment

- Highly detail oriented

- Team player with strong communication skills, and ability to develop relationships with colleagues.

- Self-motivated with the ability to operate independently and handle multiple workstreams and ad-hoc tasks simultaneously.

- Experience compiling information and developing thoughtful material for presentation.

Technical Skills and Platform Knowledge:

- Expertise in SQL and / or SAS

- Knowledge in Cornerstone is plus

- Application of statistical techniques preferred

- Knowledge of platforms Hadoop and Big Data

- Preferred experience with COSMOS/Tableau