Regulatory External Data Services - Testing Senior Associate - SQL & Data Analysis

Aumni; Columbus (OH); On-site; USD 95,000 - 135,000; Full time

Job summary

Chase is seeking a Testing Senior Associate for the Regulatory External Data Services team. You will lead end-to-end testing, develop test cases, and ensure data accuracy for external filings, working with product owners, technology teams, and data owners.

This role emphasizes documentation, risk mitigation, and the proactive use of AI tools to improve testing efficiency while adhering to firm standards and regulatory requirements.

Qualifications

• Bachelor’s degree in Engineering, Business Management, Statistics or Accounting.
• 5+ years of experience in user acceptance testing, risk management, control evaluations, or related field.
• Experience with database systems (Databricks, Snowflake, Oracle, SQL Server, etc.).
• Proficiency with MS Office (Word, Excel, Access, PowerPoint).
• Proficiency with SQL (complex queries, large datasets).
• Ability to analyze issues, communicate insights to senior stakeholders, and mitigate risk.
• Ability to communicate regulatory guidance and ensure compliance.
• Organized, detail-oriented, and able to manage multiple priorities in a fast-paced environment.
• Strong analytical and communication skills.

Responsibilities

• Execute end-to-end testing activities including planning and reporting.
• Document results meticulously and ensure alignment with internal policies.
• Draft comprehensive final test summaries after business meetings.
• Apply testing techniques and critical thinking to identify weaknesses.
• Adhere to firm standards, regulatory requirements, and best practices.
• Collaborate with product owners to design effective test cases.
• Develop and execute robust test scripts to uncover issues.
• Document steps and results with sufficient justification for conclusions.
• Maintain thorough documentation to ensure transparency and traceability.
• Automate testing procedures where possible and leverage AI tools.

Skills

Analytical thinking

Communication with stakeholders

Risk assessment

Documentation

Education

Bachelor's degree in Engineering or related field

Tools

SQL

Tableau

Alteryx

Python

Snowflake

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 driving data 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.

Additional Information

Applicants must be authorized to work for any employer in the U.S. We are not able to provide immigration sponsorship or take over sponsorship of an employment Visa at this time. Final Job Grade level and corporate title will be determined at time of offer and may differ from this posting. This role does not provide relocation assistance so all candidates must be local to the work locations listed in the job posting or willing to relocate on their own immediately upon hiring.

Chase is a leading financial services firm, helping nearly half of America’s households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission‑based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on‑site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants’ and employees’ religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

Equal Opportunity Employer/Disability/Veterans

Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We’re proud to lead the U.S. in credit card sales and deposit growth and have the most‑used digital solutions – all while ranking first in customer satisfaction.

The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.

Play a crucial role in driving data quality and process optimization impacting critical bank filings