Testing Senior Associate - SQL & Data Analysis

JPMorgan Chase & Co.; Wilmington (DE); On-site; USD 90,000 - 130,000; Full time

Job summary

JPMorgan Chase & Co. is seeking a Testing Senior Associate to drive data quality for regulatory external data filings. You will design and execute testing, ensure completeness and accuracy, and maintain robust documentation. Collaboration with product owners, technology teams, and data owners is essential to success.

The role emphasizes data accuracy, quality controls, and the use of advanced testing techniques to support external reporting standards within a fast-paced banking environment.

Qualifications

• Bachelor’s degree required in a quantitative or business field.
• “5+ years of testing, risk assessment, or control evaluations”.
• Experience with databases and large datasets; strong SQL skills.
• Ability to analyze issues and communicate findings to senior stakeholders.
• Familiarity with regulatory guidance and data controls.

Responsibilities

• Execute end-to-end testing activities including planning and reporting.
• Document results with clear conclusions and traceability.
• Draft comprehensive final test summaries for alignment with partners.
• Develop test scripts and automate procedures where possible.
• Collaborate with product owners, developers, and data owners.
• Maintain thorough documentation to ensure transparency and accountability.
• Proactively adopt AI tools to improve testing efficiency.

Skills

5+ years testing

SQL

Data analysis

Regulatory filings

Documentation

Communication

Education

Bachelor's degree in Engineering

Bachelor's degree in Business Management

Bachelor's degree in Statistics

Bachelor's degree in Accounting

Tools

Databricks

Snowflake

Oracle

SQL Server

Tableau

Alteryx

Python

Job description

Join the Regulatory External Data Services team for a dynamic opportunity to advance your career while contributing to our mission of data excellence. As a Testing Senior Associate, you will play a crucial role in drivingdata quality and process optimization impacting critical bank filings. Our team values collaboration, innovation, and professional growth, providing you with the tools and support to excel.

As a Senior Associate in the Regulatory External Data Services team, you will be entrusted with upholding the highest standards of data accuracy, completeness, and transparency, which is mission-critical to JPMorgan Chase External Reporting Controllers. Your role will be pivotal in executing the testing process to ensure reporting is materially accurate, complete, and timely for external data filings. You will be tasked with developing and executing the testing cases, as well as maintaining documentation and control procedures. You will ensure successful testing by collaborating closely with product owners, and technology developers, and data owners.

Job responsibilities

• Execute end-to-end testing activities, including planning and reporting.
• Ensure compliance with internal policies and procedures including executing testing procedures, meticulously documenting results, drawing informed conclusions.
• Participate in business meetings to collaborate with business partners which includes drafting comprehensive final test summaries to ensure alignment and clarity.
• Utilize advanced critical thinking skills to apply substantive testing techniques and
• Adhere to firm standards, regulatory requirements, and industry best practices.
• Collaborate with product owners to support the design and effectiveness of test cases.
• Develop and execute robust test scripts aimed at identifying weaknesses.
• Document test steps and results in a comprehensive and organized manner, ensuring sufficient support and justification for testing conclusions.
• Maintain a high standard of documentation to facilitate transparency, traceability, and accountability.
• Automate testing procedures wherever possible and proactively adopt AI tools and technologies, in alignment with firm expectations for innovation and efficiency.

Required qualifications, capabilities, and skills

• Bachelor’s degree in Engineering, Business Management, Statistics, Accounting.
• 5+ years of experience or equivalent expertise in user acceptance testing, risk management assessment, control evaluations, or a related field.
• Experience with database management systems (e.g., Databricks, Snowflake, Oracle, SQL Server, etc.).
• Proficiency in MS (Microsoft Suite) Office such as Microsoft Word, Excel, Access, and PowerPoint.
• Proficiency with SQL (complex queries and working with large datasets).
• Demonstrated ability to analyze issues, develop and implement effective risk mitigation strategies, and communicate insights and recommendations clearly to senior stakeholders.
• Ability to develop and communicate recommendations based on regulatory guidance and standards, ensuring alignment with organizational goals and compliance requirements.
• Organized and detail-oriented, with the ability to manage multiple priorities and deliver results in a fast-paced environment.
• Strong analytical and communication skills, with the ability to convey information in a clear and concise manner.

Preferred qualifications, capabilities, and skills

• Experience within the financial services industry.
• A background in auditing and the ability to understand of internal controls is beneficial.
• Knowledge of data analytical tools such as Tableau, Alteryx or Python is a plus.
• Experience with cloud-based data solutions (e.g., AWS, Azure, Google Cloud).Experience with Java.

To be eligible for this role, you must be authorized to work in the United States. We do not offer any type of employment-based immigration sponsorship for this role. Likewise, JPMorgan Chase & Co. will not provide any assistance or sign any documentation in support of any other form of immigration sponsorship or benefit, including optional practical training (OPT) or curricular practical training (CPT).