Financial Systems Analyst I - Regulatory Data Sourcing
American Express
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.
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?
Key Responsibilities:
- Collaborate with business stakeholders to understand the data needs for regulatory reporting, Translate the business requirements into technical specifications for data solutions.
- Develop and implement 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
- Collaborate with data governance team to define standards and ensure data quality and consistency in RRDD
- Data sourcing gap analysis and profiling of attributes and complete source to target mapping document for 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.
- Support 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 analysis.
- 3+ years of work experience in Banking / Regulatory / Financial / Technology Services.
- Product Management, data migration, data analytics working experience is a plus.
- 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 and Hive experience.
- Experience with of MS Excel, Power Query, and other analytical tools, e.g., Tableau.
- Experience with Python, Google Big Query, PL SQL.
- 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
- Knowledge of US Regulatory Reports (Y9C, Y14, Y15, 2052a, amongst others), and general understanding of the banking products.
- Working exposure in data analysis financial data domains to support regulatory and analytical requirements for large scale banking/financial organizations
- Experience in Google Cloud capabilities
We back you with benefits that support your holistic well-being so you can be and deliver your best. This means caring for you and your loved ones' physical, financial, and mental health, as well as providing the flexibility you need to thrive personally and professionally:
- Competitive base salaries
- Bonus incentives
- Support for financial-well-being and retirement
- Comprehensive medical, dental, vision, life insurance, and disability benefits (depending on location)
- Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need
- Generous paid parental leave policies (depending on your location)
- 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
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.
Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.