This role is for Data Testing Analyst in the Regulatory Reporting automation program . This individual will be responsible for assisting the Business Specialist Manager drive the definition, gathering, exploration, and analysis of Finance data to deliver the end-to-end automation of our regulatory reporting platform. This individual will assist the organization coordinate with several groups within American Express during designing, implementing, and migrating the implemented solution into production. The individual selected will partner closely with Business Specialist Manager and Product Owners to support defining functionality to be built, collaborate with Technology to design how functionality will work and validate at regular intervals that the software features developed align with original requirements provided to the team.

How will you make an impact in this role?

Support data analysis on existing processes and datasets to understand and support Point of Arrival (POA) process design

Support and guide determining portfolios, data elements and grain of data required for designing processes

Support team review data scenarios and provide clarification on how to report on these scenarios in alignment with regulatory guidance

Identify and support business requirements, functional design, prototyping, testing, training, and supporting implementations

Support developing functional requirement documents (FRDs) and process specific design documentation to support process and report owner requirements

Document and understand core components of solution architecture including data patterns, data-related capabilities, and standardization and conformance of disparate datasets

Support the implementation of master and reference data to be used across operational and reporting processes

Participate in daily meetings with the pods (implementation groups for various portfolios of the Company for data sourcing and regulatory classification and reporting).

Coordinate with various Product Owners, Process Owners, Subject Matter Experts, Solution Architecture colleagues, and Data Management team to ensure builds are appropriate for American Express products

Participate on user acceptance testing, parallel run testing, and any other testing required to ensure the build meets the requirements authored including development and execution of test cases, and documentation of results

Assist on development of executable testing algorithms that enable validation of the expected system functionality, including replication of deterministic logic and filtering criteria

Minimum Qualifications

SQL and data analysis experience

Product/platform understanding and process design experience

Knowledgeable about Financial Data Warehouse and Reporting Solutions (such as ODS, AxiomSL, OFSAA, and Hadoop concepts)

Knowledgeable in Data Analytics/profiling

Knowledgeable with creating S2T and Functional designs

Knowledgeable in creating Data Mappings, analyzing the SOR (System of Record) data, implementing Data Quality Rules to identify data issues in SORs

Experience with of MS Excel and Power Query

Testing management and execution experience

Foundational data warehousing principles and data modeling experience is a plus

Agile trained is a plus

Financial reporting or accounting experience is a plus

A good understanding of the banking products is a plus

Exhibits organizational skills with the ability to meet/exceed critical deadlines and manage multiple deliverables simultaneously

A self-starter, proactive team player with a passion to consistently deliver high quality service and exceed customers expectations

Excellent written and verbal communications with ability to communicate highly complex concepts and processes in simple terms and pragmatically across Finance, Business and Technology stakeholders

Excellent relationship building, presentation and collaboration skills

Preferred Qualifications

Knowledge of US Regulatory Reports (Y9C, Y14, Y15, 2052a, amongst others)

Working exposure in data analysis and testing of financial data domains to support regulatory and analytical requirements for large scale banking/financial organizations

Experience in development of testing automation capabilities

Experience in Cloud capabilities

Role: Business Analyst

Industry Type: Financial Services

Department: Data Science & Analytics

Employment Type: Full Time, Permanent

Role Category: Business Intelligence & Analytics

Education

UG: Any Graduate

PG: Any Postgraduate

About the company

At American Express, our culture is built on a 175-year history of courageous leadership, innovation, and an unwavering commitment to back our customers, communities, and colleagues. As part of Team Amex, you’ll experience this powerful backing with comprehensive support for your holistic well-being and many opportunities to learn new skills, develop as a leader, and grow your career.

With shared values and leadership behaviors, we’ll continue to set the standard for what it means to provide the best experience every day with premium products and services that help our customers achieve their aspirations. And we’ll do it in an environment where everyone is respected and valued and can reach their potential.

Here, your voice and ideas matter, your work makes an impact, and together, you will help us define the future of American Express.