Data Testing Analyst II

0 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description


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.
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 (Minimum experience - 4 plus years)
  • 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
  • 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
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 
  • 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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
American Express logo
American Express

Financial Services

New York

RecommendedJobs for You

Bengaluru South, Karnataka, India

Bengaluru South, Karnataka, India

Bengaluru South, Karnataka, India

Bengaluru South, Karnataka, India