Financial Systems Analyst

You Lead the Way. We've Got Your Back.
With the right backing, people and businesses have the power to progress in incredible ways. When you join Team Amex, you become part of a global and diverse community of colleagues with an unwavering commitment to back our customers, communities and each other. Here, you'll learn and grow as we help you create a career journey that's unique and meaningful to you with benefits, programs, and flexibility that support you personally and professionally.
At American Express, you'll be recognized for your contributions, leadership, and impact—every colleague has the opportunity to share in the company's success. Together, we'll win as a team, striving to uphold our company values and powerful backing promise to provide the world's best customer experience every day. And we'll do it with the utmost integrity, and in an environment where everyone is seen, heard and feels like they belong.
Join Team Amex and let's lead the way together.
Our industry is rapidly evolving, and we need courageous, quick thinkers who can shape the strategic decisions that lead our business forward. Whether it's negotiating with some of our largest global partners or creating next year's financial plan, you can influence both our day-to-day P&L and the future direction of the company. As part of the team, you can have the opportunity to learn and use the latest data tools and technologies and explore a range of roles to grow your career. Find your place in finance on #TeamAmex.
The Financial Data Sourcing Analyst is a critical role in Financial Reporting Quality Assurance Organization (FRQA) within Corporate Controllership, in support of the Regulatory Reporting Automation program. This role is responsible for driving the definition, gathering, exploration, and analysis of finance data and its data sources to deliver the end-to-end automation for our regulatory reporting platforms.  
The Data Sourcing Architect team oversees the data mapping, profiling and source to target (S2T) analysis mapping for new data requirements of our regulatory reporting automation and systems, as well as leading the coordination / orchestration of the close partnership between Product Owners, Report / Business Owners, Technology and Data Testing teams to determine data / product features of the data solution are put into production with the highest degree of confidence of the data flow and data system requirements or the deactivation / decommission of data sets of financial data systems.
The Data Sourcing Analyst must be a highly analytical, well-organized, data-driven individual wit time management and a high degree of technical skills confident in presenting, highly complex data concepts and technicalities in simple terms and pragmatically to the team and associated stakeholders.
How will you make an impact in this role?
Collaborate with business stakeholders to understand the data needs for regulatory reporting, Translate the business requirements into technical specifications for data solutions
Support Development and implementation of data management strategies for Regulatory Reporting Data Domain(RRDD), Design and maintain RRDD data models to support regulatory reporting and ensure its scalable and flexible.
Partner with business, upstream and Technology teams to implement data solutions for regulatory reporting, Monitor and optimize data systems for performance and efficiency
Exposure to both Basel Standardized and Advanced approaches is required including knowledge to subject areas of Market Risk, CVA Risk, Counterparty Credit Risk in additional to Credit Risk.
Knowledge of US Regulatory Reports (Y9C, Y14, Y15, 2052a, amongst others), and general understanding of the banking products.
Collaborate with data governance team to define standards and ensure data quality and consistency in RRDD
Data sourcing gap analysis and profiling of attributes for Fast Forward and regulatory reports automation
Conduct data analysis on existing processes and datasets to understand and support Point of Arrival (POA) process designs including migration of RRDD tables from On Prem to BigQuery.
Experience to determine portfolios, data elements and grain of data required for designing processes to review data scenarios, providing clarification on how to report on these scenarios in alignment with regulatory guidance.
Development of executable data querying algorithms using tools such as SQL, that enable validation data conformity and expected data system functionality, including replication of deterministic logic and filtering criteria for master and reference data to be used across operational and regulatory reporting processes.
Identification of business requirements and development of functional requirement documentation for new data sources and attributes, including design, prototyping, testing, and implementation of report owner and regulatory requirements.
Document and understand core components of solution architecture including data patterns, data-related capabilities, and standardization and conformance of disparate datasets.

Minimum Qualifications
3+ years of work experience in Data Sourcing and Analytics.
3+ years of work experience in Banking / Regulatory / Financial / Technology Services.
Strong knowledge and working experience in Basel Capital Adequacy regulations is required.
Experience with Python is required.
Experienced in Agile delivery concepts or other project management methodologies.
Experience in data analytics, data profiling, Source to Target (S2T) data mapping, analyzing the System of Record (SOR) data and its Data Quality (DQ) rules to identify data issues in SORs.
Strong SQL / NoSQL and data analysis experience, able to write / understand complex SQL, HiveQL, with hands-on Oracle SQL, DBeaver and Hive experience.
Experience with Big Data frameworks;  Spark, Hive, Hadoop, Flink, Operational Data Stores (ODS), amongst other foundational data warehousing and modeling principles.
Experience with of MS Excel, Power Query, and other analytical tools, e.g., Tableau.
Critical thinking and complex problem-solving skills (data application).
Excellent written and verbal communications with ability to communicate highly complex concepts and processes in simple terms and pragmatically.
A self-starter, proactive team player with excellent relationship building and collaboration skills, facilitating a network of strong relationships across the organization.

Preferred Qualifications
Any exposure to US NPR regulations is preferred.
Product Management, data migration, data analytics working experience is a plus.
Experience with Google Cloud, Big Query, Machine Learning and Data Automation / Visualization techniques is a plus.

Considerations for sponsorship:
Depending on factors such as business unit requirements, the nature of the position, cost and applicable laws,
American Express may provide visa sponsorship for certain positions
Salary Range: $55,000.00 to $105,000.00 annually + bonus + benefits
The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we'll consider your location, experience, and other job-related factors.
We back our colleagues and their loved ones with benefits and programs that support their holistic well-being. That means we prioritize their physical, financial, and mental health through each stage of life. Benefits include:
Competitive base salaries 
Bonus incentives 
6% Company Match on retirement savings plan 
Free financial coaching and financial well-being support 
Comprehensive medical, dental, vision, life insurance, and disability benefits 
Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need 
20+ weeks paid parental leave for all parents, regardless of gender, offered for pregnancy, adoption or surrogacy 
Free access to global on-site wellness centers staffed with nurses and doctors (depending on location) 
Free and confidential counseling support through our Healthy Minds program 
Career development and training opportunities

For a full list of Team Amex benefits, visit ourColleague Benefits Site.
American Express is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law.
We back our colleagues with the support they need to thrive, professionally and personally. That's why we have Amex Flex, our enterprise working model that provides greater flexibility to colleagues while ensuring we preserve the important aspects of our unique in-person culture. Depending on role and business needs, colleagues will either work onsite, in a hybrid model (combination of in-office and virtual days) or fully virtually.
US Job Seekers/Employees -Click here to view the "Know Your Rights" poster and the Pay Transparency Policy Statement.
If the links do not work, please copy and paste the following URLs in a new browser window: https://www.dol.gov/agencies/ofccp/posters to access the three posters.