Financial Systems Analyst I

At American Express, our culture is built on a 175-year history of innovation, shared values and Leadership Behaviors, 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.

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

Description:

The role is under Data Analytics and Testing Team which is a critical role in Regulatory Automations and Change Management (RACM)within Corporate Controllership (Finance), in support of the Regulatory Reporting Automation program. This individual will be responsible for driving and leading 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 Data Source teams and Product Owners to support defining functionality to be built, collaborate with Technology to design how functionality will work and design the validation process at regular intervals that the software features developed align with original requirements provided to the team.  

Responsibilities include, but are not limited to:

• Participate and lead 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.
• Data analysis to determine the required dataset portfolios, data elements and grain of data required for designing the Point of Arrival (POA) process design for FDIC370.
• Support team review data scenarios and provide clarification on how to report on these scenarios in alignment with regulatory guidance for FDIC370.
• Review and collaborate on functional requirement documents (FRDs) and process specific design documentation to support process and report owner requirements which are required for testing.
• Identify and support business requirements, functional design, prototyping, testing, training, and supporting implementations.
• Develop functional requirement documents (FRDs) and process design documentation to support process and report owner requirements which are required for testing.
• 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.
• 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.
• Support on development of executable testing algorithms using tools such as SQL, that enable validation of the expected system functionality, including replication of deterministic logic and filtering criteria
• Participate in daily meetings with the pods (implementation groups for various portfolios of the Company for data sourcing and regulatory classification and reporting). 

Minimum Qualifications

• Must have strong SQL and data analysis experience
• Must be able to write complex SQL, PL/SQL, HiveQL
• Knowledgeable about ODS, OFSAA, and Hadoop concepts
• Experience in Data Analytics/profiling
• Experience with creating S2T and Functional designs
• Experience 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
• 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
• Display thought leadership, drive process, and support work/life balance initiatives

Preferred Qualifications

• SQL writing and interpreting code relate to ODS, OFSAA and HIVE
• Prior exposure to FDIC370 compliance initiatives with knowledge on calculation rules
• Data Profiling/Data Analysis/Process design/Data usage
• Data sourcing/Transformations (understanding the data structure, transformations, and interrelationships)
• Problem solving skills/Free thinking
• Regulator Reporting/Financial Reporting